Course curriculum

  • 1

    Formula and common calculations

    • Welcome to Maximity's online training

    • Introducing Your Trainer

    • Excel Level 2 Course Workbook

    • Date calculations and the formula wizard

    • Exercise - Date Calculation

    • The IF logical statement

    • Exercise - Create condition

    • Linking and calculating across spreadsheets
  • 2

    Data analysis tools

    • Filtering

    • Sorting

    • Sub totalling

    • Exercise - add filters and subtotals

    • Introduction to pivot tables

    • Slicers

    • Exercise - Pivot table and slicers
  • 3

    Spreadsheet design

    • Data validation

    • Exercise - Data Validation

    • Conditional formatting

    • Protecting cells

    • Exercise - Protect worksheet
  • 4

    More advanced functions

    • Lookups

    • Exercise - Create Xlookup function

    • Text manipulation

    • Exercise - Text Manipulation

    • Document of all Short Cuts in Excel

    • Course Feedback

What people think of our Excel courses

5 star rating

Brilliant course

Hector Van Duesbury

Course was educational

Course was educational

Read Less