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
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
Udemy | English | 2h 30m | 1.48 GB
Created by: Colin Marks