SchoolRegistry NG
Short course · Step 3 of 4

Excel 3: Reports and dashboards

PivotTables, PivotCharts, slicers, a one-page dashboard.

Advanced6 hours15 lessonsStart any time

₦15,000 paid once, 12 months of access

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. 1.1One question, four answers at onceFree, try it: One question, four answers at once
  2. 1.2Rows, columns and filters
  3. 1.3Sum, average and count

Module 2: Shape the answer

Months and quarters, the top 10, and colour on the numbers that matter.

  1. 2.1Months and quarters from daily dates
  2. 2.2Biggest first, and the top 10
  3. 2.3Make the numbers stand out

Module 3: Ready to share

A tidy printed report, refresh for new orders, and PivotCharts.

  1. 3.1A pivot that prints well
  2. 3.2Keep it up to date
  3. 3.3PivotCharts

Module 4: Let readers filter

Slicers that control every pivot, and headline numbers that follow them.

  1. 4.1Slicers
  2. 4.2One slicer, many pivots
  3. 4.3Headline numbers that follow the slicers

Module 5: The dashboard

One protected page, then your final project.

  1. 5.1Build the dashboard page
  2. 5.2Protect it, keep the slicers working
  3. 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.

  1. Excel 1: Excel for WorkBeginner, 4 hours
  2. Excel 2: Bigger lists and lookupsIntermediate, 5 hours
  3. Excel 3: Reports and dashboardsAdvanced, 6 hours
  4. Excel 4: Automate the boring partsExpert, 6 hours

Buy it in a bundle and save

Excel bundle

Get all 4 Excel courses: ₦45,000, or ₦55,000 bought one by one. It includes Excel 3.

Half of what you pay counts toward a career track if you start one within 90 days. On this bundle that is ₦22,500.

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?

₦15,000, paid once. That opens every lesson for 12 months.

Is there a cheaper way to buy more than one course?

Yes. The Excel bundle gives you 4 courses for ₦45,000, instead of ₦55,000 bought one by one.

Need help choosing?

Message us on WhatsApp or book a free call, and a person will help you choose and get started.