Objectives of the course:

Learn how to:

  • Sort data by a single column, multiple columns and by rows
  • Set validation rules for data entry
  • Align, Merge and Centre cell contents
  • Set Custom number formats
  • Apply and remove conditional formatting

Objectives of the course:

Learn how to:

  • Round numbers
  • Count cell contents and Rank data
  • Add date / time functions to a spreadsheet
  • Tidy up appearance of cell contents
  • Join and split information within cells

Objectives of the course:

  • Create different types of chart in Excel
  • Edit chart data
  • Add data labels
  • Format charts
  • Add trendlines to charts
  • Create mixed column-line charts
  • Show a secondary axis on a chart