Broaden Your Excel Skill Set. Speed Up Your Reports.
Build your confidence to write robust & dynamic formulas that reduce your turn-around time while creating better, reliable and dynamic management reports in Excel
On this page you’ll find the course outlines and booking info for:
INTERMEDIATE EXCEL | ADVANCED EXCEL | EXECUTIVE EXCEL DASHBOARDS
Let’s face it friends!
- Tired of spending unduly lots of time creating and updating reports in Excel–and deep down in you, you’re saying there must be a better way?
- How about those end-month late nights in the office?
Recently as I was doing expectation gathering for one of my clients, one participant told me: William, I want my weekend back!
And yes…
That is probably true for you. Are reports stealing the only time you have for your family or just to have time for self?
That is where our courses come in –we’ll do anything to equip you with skills that cut by more than 50% the time you spend creating reports and reduce Excel frustrations
Here is What You’ll Get
Get ready to say “Wow, I didn’t know I could do THAT!”
Redeem Your Time
Unlock formulas & features that simplify how you use Excel. Apply immediately to your own work!
After Course Support
Stuck on a task? refer to our comprehensive manual or drop us a line or email (T&Cs)
Career Advantage
Gain top Excel skills to set your apart from the pack. Nail your next interview effortlessly
Better, Reliable Reports
Impress your boss with reports that they actually want to look at for decision making
What did our past clients think?
“Your dashboard training has already saved me a lot of time! I have used some tips which to present my funding analysis by location and staff type. Every month I just paste the new data and my source table self-adjusts. Magic! I then click the refresh button and my management dashboard is ready, just like that!”
Content
For over 8 years, our instructors have trained thousands of working professionals (PwC, AMREF, Chai Trading, Unilever, NIC Bank, Toyota Kenya, BioLite, Kenyacof, Orb Energy, etc.)
We constantly ask them to describe the challenges and frustrations they face every day on the job. (You know, the things that make you want to pull your hair out because the boss is waiting for a report and it’s getting late in the night?)
We listened, helped them on actual work scenarios, and enriched our thoroughly researched content with similar examples (after anonymizing). You can be sure therefore that each of the coursers below is crafted to solve the exact (or similar) problems which you face at the office
Business managers need timely access to accurate data – presented in a clear and understandable way.
DCA’s Excel Dashboards course equips you with the skills needed to build informative, professional, visual-rich dashboards that will allow managers to step back from the details and see the key trends and relationships that drive their companies …with responsive features to switch views
Pre-Requisites
We believe in effective training and tangible results, hence, if you are a beginner, or even a regular user of Excel but are not familiar with VLOOKUP, basic charts and Pivot tables, this course is not for you. Completion of our Intermediate Excel course or its equivalent is important.
We like being honest -dashboard courses labelled for “all levels” end up being (as you already know) a frustration as you will end up just covering the basics!
Course Outline
In this module, you will find out the available advanced data analysis tools in Excel that will develop your skills to make yourself more marketable in the field of data analysis. You’ll also learn how to combine different features and nest various formulas for dynamic Excel reports
Pre-Requisite
The concepts taught here are advanced to the average Excel user.
You’re advised to get your act together with our Intermediate level concepts before enrolling in the Advanced module. This ensures you get the best value for the program you pay for.
Curriculum
This module is formula intensive and usually fits those who have never or barely interacted with VLOOKUP and Pivot Tables. You’ll also learn beyond basic concepts such as manipulating text and dates, customizing charts, working with inbuilt conditional formatting features among other concepts.
Pre-Requisite
A good foundation in Excel is essential for this course. Participants should not just be regular users of Excel but must be able to write basic formulas taught in the foundational level module.
Curriculum
Booking Info
Don’t miss out on these upcoming VIRTUAL instructor-led sessions
Enrollment for any of the programs below STRICTLY closes 3 days to the course date
REQUIRED:
Access to a computer installed with MS Office 2013 or (preferably) a higher version
Are you ready to take back your time? Invest today!
Key Trainer
HI, I’M WILLIAM.
I am a man on a mission –to help individuals and companies to use Excel better, improve their reporting processes and cut down on time spent generating reports.
When I started out back in 2012, I didn’t know much about Excel. Like most of you, I didn’t even know it was a major reporting tool in the workplace (never taught in college).
For some reason, my former boss, believed in me that I could deliver as an Excel Trainer. I took the challenge and I believe I didn’t disappoint (check recommendation)
Since then, I’ve trained hundreds of staff (PwC, World Vision, Unilever Tea, Gulf Energy, Toyota Kenya, NIC Bank, etc.) and developed numerous programs covering Excel, Power Query, Power BI and Power Pivot.
I hold a degree in Applied Statistics with Computing (BSc.) from Moi University, and a certificate on Analyzing and Visualizing Data with Power BI from Microsoft. Am a CPA Part 1. I’m also the author of this Excel Dashboards book