• Use a mouse

• Type and use a keyboard

• Navigate through Windows files and folders

• Work with windows - minimise, maximise, open and close

• Get started with Excel 2016

• Create a basic worksheet

• Modify a workbook

• Use formulas and functions

• Format an Excel worksheet

• Manage worksheets and workbooks

• Set up printing options

Module 1: Getting Started with Excel 2016

• Excel and the Excel Environment

• Navigate and Select in Worksheets

• Create a Basic Workbook

• Open, Save and Close Workbooks

• Use Microsoft Help

Module 2: Modifying a Workbook

• Cut, Copy and Paste Commands

• Flash Fill

• AutoFill Options

• Find and Replace

• Spelling

• Undo and Redo

• Insert and Delete Options

• Column Width and Row Height

• Hide and Unhide Options

Module 3: Using Formulas and Functions

• Create Relative Formulas

• AutoCalculate

• Insert Functions

• Use AutoSum

• Copy Formulas

• Create Absolute Formulas

Module 4: Formatting an Excel Worksheet

• Font Group

• Add Borders and Fill Colours

• Cell Alignment

• Number Formatting

• Cell Styles and Galleries

Module 5: Managing Worksheets and Workbooks

• Manage Worksheets

• Freeze Rows and Columns

• View Options for Worksheets and Workbooks

Module 6: Printing Options

• Print Preview

• Print Worksheets and Workbooks

• Page Setup

• Print Titles

• Page Layout View