Spreadsheets from Zero to Confident

What you will learn

1. 1
   BeginnerCells, references and your first formulas

   Enter data correctly and write formulas that calculate for you.

2. 2
   BeginnerEssential functions: SUM, AVERAGE, MIN, MAX and COUNT

   Use built-in functions to total, average and count your data quickly.

3. 3
   BeginnerMaking decisions with IF, COUNTIF and SUMIF

   Let the sheet label, count and total data based on conditions.

4. 4
   IntermediateSorting, filtering and highlighting data

   Reorder, narrow down and colour your data to find what matters.

5. 5
   IntermediateTurning numbers into charts

   Choose the right chart type and make it clear and honest.

6. 6
   IntermediateLooking up values with VLOOKUP and XLOOKUP

   Pull matching information from one table into another automatically.

7. 7
   AdvancedProject: a shop stock and sales sheet

   Combine everything you have learned into a working record book for a small shop.

8. 8
   AdvancedSummarising large data with pivot tables

   Use pivot tables to total, count and compare data in seconds without formulas.