Course curriculum

  • 1

    Before you start...

    • Welcome to Maximity's online training

    • Course Workbook and CSV File Download
  • 2

    Query Part 1

    • Importing data using Query

    • Activity 1 - Importing Data

    • Manipulating data in Query

    • Activity 2 - Manipulating Data
  • 3

    Pivot Tables

    • Formula in pivot tables

    • Activity 3 - Calculated Field

    • Working with multiple pivot tables
  • 4

    Query Part 2

    • Extracting Data using Query

    • Activity 4 - Extracting Data
  • 5

    Unique

    • Unique

    • Activity 5 - Unique
  • 6

    Naming Tables, Ranges and Cells

    • Naming Tables, Ranges and Cells

    • Activity 6 - Naming Things
  • 7

    Dynamic Dropdowns

    • Dynamic Dropdowns

    • Activity 7 - Dynamic Dropdowns
  • 8

    Returning Data

    • Xlookup

    • Activity 8 - Xlookup

    • Sumif

    • Activity 9 - Sumif

    • Sumifs

    • Activity 10 - Sumifs
  • 9

    Slicers

    • Slicers

    • Activity 11 - Slicers
  • 10

    Recording Macros

    • Recording Macros