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