Zero to Pro with Excel Pivot Tables
This course goes into the depths of this must-know drag and drop analysis tool in Excel. Ultimately, you'll also be able to create an interactive Pivot-driven dashboard -no formulas.
What is it about?
This course equips you with skills to create dynamic Excel reports that can support top management's decision making process.
We'll not use formulas in this mini-dashboard course, rather we shall utilize the feature-rich pivots to create clean dashboards that displays content professionally for a board meeting presentation.
Client speak
Reviews and testimonials
Value for time
Peterson Mwangi Mucheke Mwangi
This was excellent course to help save on time and resources and create great and presentable reports. keep it up
This was excellent course to help save on time and resources and create great and presentable reports. keep it up
Read LessCourse plan and delivery
Vincent Anyanje
This course is useful for all people who use data on a daily basis. The examples used relate to virtually everyone and the explanations are well expressed. I...
Read MoreThis course is useful for all people who use data on a daily basis. The examples used relate to virtually everyone and the explanations are well expressed. I highly recommend anyone who wishes to leverage on Excel for data analysis to undertake this course.
Read LessVery well taught
Charles Onsongo
This has been a very well taught course. I have learnt new things. William explains difficult concepts effortlessly. I need to rope in someone.
This has been a very well taught course. I have learnt new things. William explains difficult concepts effortlessly. I need to rope in someone.
Read LessCourse curriculum
-
1
Welcome Note & Files
-
Welcome -read this first!
-
Downloadable Files
-
-
2
PivotTables Fundamentals
-
Pivot Tables 101
-
Pivot Tables Core Concepts
-
-
3
Advanced Pivot Table Concepts
-
Show Values As Percent, Running Totals, Growth Rates
-
Pivot Table Slicers
-
Pivot Tables Show Top/Bottom 'x' Items
-
Pivot Tables Grouping a Date Field
-
Pivot Tables Grouping Non-Date Fields for Ageing Analysis
-
Custom Branded Slicers
-
Test your knowledge
-
Pre-Dashboard - Quiz 1
-
-
4
Make Data Come Live with Pivot-Driven Dashboards
-
Pivot Charts and Pivot-Driven Dashboards
-
-
5
Welcome to Power World with Power Pivot & Power Query
-
11 Introduction to Power Pivot and Power Query
-
-
6
Conclusion
-
Your Feedback
-
Featured Instructor(s)
BI & Analytics Lead
William K. Wonder
For the last 8 years, I've equipped thousands of working professionals in various local and multinational organizations in Kenya among them PwC, Unilever, NIC Bank, Toyota Kenya, World Vision, Gulf Energy, Tullow Oil, etc. with Advanced Excel and Dashboard reporting in Excel and Power BI.
This has given me an insider view of the reporting challenges at the work place and all the courses I teach are geared to address such scenarios.
I want you to feel in charge of your reporting process. I want you to leave office early! Yes, I look forward for your success story!
FAQs
Clear any doubts that you may have
-
Will I have access to the Excel files used?
Yes, in fact you can download them upfront and keep them for future reference
-
How much is this course?
It's absolutely free
-
How long does it take to complete?
The course has 11 videos amounting to about 2.5 hours. If you put in the effort, I will expect you to finalize the classes in approximately 4 hours