Excel Mac – Free Introductory Course

Follow along with this Excel Mac tutorial and download the practice exercise files here.

Microsoft Excel for Mac is getting better. Microsoft has finally added more of the functionality available to PC users. If you’re using Excel for basic to intermediate spreadsheet work, then they pretty much offer a similar experience in terms of functionality.

HOWEVER,

While you can perform similar tasks, they do not appear in the same place for Mac and PC users. That means a headache if you’re moving from PC to Mac or vice-versa. 

But don’t worry, we have you covered. In this FREE Microsoft Excel Mac tutorial, we’ll show you how to get started using Excel on a Mac. It’s perfect if you are brand new to Excel and are using a Mac OR if you’re switching from a PC. 

But that’s not all…

This free tutorial includes five exercise challenges where you can put what you have learned into practice.

You need to go here to download the exercise files to join in! https://www.simonsezit.com/excel-mac-2019-course-exercise-files/.

If you’ve used Excel before and want to skip to the most relevant part of this FREE 2-hour Excel Mac training course, use the timestamps below.

• 0:00:09 – Introduction to Excel for Mac 
• 0:05:35 – The Difference between PC and Mac Excel 
• 0:12:46 – Course Overview 
• 0:16:30 – Overview of the Excel window 
• 0:32:08 – Mouse and Trackpad Features 
• 0:35:42 – Creating a New Workbook 
• 0:39:00 – Entering Text and Numbers 
• 0:48:16 – Creating Basic Formulas 
• 0:58:08 – Relative vs Absolute References 
• 1:06:14 – Order of Operations 
• 1:09:58 – Working with Ranges 
• 1:16:50 – Practice Exercise 
• 01 1:18:51 – Saving and Sharing Spreadsheets 
• 1:25:34 – Practice Exercise 02 
• 1:26:28 – Freeze Panes Option 
• 1:30:14 – Split Screen Option 
• 1:32:50 – Arranging Windows Option 
• 1:35:06 – Practice Exercise 03 
• 1:36:04 – Headers and Footers 
• 1:42:25 – Print Titles 
• 1:45:36 – Comments 
• 1:51:42 – Page Setup Options 
• 1:56:51 – Printing Workbooks 
• 2:00:21 – Practice Exercise 
• 04 2:01:47 – Adding and Deleting Rows, Columns, and Cells 
• 2:05:30 – Changing Column and Row Widths 
• 2:09:19 – Practice Exercise 05

This free Excel tutorial is from the full-length, Excel for Mac course from Simon Sez IT. 

You can access the full Excel for Mac course and over 100 others by becoming a Simon Sez IT Member.

Deborah Ashby

Deborah Ashby is a TAP Accredited IT Trainer, specializing in the design, delivery, and facilitation of Microsoft courses both online and in the classroom. She has over 11 years of IT Training Experience and 24 years in the IT Industry. To date, she's trained over 10,000 people in the UK and overseas at companies such as HMRC, the Metropolitan Police, Parliament, SKY, Microsoft, Kew Gardens, Norton Rose Fulbright LLP. She's a qualified MOS Master for 2010, 2013, and 2016 editions of Microsoft Office and is COLF and TAP Accredited and a member of The British Learning Institute.