This course covers the following topics:

  • Getting started with Microsoft 2016
  • Setting basic options in Excel
  • Creating, opening and saving workbooks
  • Entering values and editing cells
  • Accessing Help in Office 2016
  • Applying number formatting and formatting cell contents

This course covers the following topics:

  • Cell alignment
  • Inserting cells, rows and columns
  • Tips for navigating large worksheets
  • Adding, renaming and copying worksheets
  • Adjusting the page layout and setting print options
  • Proofing and sharing your workbooks

This course covers the following topics:

  • Using basic functions such as SUM, AVERAGE, MAX, MIN and COUNT
  • Using Auto Fill and Fill to fill blocks of cells with values
  • Understanding absolute and relative cell references
  • Copying formulae and how it affects cell references
  • Using simple¬†functions in Excel

This course covers the following topics:

  • Using Find and Replace
  • Sorting and filtering data
  • Adding headers and footers to a spreadsheet
  • Adding comments
  • Using conditional formatting and creating custom number formats