If you apply for more than one courses there will be a 10% discount. you are all most welcome.
Services

Training Services

Tender Preparation both public and private


We teach the following course contents in tender preparation both public and private:

  •  Client and Service Provider
  • What is tender
  •  Type of tenders
  • Types of restricted tender
  • Categories of tenders
  • Tendering from the Buyer’s Point of View
  • Tendering from the Bidder’s Point of View
  • Where are Tenders Published ?
  • What is an institution ?
  •  Type of Institutions ?
  • tendering preparation process
  • What is tender evaluation
  •  Purpose of tender evaluation
  •  Type of tender evaluation
  • Reporting process and type of report
  • Contract management
Practice
Duration 20days
Navigation to Umucyo e-procurement system

  • To search for advertised Tender
  • To upload a prepared tender
  • To look for a tender notification
  • Contract management.


Practice

Duration 2 days
Software development

We teach the following programming language:

  • Python programming
  • Java programming

We also teach front end development:

  • React with html, css and java script.

Duration is 45 days.

We also teach back end development:

  • Java and spring boot.


Duration is 45 days
Web Design

We also teach web design using html, css, javascript,php and database.

Duration is 45 days.

Advanced Excel

we teach the following :

 Advanced Microsoft Excel Shortcuts

  • Excel customization (Quick Access Toolbar, Ribbon)
  • Hidden features and lesser-known functions
  • Troubleshooting common Excel errors
  • Function keys
  • Pivot keyboard shortcuts
  • Data conversion

Advanced Microsoft Excel Formulas and Functions

  • Logical Functions (IF AND NOT & OR FUNCTION KEYS)
  • Lookup and reference functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX, MATCH)
  • Text functions (CONCATENATE, LEFT, RIGHT, MID)
  • Statistical functions (AVERAGE, AVERAGEIFS, COUNT, COUNTIFS, SUMIFS)
  • Nested Functions
  • Advanced conditional formatting techniques
  • Array Formulas
  • Round down, Roundup, Round Len
  •  Power Pivot
  • Left, Right, Mid, Search, Find
  • Now, Today, Time, Datedif, Month, Day, Weekday, Year
  • Index, Match
  • Workbook and Worksheet Protection
  • Advanced Excel Data Entry, Cleaning, Analysis,
  • Visualization, and Reporting Techniques.
  • Data entry technique
  • PivotTables and Pivot Charts
  • Data validation and data filtering
  • Advanced sorting and filtering techniques
  • Subtotal and summary functions
  • What-If analysis with Scenario Manager and Goal Seek
  • Using slicers to filter data through the pivot table
  • Charts, Graphs & Visualizations in excel

Other Services

Assistance in tender preparation

We also provide assistance in tender preparation both public and private ( supply, work, consultancy)

Software development and web design

We do software development such as mobile application, web application and desktop application.

Maintenance of IT equipment

We also do maintenance of IT equipment such as servers, photocopiers, printers, air conditioners and other IT equipments.

Network and CCTV Camera Installation

  • Cabling
  • Installation
  • Configuration
IT advisory

We also do IT advisory in:

  • IT strategies.
  • Software development.
  • Network and information security.

An Avanced Excel


Excel customization (Quick Access Toolbar, Ribbon)

Hidden features and lesser-known functions

Troubleshooting common Excel errors

Function keys

Pivot keyboard shortcuts

Data conversion,

Advanced Microsoft Excel Formulas and Functions

  • Logical Functions (IF AND NOT & OR FUNCTION KEYS)
  • Lookup and reference functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX, MATCH)
  • Text functions (CONCATENATE, LEFT, RIGHT, MID)
  • Statistical functions (AVERAGE, AVERAGEIFS, COUNT, COUNTIFS, SUMIFS)
  • Nested Functions
  • Advanced conditional formatting techniques
  • Array Formulas
  • Rounddown,
  • Roundup, Round Len
  • Power Pivot
  • Left, Right, Mid, Search, Find
  • Now, Today, Time, Datedif, Month, Day, Weekday, Year
  • Index, Match
  • Workbook and Worksheet Protection
  • Advanced Excel Data Entry, Cleaning, Analysis,
  • Visualization, and Reporting Techniques.
  • Data entry technique
  • PivotTables and Pivot Charts
  • Data validation and data filtering
  • Advanced sorting and filtering techniques .
  • Subtotal and
  • summary functions .
  • What-If analysis with Scenario Manager and Goal Seek
  • Using slicers to
  • filter data through the pivot table
  • Charts, Graphs & Visualizations in Excel
 
Scroll to Top