Microsoft Excel 2019 / 365 Essentials Training

• 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 2019
• 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 2019

• 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