12 practical topics, three days in Nairobi, and the report you dread rebuilt once properly — so next month it is a refresh and a click.
Practical learning experiences delivered across Africa. A few moments from previous Vantage Africa cohorts:
Most people’s Excel problem is not knowledge. It is rebuilding the same thing every month, for a request nobody explained, in a workbook nobody else dares open.
Power Query turns the hour you spend tidying an export into a step that repeats itself when next month’s file arrives.
A short video on why the formula is the easy half of the job.
Video holder · Add approved clip hereA model built on what somebody has to decide, not on everything the system happened to export.
Anybody can be shown a formula. The difference is knowing which question the numbers are being asked, building something that still works next month, and producing an answer somebody will act on.
The pathway is designed around what you will be able to do. You begin guided virtual learning as soon as you register, then build on it during three practical days in Nairobi, 26–28 April 2027.
The question, the clean-up and the formulas everything else is built on.
Three focused days building the model, the dashboard and the automation, in Nairobi.
Proposed allocation: topics 1–5 are guided online and cover the question and the formula groundwork; topics 6–12 are worked through during the three physical days, on your own file, with a facilitator beside you.
Explore each topic below. The real test is whether the thing still works when next month’s file lands.
A spreadsheet that works once is not a model. What gets checked here is whether it refreshes rather than rebuilds, whether somebody else can open it and follow it, and whether every number survives the question of where it came from.
Join the 12-topic pathway →The messy export you actually receive, not a tidy sample.
In Power Query, so next month is a refresh rather than a repeat.
Inputs, workings and outputs kept apart, with the assumptions written down.
A dashboard or a summary built on the question that was actually asked.
To a peer who has never seen it — and watch what they break.
The reference material comes with the programme. The thing worth carrying home is your own monthly report taken apart and rebuilt once — cleaned in a query, modelled properly, and automated far enough that next month is a file drop and a refresh.
StudyGenius guides you through progressive skill-building, practice, feedback and applied challenges. Try a lesson free.
Explore StudyGenius ↗Video placeholder — insert an approved clip of a monthly report being refreshed in one click.
You are not simply buying training days. You are investing in hours your team stops losing every month, and a community of peers.
18,000+ professionals trained across 30+ countries, including government, NGO and development-sector teams.
Guided by Dr. Benson Kiarie and experienced faculty; every exercise runs on files from real organisations.
Observable work, feedback and practical checks — and a report that runs itself when you get back.
Right now the request comes to you because you can get the data out. After this it comes to you because you can say what the data means — which way it is moving, what is driving it, and what the organisation should do before the next cycle closes. Same desk, different conversation.
See the 12 topics →The tooling buys back the time. The analysis is what you spend it on: trends instead of totals, a model instead of forty lookups, and a recommendation instead of an attachment.
Three of the 12 topics are given to the analysis rather than the software.
The programme is built around practical work rather than attendance. You bring the file you actually receive, rebuild your own report on it, and leave with that report automated rather than with notes about how it could be.
Yes. The pathway covers all 12 topics, 5 guided online and 7 in the room, subject to the programme’s formal assessment decisions.
The first 5 are introduced through guided online work before the workshop and cover the question and the formula groundwork. The remaining 7 form the focus of the three physical days in Nairobi, spent building on your own file.
Yes. Under the standard-fee pathway, the $80 initial payment counts toward $580 and leaves $500 payable. The $480 offer is for early full payment, not the instalment plan.
The programme is planned for Nairobi, Kenya on 26–28 April 2027. The exact venue will be confirmed by the Vantage Africa team before a final booking commitment.
Microsoft 365 or Excel 2021 for the dynamic array functions and XLOOKUP. Bring a laptop you can install nothing on if you must — Power Query and Power Pivot are already in it.
No. The automation topic starts from recording a macro, and most people never need to write code beyond editing what the recorder produced.
Yes. Contact Vantage Africa for an invitation letter, invoice or a tailored in-house proposal.
Let us tailor Excel, business analytics or a bespoke reporting-automation pathway to your organisation, sector and challenges.
Contact Dr. Benson · +254 725 303 645 · bkiarie@vantageafricaleaders.comBecome the person who answers the question before anybody has finished asking it.