Getting Started with Excel 2016 for Mac
By Mike Thomas
This course provides a solid introduction to Excel 2016 for Mac and is aimed at those who are either completely new to Excel or have used it at a very basic level.
Course info
Level
Beginner
Updated
Oct 7, 2015
Duration
2h 25m
Table of contents
Introduction to Excel 2016 for Mac
Introduction to the Course
3m
The Workbook Gallery
3m
Screen Interface Elements
4m
Saving, Closing, and Opening a Workbook
2m
Summary
1m
Entering and Editing Data
Introduction
1m
Working with Cell Entries
4m
Cell Entries that Begin with a Zero
3m
Working with Cell Comments
1m
Cut, Copy, Paste
4m
AutoFill
5m
Creating a Custom List
2m
Summary
1m
Formatting Your Data
Introduction
1m
Resizing, Inserting, and Deleting Columns and Rows
7m
Applying Formatting to a Cell
9m
The Format Painter
4m
Conditional Formatting
8m
Hiding Columns and Rows and Protecting Cells
5m
Summary
1m
Creating Formulas and Using Functions
Introduction
1m
Creating Basic Calculations
6m
Using Brackets in a Formula
4m
Copying a Formula
2m
Using Absolute Cell References in a Formula
8m
Using a Named Cell in a Formula
5m
Introduction to Functions
8m
Summary
1m
Working with Lists
Introduction
1m
Sorting a List of Data into Order
4m
Sorting a Multi-column List into Order
3m
Sorting a Row of Items into Order
1m
Fixing Issues that Prevent Correct Sorting
5m
Filtering a List
5m
Prevent List Headings from Disappearing as You Scroll
2m
Summary
1m
Printing Your Data
Introduction
1m
Defining What Is to be Printed
3m
Setting Orientation Scaling and Margins
5m
Setting Headers, Footers, and Other Print Settings
7m
Summary
1m
Course Summary
Description
Course info
Level
Beginner
Updated
Oct 7, 2015
Duration
2h 25m
Description
Learn how to use the brand new Excel 2016 for Mac! You’ll learn how to set up a spreadsheet from scratch, update an existing spreadsheet, and improve the appearance of a spreadsheet to make it easy to read and understand. You’ll also learn how to create simple calculations, work with list based data, and print your spreadsheet.
About the author
About the author
Based in Manchester, England, Mike has 27 years experience in corporate IT training, working with and for organizations across a diverse range of industries. He designs and delivers face-to-face, virtual, written and video-based training, primarily focusing on Microsoft Office, Lync, SharePoint, VBA development and database development.