Objectives of the course:

  • Learn how to navigate around Excel and move around a spreadsheet
  • Know how to open, save and close workbooks
  • Apply basic cell formatting
  • Use different Number formats
  • Access and use the help menu

Objectives of the course:

  • Use basic functions such as SUM, AVERAGE, MAX, MIN and COUNT
  • Use Auto Fill and Fill to fill blocks of cells with values
  • Learn about absolute and relative cell references
  • Copy formulae and see how it affects cell references
  • Learn about functions and how they are used

Objectives of the course:

  • Manipulate & Edit worksheets
  • Copy & move cells around a worksheet & workbook
  • Apply basic sorting & filtering
  • Search for & replace data in a spreadsheet
  • Adjust the Page Layout and set printing options