Tender preparation training with umucyo e-procurement  and others platforms , an advanced excel In order to become more competitive  entrepreneur  to run business and analyse  your  data in 2024

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, Software

Development, Web design, Advanced Excel.

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.

Background of the training

If you are an entrepreneur or an individual interested to learn and enhance your skills in advanced excel and tender preparation both private and public , navigation to umucyo e-procurement system .
Look for Omega Engineering Systems LTD is proud to present our
upcoming training designed for you.
Our expert instructor will guide you through interactive sessions and hand on exercises to help you understand the concepts and practices better.

Our training programs will cover everything you need to know
about :

Course Content

private and public tender preparation training

• Client and Service Provider
• What is a 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
• Request for a clarification
• What is a tender committee ?
• What is an appeal panel review?
• Reporting process and type of report
• Contract management

 Navigation to Umucyo e-procurement system other systems

• To Analyze the procurement plan
• To search for advertised Tender
• To upload a prepared tender
• To look for a tender notification
• Contract management module
• One stage tendering and two stage tendering
• Notification and communication

Advanced Excel

Advanced Microsoft ExcelShortcuts

• 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

Training Objective

The training aims to enhance participants' proficiency in Advanced Excel, focusing on data analysis and management  and reporting skills and to enable them to create a local database to manage their store : inventory management

Targeted Participant:

All people who are interested in enhancing their knowledge and skills in Excel.

Tuition fees :

• Tuition fees was 100,000 rwf for an advanced excel per individual , it is now 80,000 per individual .
• Tuition fees was 150,000 rwf for tender preparation both private and public with umucyo e-procurement and other platform , it is now 120,000 rwf .

 Training Period

Daily Program

              Time: 18h - 20h .

             Hours per day : 2 hours .

 Weekend Program

Time :  15h – 18h30

Hours per day : 3hours 30

Course Duration

Daily Program

20 days for a tender preparation both private and public with umucyo e-procurement and other systems 15 days for an advanced excel training

Weekend Program

10 days for a tender preparation both private and public with umucyo e-procurement and other systems .

10 days for an advanced excel training .

Output for the Training

Output for a tender preparation both private and public with umucyo e-procurement and other systems

• To get a clear understanding of bidding process.
• To gain knowledge and skills in tender preparation and Cost
• control and budgeting
• To be familiar with umucyo e-procurement Platform and other platforms .
• Learn how to navigate and utilize popular e-procurement platforms
• efficiently, bidding process and contract management.
• To know how to prepare any tender
• This training will increase business avenues and employability opportunities.

Output for an advance excel

• Participant will gain theoretical and practical knowledge and skills on dvanced excel features and functions, enabling them to handle complex data analysis tasks more effectively. 
• Participants will be able to apply advanced data analysis techniques using Advanced Excel .
• The participants will be able to create more sophisticated and visually appealing reports using Advanced Excel .
• This training will increase business avenues and employability opportunities.

Why attend?

• Boost your career: to boost your resume on Job market.
• Networking: to network with other professionals.

Who is to attend ?

• Entrepreneur or interested individual with at least A2 secondary
  school certificate or fresh graduate, graduate, master degree holder and above .

 Training Schedule:

 Daily Program

 Start Date and End Date for a tender preparation both private and public with umucyo e-procurement and other platforms : 20/12/2024 -20 /1/2025

Start Date and End Date for an advanced excel :  20/12/2024 -13/1/2025

N.B: 25/12/2024 will be xmas and 1/1/2025 will be new year: we will not conduct a training .

 Weekend program

Start Date and End Date for a tender preparation both private and public with umucyo e-procurement and other platforms : 21/12/2024 to 26/1/205

Start Date and End Date for an advanced excel :   21/12/2024 to 26/1/2025

How to Register

• To register Go to jobs in Rwanda website:   , or click on  https://omensy.com/training/or call us on 0788454033 for more clarification.  

 Responsibilities For Each Side

Omega Engineering Systems LTD is responsible to :

• To provide a contract to the trainee.
• To provide training during work and calendar days and the
• training period is 2 Hours per day for a daily program and 3 hours 30 for a weekend program .
•  To provide an EBM receipt to the trainee once the payment is done by a trainee.
• To Provide a Training Certificate after program completion.

Trainee is responsible 

• To use his own laptop.
• To attend a training as specified in terms and condition of the contract.
• To pay the tuition and fees as specified in payment modalities.
• To book your space, kindly proceed by paying the training fees
• through the following bank details:
• Account Name: OMEGA ENGINEERING SYSTEMS LTD
• Account Number: 20085308001 opened at I&M bank
• Account Currency: RWF

In case you use the bank payment please Scan the bank slip and send it to omegasystem2024@gmail.com or call us on 0788454033 bring the hard copy of the bank slip to Omega Head office located at Nyarugenge, athene Building room 67.

Certificate

At the end of the training, we provide a certificate of completion .

Venue

The training will take place at ecole secondaire saint joseph near saint famille catholic church .

Application Link 

Deadline No later 29th December 2024

Conclusion

We can offer those trainings needed by institutions for their staff at their office or as per their plan . 

Managing Director

Omega engineering systems LTD

Bagirigomwa Patrick