Course Introduction and Pre-Course Reading
  • Introduction to your course and the instructor
  • Download these files before you start
  • Using the mouse and keyboard
  • Understanding the Ribbon
Introduction to Excel 2016
  • What is Excel 2016?
  • How to get Excel 2016
  • Office 2016 vs Office 365 vs Office Online and how to get a 1 month free trial
Start Excel and Create a New, Blank Workbook
  • Start Excel
  • The start screen, recent workbooks and opening a new workbook
  • Start Excel and Create a Blank Workbook
  • Take a Look Around a New, Blank Workbook
  • Look around a new workbook and the Ribbon
  • Exercise - Start Excel and Create a New, Blank Workbook
Adding Text and Numbers to a Worksheet
  • Typing Text and Numbers
  • Add text and numbers
  • Column Width
  • Formatting Cells as Currency
  • Column width and formatting cells as currency
  • Cut and Paste
  • Auto Fill and Undo
  • Cut, Paste, Autofill and Undo
  • Exercise - Adding Text and Numbers
Formulas
  • Manually Create a SUM Formula
  • AutoSum
  • Populate a Cell with a Number from Another Cell
  • Basic Formulas
  • Exercise - Formulas
Formatting
  • Font Size, Colour and Fill Colour
  • Font Bold, Italic, Underline
  • Merge & Centre Two Cells into One
  • Cell Content Alignment
  • Hiding Rows
  • Formatting
  • Exercise - Formatting
Conditional Formatting
  • Conditional Formatting
  • Copying Conditional Formatting Between Cells
  • Basic Conditional Formatting
  • Exercise - Conditional Formatting
Images
  • Insert an Image
  • Insert an Image
  • Exercise - Insert and Resize and Image
Managing Worksheets
  • Copy and Move a Worksheet to Create a Template
  • Use a Template
  • Copying and Moving Worksheets
  • Exercise - Managing Worksheets
Printing
  • Printing
  • Optional Exercise - Printing
Spelling and Thesaurus
  • Set Default Language
  • Check Spelling
  • Spelling and Thesaurus
  • Exercise - Spelling and Thesaurus
Save and Close
  • Save and Close
  • Save and Close
  • Exercise - Save and Close
Getting Help
  • Get Help within Excel
  • Help from the Instructor
  • Preview - Super Simple Microsoft Forms