Call for Application for an Advanced Excel Training and Tender Preparation Both Private and Public With Umucyo E-procurement

Call for Application for an Advanced Excel Training and Tender Preparation Both Private and Public With Umucyo E-procurement

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 :

Advanced Excel

• Training Objective

The training aims to enhance participants’ proficiency in Advanced Excel, focusing on data analysis and reporting skills.

Targeted Participant

• Data Analyst
• Financial Analyst
• Business Analyst

Others

 Course Content

 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

Tuition and Fees

Training Cost is 100,000 rwf .

Training Period

Time: 18h – 20h 30 .

Start date and End date

18/11/2024 – 4/12/2024

Course duration : 15 days .

Facilitator For an advanced excel

A facilitator has a bachelor degree in Computer Science with a relevant experience in Providing IT trainings such as an Advanced excel, java , database and so on .

Output for the Training

• Participant will gain theoretical and practical knowledge and skills onadvanced 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.

Private and public tender preparation training

 Course Content

• 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:

• To Analyze the procurement plan
• To search for advertised Tender
• To upload a prepared tender
• To look for a tender notification
• Contract management module

Facilitator for tender preparation both private and public with umucyo e-procurement :

Bachelor degree in computer engineering and a certificate in public procurement procedures and 3 years of working experience in tendering process .

Why attend?

• 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:
• Learn how to navigate and utilize popular e-procurement platforms
• efficiently, bidding process and contract management.
• 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 duration is for 20 Days: work days.

Training Schedule:

• The training will run from 18h to 20h30 .
• Start Date and End Date: 18/11/2024 – 10/12/2024

 How to Register

• To register, or call us through the provided contacts.
• Tell: 0788454033 or come to our office for more clarification.

Tuition and fees

• Tuition fees is now 150,000 Rwf with VAT
• Inclusive per individual for Tender Preparation and umucyo e procurement system.
• 2.7 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.
  To provide an EBM receipt to the trainee once the payment is
• done by trainee.
• To Provide a Training Certificate after program completion.

Trainee is responsible is responsible to:

• 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 .

Application Link: Click here to apply

Venue

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

Conclusion

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