Excel 3: Reports and dashboards
PivotTables, PivotCharts, slicers, a one-page dashboard.
GH₵ 130 paid once, 12 months of access
See how it works
Each lesson has a practice computer beside it. You copy each step, and the course tells you when it is right. This is a real lesson, sped up.
Build a pivot table in your first lesson, checked as you go.
A video course: you watch. A SchoolRegistry short course: you do the task yourself on a practice computer, and the course checks it as you go.
Who it is for
People who finished Excel 2 and report to a manager.
What you will be able to do
- Build a PivotTable that totals sales by branch
- Group dates into months and keep only the top items
- Put charts and slicers on one dashboard page
By the end you will turn a long list of orders into a one-page dashboard that answers your manager's questions and lets them click for their own answers.
How it works
Each lesson starts with a short video. Tolu, your guide, shows you what to do and says it in plain words. You practise on a real-looking Excel, with Tolu guiding each step.
You work on a practice computer inside the course, so you cannot break anything. More than 75% of your time is hands-on practice, not watching.
Every lesson is split into steps, and a row of step bars shows where you are. If a step is too hard, press Skip and come back to it later.
All 15 lessons5 modules. The free lessons are marked.
Module 1: Your first PivotTables
Totals by branch, category and product in a few clicks.
- 1.1One question, four answers at onceFree, try it: One question, four answers at once
- 1.2Rows, columns and filters
- 1.3Sum, average and count
Module 2: Shape the answer
Months and quarters, the top 10, and colour on the numbers that matter.
- 2.1Months and quarters from daily dates
- 2.2Biggest first, and the top 10
- 2.3Make the numbers stand out
Module 3: Ready to share
A tidy printed report, refresh for new orders, and PivotCharts.
- 3.1A pivot that prints well
- 3.2Keep it up to date
- 3.3PivotCharts
Module 4: Let readers filter
Slicers that control every pivot, and headline numbers that follow them.
- 4.1Slicers
- 4.2One slicer, many pivots
- 4.3Headline numbers that follow the slicers
Module 5: The dashboard
One protected page, then your final project.
- 5.1Build the dashboard page
- 5.2Protect it, keep the slicers working
- 5.3Final project: the regional sales dashboard
What you need
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
Part of the Excel series
Excel 1 to Excel 4. Start at step 1, or jump ahead if you already know the basics.
- Excel 1: Excel for WorkBeginner, 4 hours
- Excel 2: Bigger lists and lookupsIntermediate, 5 hours
- Excel 3: Reports and dashboardsAdvanced, 6 hours
- Excel 4: Automate the boring partsExpert, 6 hours
Questions people ask
Who is Excel 3 for?
People who finished Excel 2 and report to a manager. It follows Excel 2. If you already know that material, you can start here.
Can I try it before I pay?
Yes. Lesson 1, "One question, four answers at once", is free. You do not need to pay to start.
How long does it take?
There are 15 lessons and about 6 hours of learning. You go at your own pace, and you have 12 months of access.
What do I need?
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
How much does it cost?
GH₵ 130, paid once. That opens every lesson for 12 months.