Follow along with this Excel tutorial and download the practice exercise files here ► https://www.simonsezit.com/excel-mac-2019-course-exercise-files/
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!
This free tutorial includes five exercise challenges where you can put what you have learned into practice. Go here to download the exercise files: https://www.simonsezit.com/excel-mac-2019-course-exercise-files/
This free Excel tutorial includes over two hours of training and is taken from the full-length Simon Sez IT course, available here: https://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-for-mac-2019-training/
To skip ahead to certain areas of the course, use the links below.
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
For more videos teaching Microsoft Excel, take a look here:
Top Ten Excel Functions: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3isgpmQEWFwWqFZ95Ih-AhA
Excel 2019 PC: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2AbeLeQt3UqLvTSoO4SAL
Advanced Functions in MS Excel: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
Below are links to some of our most popular YouTube tutorials!
– Introduction to QuickBooks 2020: https://youtu.be/6aEN-SSSMz8
– Introduction to QuickBooks 2019: https://youtu.be/ay7F1Ij11Qo
– 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
– How to Add video to Microsoft powerPoint: https://youtu.be/yvWv1bk6mu8
– Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0
– Microsoft Project 2016 Tutorial for Beginners: https://youtu.be/lWmP0kReXkQ
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
If you enjoyed the video, please give a “thumbs up”, leave some comments and subscribe to the channel 😉
