Microsoft Excel: beginner to advanced
Spootyfi learning pathway · Beginner to advanced
Ages 16+ · English · 12 suggested study hours · 3 levels
Move from entering data to formulas, PivotTables, dashboards and repeatable analysis.
- Write reliable formulas
- Clean and summarise tables
- Build charts and dashboard views
Beginner · Lesson 1 of 3
Cells, ranges and data entry
A cell address combines a column letter and row number, such as B4. A range such as A1:C10 includes every cell in that rectangle. Keep one type of data in each column.
Practical activity
Enter Product, Units and Unit price in A1:C1. Add Pen/10/2 and Book/5/8. In D2 use =B2*C2 and copy down; totals should be 20 and 40.
Beginner · Lesson 2 of 3
First formulas
Every formula starts with an equals sign. SUM adds values, AVERAGE calculates the mean, MIN and MAX find the smallest and largest values.
Practical activity
Use =SUM(D2:D3) to obtain 60. Format C:D as currency and =AVERAGE(B2:B3) should return 7.5.
Beginner · Lesson 3 of 3
Formatting and sorting
Number formats change how values display without changing the stored value. Sort and filter tables to find patterns, but include every related column in the selection.
Practical activity
Format A1:D3 as a Table, sort Units descending, then filter for Book. Confirm the whole row moves together.
Practical activities use Microsoft Office on your own device. Features vary by version; the software is not included. Use fictional data only.
Reference desk
- Microsoft Support documentation for Excel functions, PivotTables and Power Query
Original Spootyfi lessons and exercises; reference materials are not reproduced. Not affiliated with or endorsed by the reference providers. Course text is English; translations and expert editorial review are pending. Illustrations are conceptual.