Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)Beginner
MICROSOFT & ANALYTICS TRAINING · NAIROBI, KENYAMicrosoft & data analytics
Microsoft & data analytics
training that moves Kenyan careers forward.
Instructor-led training in Advanced Excel, Power BI, Financial Modeling, Power Query and Data Analytics — for professionals, finance teams, NGOs and corporate groups across Kenya and East Africa.
Live online Westlands, Nairobi Individuals Corporate & NGOs
500+ professionals trained
50+ corporate & NGO clients
East Africa live online & on-site delivery
For Individuals & Graduates
Join scheduled cohorts and learn live from an expert instructor — Microsoft skills that show up on your CV and stand out in Kenyan job interviews.
For Corporate Teams & NGOs
Tailored programmes for finance, M&E and operations teams — delivered at your office in Nairobi, on-site across Kenya, or live online.
Our courses
Microsoft productivity & data analytics training — taught by experienced instructors in Nairobi and live online across East Africa.
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)Intermediate
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)Advanced
Power BI
Turn raw data into interactive reports and dashboards stakeholders actually use.
2 days (14 hours)
Power Query
Automate messy data preparation with repeatable, refreshable ETL workflows.
1 day (7 hours)
Microsoft Project
Plan, schedule and track projects with confidence using industry-standard tools.
2 days (14 hours)
Microsoft Word
Produce polished professional documents — from reports to long-form publications.
1 day (7 hours)
Advanced Excel for Professionals
Corporate-grade Excel training for Kenyan finance, operations and analytics teams who need to ship reliable reports fast — now including Power Query, Power Pivot and AI-powered productivity with Copilot.
3 days (21 hours)Advanced
Financial Modeling Masterclass
Build investor-ready three-statement models, DCF valuations and sensitivity analyses in Excel.
3 days (21 hours)
What you'll walk away with
Every OCL course is built around real Kenyan workplace tasks — so the skills you learn show up in your reports, dashboards and decisions from week one.
Job-ready skills
Practical Excel, Power BI and analytics techniques you can apply at your desk the very next day.
Certificate of completion
Earn an OCL Learning certificate to add to your CV and LinkedIn profile — recognised by employers across Kenya.
Workbooks & datasets
Take home every exercise file, Kenyan dataset and a step-by-step workbook to revisit any topic.
Flexible scheduling
Weekday, evening and weekend cohorts — plus on-demand corporate sessions to fit your team's calendar.
Small class sizes
Cohorts are capped so your trainer can answer your questions and review your work in class.
Lifetime email support
Hit a snag months later? Send us your file — we'll help you apply what you learned.
Your learning path
Start with the fundamentals and progress to advanced analytics and BI — at your own pace, in the order that fits your role in Nairobi or wherever you work.
01
Foundations
Excel Basic & MS Word — confident workbook navigation, formatting and everyday formulas.
02
Intermediate
Excel Intermediate & MS Project — lookups, pivot tables and structured project plans.
03
Advanced analytics
Advanced Excel, Power Query & Power Pivot — reshape messy data and automate reporting.
04
BI & modelling
Power BI, Financial Modeling and Data Analytics — dashboards leadership actually uses.
Who our courses are for
Finance & accounting teams
Master pivot tables, Power Query and Power BI to close the books and report faster.
Project managers
Plan, schedule and track delivery with MS Project — and brief stakeholders with crisp dashboards.
Operations & data analysts
Turn raw data into insight with Advanced Excel, Power Query and BI visualisations.
NGOs & M&E professionals
Donor reporting, programme dashboards and analytics built for development organisations.
Job seekers & graduates
Add in-demand Microsoft skills to your CV and stand out in interviews across Kenya.
Corporate L&D leaders
Roll out tailored upskilling programmes for whole departments — at your office or online.
VISIT OUR TRAINING CENTRE
In Westlands, Nairobi
Drop by our training centre for in-person classes in a modern, fully equipped classroom — or join the same instructor live online from anywhere in Kenya and East Africa.
- 27 Church Road,
Westlands, Nairobi - +254 790 706 395
- info@opencastlabs.co.ke
Popular training in Kenya
Advanced Excel, AI training, AI-driven analytics and business analytics — delivered in Westlands, Nairobi and live online across Kenya and East Africa.
Advanced Excel training
Formulas, Power Query, Power Pivot, dashboards and automation for Kenyan workplaces.
AI training
Microsoft Copilot, Claude and Claude Cowork applied to real analysis and reporting.
Business & data analytics
From raw data to dashboards leadership acts on — Power BI, Power Query and DAX.
Finance & reporting
Financial modeling, budgeting, forecasting and ERP reporting for finance teams.
Frequently asked questions
Where can I do Advanced Excel training in Nairobi, Kenya?
OCL Learning runs Advanced Excel training at our Westlands, Nairobi centre (27 Church Road) and live online across Kenya and East Africa. The course covers advanced formulas, Power Query, Power Pivot, dashboards and AI add-ins, and runs as public cohorts or private corporate sessions.
Do you offer AI training for professionals in Kenya?
Yes. Our AI training covers Microsoft Copilot, Claude and Claude Cowork applied to real workplace tasks — analysing data, drafting reports, building models and automating spreadsheet work. It is available as AI Driven Analytics, AI-Driven Financial Modeling and Data Analytics for Business + AI.
What is AI-driven analytics and who is it for?
AI-driven analytics combines Excel, Power Query, Power BI and DAX with AI assistants that speed up cleaning, exploration and insight generation. It suits analysts, finance teams, M&E officers and managers in Kenya who already work with data and want faster, more reliable answers.
How much does business analytics training cost in Kenya?
OCL Learning courses range from about KES 10,000 for foundation courses to KES 45,000 for premium 3-day programmes such as AI-Driven Financial Modeling. Corporate group rates and in-house delivery across Kenya are quoted on request.
Do you provide certificates and corporate in-house training?
Every learner receives an OCL Learning certificate of completion. We also deliver in-house training for corporates, banks, SACCOs, NGOs and government teams at your offices in Nairobi, anywhere in Kenya, or live online.
Can I train online from Mombasa, Kisumu or outside Kenya?
Yes. Every course runs live online with the same instructor, exercise files and support, so professionals in Mombasa, Kisumu, Nakuru, Eldoret and across East Africa can join from anywhere.
Ready to upskill your team?
Tell us your goals and we'll recommend the right course and format.