Course curriculum

  • 1

    Getting Started with Excel

    • Welcome to Maximity's online training

    • Introducing your trainer

    • Excel Level 1 Course Workbook

    • The ribbon bar and quick access toolbar

    • What is a spreadsheet?

    • Creating a spreadsheet

    • Entering text and numbers

    • Exercise - Entering text and numbers

    • Dates in Excel

    • Exercise - Entering Dates

    • Changing cell attributes

    • Exercise - Changing Cell Attributes

    • Short cuts and tips - Moving around, deleting cells

    • Further short cuts - Number, date, month and day series
  • 2

    Creating and using formulae

    • Entering formulae

    • Options for Copy and Paste

    • Relative and absolute references

    • Exercise - Entering Formula

    • Column totals using auto sum

    • Exercise - Add totals
  • 3

    Automating formulae and data input with Tables

    • Tables

    • Exercise - Tables
  • 4

    Getting used to different layouts

    • Creating a P&L statement

    • Insert/move/copy - rows and columns - more short cuts

    • Find, replace and go to cell

    • Exercise - P&L
  • 5

    Printing and Print Options

    • Printing in Excel including headers and footers

    • Exercise - print school data
  • 6

    Creating charts

    • The easy way to create a chart

    • Changing chart elements

    • Moving a chart

    • Exercise - Create a chart

    • Document of all Short Cuts in Excel

    • Course Feedback