Microsoft Excel for Mac - Online Training Course - CPDUK Certified

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
• Set a page layout and print a workbook.

Download Full Course Description (PDF)

Microsoft Excel for Mac - Online Training Course - CPDUK Certified.