CALL FOR APPLICATION FOR TRAINING ON TENDER PREPARATION WITH UMUCYO E-PROCUREMENT, ADVANCED EXCEL, WEB DESIGN WITH REACT FRAMEWORK

Title: call for application for training on tender preparation with umucyo e-procurement, Advanced Excel, Web design with react framework.

1. About Us:Omega Engineering Systems LTD is a leading IT Company and short courses training provider in Rwanda, Located at Kigali – Rwanda, Eden House Former Athene Building, room 67.We provide professional Training services in tender preparation both private and public, umucyo e-procurement system and other platforms,IT trainings .

We also provide support services in tender preparation, Air Conditioning , Software development, web design, CCTV camera and network installation, maintenance of IT equipment and IT advisory.

2 . Background of the trainingIf you are an entrepreneur or an individual interested to learn and enhance your skills in tender preparation both private and public with navigation to umucyo e-procurement system, web design with react framework, advanced excel.

Look for Omega Engineering Systems LTD is proud to present our upcoming trainings.

Course Content

3.1 private and public tender preparation training

Client and Service ProviderWhat is a tenderType of tendersTypes of restricted tenderCategories of tendersTendering from the Buyer’s Point of ViewTendering from the Bidder’s Point of ViewWhere are Tenders Published ?What is an institution ?Type of Institutions ?Tendering preparation processWhat is tender evaluationPurpose of tender evaluationType of tender evaluationRequest for a clarificationWhat is a tender committee ?What is an appeal panel review?Reporting process and type of reportContract management

3 .2 Navigation to Umucyo e-procurement system other systems

To Analyze the procurement planTo search for advertised TenderTo upload a prepared tenderTo look for a tender notificationContract management moduleOne stage tendering and two stage tenderingNotification and communication

3.3 Advanced Excel

3.3.1 Advanced Microsoft ExcelShortcuts

Excel customization (Quick Access Toolbar, Ribbon)Hidden features and lesser-known functionsTroubleshooting common Excel errorsFunction keysPivot keyboard shortcutsData conversion,

3.3.2 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 FunctionsAdvanced conditional formatting techniquesArray FormulasRounddown, Roundup, RoundLenPower PivotLeft, Right, Mid, Search, FindNow, Today, Time, Datedif, Month, Day, Weekday, YearIndex, MatchWorkbook and Worksheet Protection

Advanced Excel Data Entry, Cleaning, Analysis,

Visualization, and Reporting Techniques.

Data entry techniquePivotTables and Pivot ChartsData validation and data filteringAdvanced sorting and filtering techniquesSubtotal and summary functionsWhat-If analysis with Scenario Manager and Goal SeekUsing slicers to filter data through the pivot tableCharts, Graphs & Visualizations .

3.4 Web design with react

HTML, CSS, JAVA SCRIPT, PHP, MYSQL

4.Training Objective

The training aims to enhance participants' knowledge and skills in tender preparation both private and public with navigation to umucyo e-procurement system, web design with react framework, advanced excel in order to enable them to be competent on job market.

5 .Targeted Participant:

All candidates with at least A2 certificate or Bachelor degree or master degree or other are allowed to apply for a tender preparation with umucyo e-procurement and advanced excel training .All candidates with at least A2 certificate or Bachelor degree or master degree are allowed to apply for web design with react framework training .

6 . Tuition fees :

Tuition fees is 100,000 rwf for an advanced Excel.Tuition fees is 150,000 rwf for tender preparation both private and public with umucyo e-procurement and other platform.Tuition fees is 300,000 rwf web design with react framework .

7.Training Period

7.1 Daily Program

Time: 18h - 20h . Hours per day : 2 hours .

7.2 Weekend Program

Saturday-Sunday

Time : 9h – 14hHours per day : 4hours

8.Course Duration

8.1 Daily Program

15 days for a tender preparation both private and public withumucyo e-procurement and other platforms.10 days for an advanced excel training30 days for web design with react framework .

8.1 Weekend Program

8 days for a tender preparation both private and public withumucyo e-procurement and other platforms .8 days for an advanced excel training.30 days for web design with react framework.

9. Output for the Training

9 .1 Output for a tender preparation both private and public with umucyo e-procurement and other platforms .

To get a clear understanding of bidding process.To gain knowledge and skills in tender preparation and Costcontrol and budgetingTo be familiar with umucyo e-procurement Platform and other…