Microsoft Excel for Mac Office 365 on Mac OS

The complete guide to Microsoft excel for Apple Mac OS X – Office 365
Microsoft Excel for Mac Office 365 on Mac OS
File Size :
1.48 GB
Total length :
2h 30m


Colin Marks


Last update




Microsoft Excel for Mac Office 365 on Mac OS

What you’ll learn

Use Microsoft Excel 2016 for Mac with confidence in an Office environment.
learn how to use the most common Excel formulas and functions to carry out day to day spreadsheet tasks.
Produce excel spreadsheets to the highest standard
Use formulas and functions to carry out tasks
Give them the tools to be able to tackle more complex formulas

Microsoft Excel for Mac Office 365 on Mac OS


No Prior spreadsheet experience is needed to take the class.
Students should have Microsoft Excel installed on their computer so that they can follow along with the lectures.


Microsoft Excel is one of the most popular computer applications in offices over the last 20 years. For years people have struggled with compatibility issues between Microsoft and Apple Mac OS. This is slowly changing, Microsoft Office 365 has brought the two operating systems closer, its now easier than ever to collaborate with other users, its easier than ever to create a file on a Window PC and edit it on your favourite MacBook.
Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about it  than you actually do. This course is designed from the bottom up, focusing on the most important elements of Microsoft Excel to give you the skills and confidence to perform everyday spreadsheet tasks in the average office.
Have you used Excel before and now have moved over to Apple Mac OS, we will look at the main differences in the two versions and also show some useful tips so that you can become a competent Microsoft Excel user


Section 1: Introduction

Lecture 1 Introduction

Section 2: Using the Application

Lecture 2 The Microsoft Excel 2016 for Mac Application

Lecture 3 Creating Spreadsheets

Lecture 4 Saving a Spreadsheet

Section 3: Working with cells

Lecture 5 Cells

Lecture 6 Finding and Replacing Data

Lecture 7 Sorting Data in a Spreadsheet

Lecture 8 Filtering Data

Lecture 9 Cut, Copy and Paste Content and Deleting Cell Content.

Section 4: Managing Worksheets

Lecture 10 Rows and Columns

Lecture 11 Worksheets

Section 5: Formulas and Functions

Lecture 12 Creating formulas

Lecture 13 Using the Autofill button

Lecture 14 Absolute Cell Reference

Lecture 15 Functions

Lecture 16 The IF Statement

Section 6: Formatting

Lecture 17 Cell Formatting

Lecture 18 Formatting Cell Contents (Fonts)

Section 7: Charts

Lecture 19 Creating a chart

Lecture 20 Editing Charts

Section 8: Outputs

Lecture 21 The Page Set Up Options

Lecture 22 Printing

Section 9: Practice 1

Lecture 23 Practice Part one

Lecture 24 Practice Part two

Lecture 25 Bonus Lecture

Section 10: Conditional Formatting

Lecture 26 Conditional formatting – The Basics

Lecture 27 Condition Formatting – creating rules

Lecture 28 Conditional Formatting- Clearing formatting

Lecture 29 Conditional Formatting – Dates

Lecture 30 Conditional Formatting- Data Bars

This course is designed for anybody who has no spreadsheet experience but wishes to become a competent Microsoft Excel user.,This course can be used as a refresher course for users who have used Microsoft Excel on a Windows PC but are now using an Apple Mac

Course Information:

Udemy | English | 2h 30m | 1.48 GB
Created by: Colin Marks

You Can See More Courses in the Office Productivity >> Greetings from

New Courses

Scroll to Top