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