+ View more
Course overview
This course takes you from a blank sheet to a working business dashboard. Every lesson uses real office examples: sales lists, budgets, staff schedules and supplier price lists.
You learn at your own pace and can come back to any lesson whenever you need it at work.
What will i learn?
- Organise data in clean, sortable tables
- Use SUM, IF, XLOOKUP, COUNTIFS and other everyday formulas
- Summarise thousands of rows with PivotTables
- Build charts and a one-page dashboard your manager can read in a minute
Requirements
- A computer with Microsoft Excel 2016 or newer, or Microsoft 365
- No previous Excel experience needed
Curriculum for this course
15 Lessons
Getting started
3 Lessons
-
Welcome and how this course works
Preview 00:06:00
-
The Excel screen, workbooks and sheets
00:10:00
-
Entering and formatting data
00:12:00
Formulas you will use every day
5 Lessons
-
Cell references that do not break
00:12:00
-
SUM, AVERAGE, MIN and MAX
00:10:00
-
IF and nested conditions
00:14:00
-
XLOOKUP and VLOOKUP
00:15:00
-
COUNTIFS and SUMIFS
00:14:00
Working with large lists
3 Lessons
-
Tables, sorting and filters
00:12:00
-
Removing duplicates and cleaning text
00:14:00
-
PivotTables step by step
00:16:00
Reports and dashboards
4 Lessons
-
Choosing the right chart
00:12:00
-
Conditional formatting
00:10:00
-
Building your first dashboard
00:18:00
-
Final project: monthly sales report
00:25:00
+ View more
Other related courses
About instructor
Write a public review