Microsoft Excel for Mac 1: Beginner-Specialist Certificate

Get certified! Levels 1-5 for Microsoft Excel for Mac. Covers Excel exam 77-727

Created by: Phillip Burton • 800,000+ students so far
Best Selling Instructor - over 800,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I Learn?

• Create, configure and save Excel worksheets and workbooks.
• Navigate through and format worksheets and workbooks.
• Customise options and views for worksheets and workbooks.
• Configure Excel worksheets and workbooks to print (e.g. page setup).
• Insert data into and format cells and ranges, and create and modify tables.
• Highlight, filter, sort and group cells, ranges and tables.
• Create and format Excel charts.
• Insert and format objects, including modifying images.
• Create formulas in Excel, including using conditional logic and modifying text.

Requirements

• Before beginning, you will need to know how to use a Mac computer, including a mouse.
• It would be good if you have used Microsoft Excel before, but this is not essential.
• You should have MS Excel (or Office) 2016 or 365 installed on your computer. This course will also be good for you if you have Office 2011 installed instead.

Target audience

• This course is for you if you want to develop your Microsoft Excel skills.
• This course will use the latest version of Excel, but is ideal for you if you use Excel 2011, 2016 or 365.
• This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
• This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
• You will cover the content tested in Microsoft Office Specialist Exam 77-727 (among others).
• This course may not be for you if you want to learn Microsoft Excel for PC computers. Please see my other courses for this.