Microsoft Excel Mac Tutorial: MS Excel Mac Training Course - 2+ Hours

✅ Download the free course exercise files to follow along

In this Microsoft Excel Mac tutorial, we'll show you how to get started using Excel on a Mac. This Excel course is for you if you're brand new to using Excel on a Mac and are fed up with videos and courses that teach Excel on a PC!

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - 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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[AsnBoss]

Thank you, something to learn during lockdown !

[furkanullah]

This course is so incredibly helpful .Learning this course for last two weeks .Thank you very much for your hard work.Requesting you to upload more videos on Microsoft products on MacOs.
Thank you from Worlds Most Beautiful Country Bangladesh

[aopham]

Hope you can use more keyboard shortcuts since there are quite different between Mac and Windows. Besides, it makes working more efficiently. by the way thanks for your tutorial videos.

[davidprice]

Great video. Finally a tutorial for Mac users. Would love to see more Excel tutorials specifically for the Mac. Thanks for sharing your knowledge.

[RebeccasFinanceTutorials]

Thank you Deborah, it's good to see this from an It perspective I have created a couple of finance excel related tutorials also x

[brittanyengel]

Thank you so much! What a great free resource :)

[ryantan]

Thank you so much !!! Really helpful for beginners like me!

[kimlarjohnson]

thank you so so much. i am designing Word, Excel and Desktop worksheets for my older adult IT students and i found differences that i wanted to point out and you covered thanks. i always test out btw laptop & MacBook Pro. i am using Excel from OneDrive to create because Excel Mac is upgrading or something ::)) thanks - the Apple Ed Forum resources do not have this as i was going to share my resources ....

[do]

Screen splitting is great option! I have been working with MS Excel for so long but I have never used it! Thanks for advice!

[jrichard]

the get my files link doesn't work beyond the confirm my subscription...

[claauudiuu]

Files no longer available? I'm trying to download them but it seems that the "get my files" button itself doesn't work anymore.

[kimkoch]

Can download exercises from the email download but I don't see the other files such as the ones like Demo 1, 2, 3, 4, Filtering Data.xlsx do I download those files?

[ravencroftgraphicsd]

i am currently using office 365 on mac and there is a functionality that still seems to be missing, 'Descriptive Statistics and Normality' and the VER() function still does not work as instructed. is there some other mac specific way or add in ( i have not found one in searching) that can do this. basic descriptive statistics works, but the expanded version is just mia? i can't find it anywhere...

[wildcraft]

I have 2 questions:
1. Where is the find all option?
2. Where do you find the chart filter option?

[angellinastepany]

why on my macbook air the symbol menu when clicked always displays the mac's default emoji? Can you help me?

[curiousbeeserendipity]

Quick question. My co worker (new job here) type several spaces to replace for three. The crazy thing (in my mind) is that she will enter 20 spaces > Replace for three. Then enter 19 and 18 and 17…in til she gets to 4. Her goal is to replace for three spaces. We are using Mac and I am confused. In the past I had used control H and replaced space or removed commas, etc. is there a better way to do what she is doing? That can’t be right

[gurudyakhalsa]

How do you get to FILE OPTIONS ADVANCED (windows version) in a MAC

[tuttyusbuttyus]

The link to receive the practice files isn't working.

[rosaliecouturier]

Hi, I don't know if you can answer me, but my interface doesn't look like yours and I wonder why. Most of the button are at the same place, some aren't. Mine looks more uhh "basic" I think would be the word. I've checked my version, it's 16.36. Is there something else that can have an impact on the interface?

[beats]

You a a star and so generous in creating and uploading this informative course. If you had to make a decision, having to decide beween the Mac and the Windows operating system, what decision would you make as an Excel specialist/connoisseur? Thank you. PS: Just one suggestion. You have a very pleasent voice, but the frequent 'Now' in front of almost all of your sentences breaks the flow a little, at least for me.