US $19.97

Excel for Mac

——   Created by Simon Sez IT

Share this course:

NEW
Course
57
Lessons
5h 13m
Lesson time
beginner
Skill level

More about this course

Ever tried learning Excel on a Mac with a course designed for a PC?

 

It looks completely different.

 

Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to confident Excel Mac user.

 

If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course was recorded using Excel for Mac 2019 but much of what is taught is still relevant if you’re using a different version.

 

In this course we show you how:

 

●     To create, open and save new workbooks in Excel Mac.

●     The basics of how Excel for Mac works including relative references and order of operations.

●     To set up your workbooks and print the right thing in Excel.

●     To use freeze panes and split screens.

●     To move data around in Excel for Mac.

●     Basic formulas and functions work in Excel for Mac.

●     To format your spreadsheets correctly.

●     To create some amazing looking charts and graphs.

●     To sort and filter your data in Excel

57 Lessons

Section 1: Introduction to Excel
6 mins
Introduction to Excel for Mac
free preview
8 mins
The Difference between PC and Mac Excel
free preview
4 mins
Course Overview
16 mins
Overview of the Excel window
4 mins
Mouse and Trackpad Features
4 mins
Creating a New Workbook
10 mins
Entering Text and Numbers
Section 2: Creating Workbooks
10 mins
Creating Basic Formulas
9 mins
Relative vs Absolute References
4 mins
Order of Operations
7 mins
Working with Ranges
3 mins
Practice Exercise 01
7 mins
Saving and Sharing Spreadsheets
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 34 courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 5h 13m of on-demand video
  • 3 downloadable files
  • Have a coupon?
  • Checkout