0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

Excel Beginners (Mac Edition)

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 certainly for you. This course uses Excel for Mac 2019, but much of it is still relevant if you’re using a different version.

4.3
(214 ratings) 611 students



Enroll now


What you will learn

To create, open and save new workbooks in Excel Mac.
How Excel for Mac works.
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 fantastic looking charts and graphs.
To sort and filter your data in Excel.

Who should take this training

Prerequisites

  • You should have MS Excel (or Office) 2016 or 365 installed on your computer.

Target audience

  • This course is for you if you want to develop your Microsoft Excel skills

About this training


Learning Excel on a Mac is different from learning Excel on a PC. 

Luckily, we’ve got you covered. We’ve put together this comprehensive Beginners Excel course, and it’s all recorded using Excel for Mac 2019. In this course, we assume you have zero Excel knowledge and help you grow your confidence with spreadsheets.

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 certainly for you. This course uses Excel for Mac 2019, but much of it is still relevant if you’re using a different version.

Course Format

This is a video-led Microsoft Excel training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Mac users.

This course is also suitable for Office 365 users.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction to Excel
1. Introduction to Excel for Mac 05:24 mins
2. The Difference between PC and Mac Excel 07:12 mins
3. Course Overview 03:43 mins
4. Overview of the Excel window 15:38 mins
5. Mouse and Trackpad Features 03:35 mins
6. Creating a New Workbook 03:18 mins
2. Creating Workbooks
1. Entering Text and Numbers 09:15 mins
2. Creating Basic Formulas 09:53 mins
3. Relative vs Absolute References 08:07 mins
4. Order of Operations 03:42 mins
5. Working with Ranges 06:52 mins
Practice Exercise 01 02:03 mins
Practice Exercise 1
3. Saving Workbooks
1. Saving and Sharing Spreadsheets 06:42 mins
Practice Exercise 02 00:54 mins
Practice Exercise 02
4. Navigating Large Workbooks
1. Freeze Panes Option 03:47 mins
2. Split Screen Option 02:35 mins
3. Arranging Windows Option 02:17 mins
Practice Exercise 03 00:58 mins
Exercise 03
5. Page Setup and Print Options
1. Headers and Footers 06:20 mins
2. Print Titles 03:12 mins
3. Comments 06:06 mins
4. Page Setup Options 05:09 mins
5. Printing Workbooks 03:33 mins
Practice Exercise 04 01:24 mins
Practice Exercise 04
6. Working with Rows, Columns and Cells
1. Adding and Deleting Rows, Columns and Cells 03:43 mins
2. Changing Column and Row Widths 03:50 mins
Practice Exercise 05 01:07 mins
Practice Exercise 05
7. Moving Data
1. Cut, Copy and Paste 07:38 mins
2. Copying Formulas 06:02 mins
Practice Exercise 06 01:14 mins
Practice Exercise 06
8. Formulas and Functions
1. Overview of Formulas 08:41 mins
2. Creating Formulas using Functions - Part 1 13:26 mins
3. Creating Formulas using Functions - Part 2 14:17 mins
Practice Exercise 07 02:09 mins
Text and Date Functions
Lookup Functions
Linking Formulas - Sample
Copying Formulas - Sample
9. Working with Sheets
1. Sheet Tab Options 06:09 mins
2. Three Dimensional Formulas 06:25 mins
Practice Exercise 08 02:10 mins
Practice Exercise 8
10. Formatting Worksheets
1. Formatting Cells - Part 1 08:13 mins
2. Formatting Cells - Part 2 07:35 mins
3. Number Formatting 07:13 mins
4. Format as Table 09:46 mins
5. Using Styles 08:16 mins
6. Conditional Formatting 10:20 mins
7. Using Format Painter 03:07 mins
8. Protecting Sheets 06:06 mins
9. Fill Handle and Custom Lists 04:43 mins
Practice Exercise 09 02:09 mins
Conditional Formatting - Sample
Practice Exercise 09
11. Charts
1. Creating Charts 05:48 mins
2. Editing Charts - Part 1 00:00 mins
3. Editing Charts - Part 2 08:13 mins
Practice Exercise 10 01:25 mins
Creating Charts
12. Sorting and Filtering
1. Remove Duplicates 06:42 mins
2. Sort Data 04:35 mins
3. Filter Data 06:30 mins
4. Advanced Filter 03:36 mins
Practice Exercise 11 01:09 mins
Filtering Data - Sample 1
Sorting Data - Sample 1
Practice Exercise 11
13. Conclusion
Course Close 01:25 mins

Request more information

Similar courses

Join our mail list for news