Microsoft Excel for Mac - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
Microsoft Excel for Mac - Online Training Course - CPDUK Certified.
Welcome to The Mandatory Training Group's online Microsoft Excel for Mac training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Microsoft Excel for Mac
Teacher - Barbara Evers
Learner - Kayla Chase
This online Microsoft Excel for Mac training course will teach you how to use Microsoft Excel on Your Mac. Barbara Evers will show you how to crunch numbers, create lists, store data and edit budgets in this course.
Course content
This online Microsoft Excel for Mac training course includes the following:
Unit 1: Getting started with excel
Unit 2: Excel for max vs excel for PC
Unit 3: Data entry shortcuts
Unit 4: Using formulas and functions
Unit 5: Copying formulas and functions
Unit 6: Using relative absolute and Worksheet reference formulas
Unit 7: Modifying cells, columns, and rows
Unit 8: Search and replace and spellcheck
Unit 9: Applying text formatting
Unit 10: Number formats and cell alignment
Unit 11: Styles and themes
Unit 12: Applying conditional formatting
Unit 13: Creating a template
Unit 14: Preview a Workbook
Unit 15: Setting page layout and printing a Workbook - Part 1
Unit 16: Setting page layout and printing a Workbook - Part 2
Unit 17: Working with Worksheets
Unit 18: Using custom views.
Who is the course for?
This online Microsoft Excel for Mac training course is suitable for first-time Mac Excel users or anyone who just wants to re-learn the fundamentals.
Course aims
This Microsoft Excel for Mac e-learning course aims to:
Understand the invaluable Mac features for a business
Know the basics in the utilisation of excel on a Mac to manage one’s data.
Learning objectives
On completion of this Microsoft Excel for Mac eLearning course, the learner will be able to:
Enter Data
Use Formulas and Functions
Create and Use Relative, Absolute, and Worksheet references
Modify Cells, Columns, and Rows
Use Find and Replace
Apply Text Formatting and Number Formats
Use Styles and Themes
Apply Conditional Formatting
Create Templates
Setup Page Layout
Use Custom Views.
Learning outcomes
Once you have completed this online Microsoft Excel for Mac training course, the learner will be able to:
Use data entry shortcuts on Mac’s excel.
Copy formulas and functions to and from an excel page
Use relative absolute and worksheet reference formulas