We can host this training at your preferred location. Contact us!

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

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

02 July 2024