Microsoft Excel 2016 Essentials - Office for Mac Training in New Zealand

You will create and edit basic Microsoft Excel 2016 worksheets and workbooks on a Mac.

Target Audience

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 – Office for Mac worksheets.

• Use a mouse
• Type and use a keyboard
• Navigate through files and folders
• Work with windows - minimise, maximise, open and close

• Get started with Excel 2016 - Office for Mac
• 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 New Workbook
• Open, Save and Close Workbooks
• Use Microsoft Help

Module 2: Modifying a Workbook

• Cut, Copy and Paste Commands
• AutoFill Options
• Find and Replace
• Spelling
• Undo and Repeat Commands
• 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 Colours to Cells
• 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