Website: https://omensy.com/
Promotion : Chrismas and new year offer : 20 % discount offer,
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
29/11/2024
