Course curriculum

  • 1

    Welcome to Excel Level 1!

    • Welcome to Excel Level 1

    • How to use this course
  • 2

    Chapter 1: Getting Started in Excel

    • Opening Excel

    • Home/ Backstage

    • Open a new blank workbook

    • Overview of Excel

    • Save your Workbook

    • Change name of Sheet 1
  • 3

    Chapter 2: Inputting data

    • Inputting Data

    • Fill Handle

    • Fill Handle Activites

    • Introduction to Formulas

    • Formulas Activity

    • Creating a Spreadsheet

    • Create Your Spreadsheet Activity

    • Flash Fill

    • Flash Fill Activity
  • 4

    Chapter 3: Number formatting

    • Dates

    • Dates Activity

    • Financials

    • Salary Activity

    • Percentages

    • Percentage Activity
  • 5

    Chapter 4: Functions and Formulas

    • New Salary

    • New Salary Activity

    • Relative and Absolute References

    • Compare to 3% Activity

    • Formula vs Function

    • Insert Function Activity

    • AutoSum

    • AutoSum Activity
  • 6

    Chapter 5: Navigating Data

    • Cut, Copy and Paste

    • Moving Data

    • Find and Replace
  • 7

    Chapter 6: Visualisations

    • Tables

    • Table Activity

    • Charts

    • Charts Activity

    • Page Layout

    • Page Layout Activity
  • 8

    Chapter 7: Printing

    • Print Options

    • Headers and Footers

    • Add Headers and Footers Activity
  • 9

    Congratulations! You've Completed Excel Level 1

    • Download the Guidebook