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

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

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

27 November 2024