Microsoft Excel for Mac 1: Beginner-Specialist Certificate (Udemy.com)
Get certified! Levels 1-5 for Microsoft Excel for Mac. Covers Excel exam 77-727
Created by: Phillip Burton
Last updated February 2025
What you will 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.
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.7 out of 5higher than 81% of them
- Reviews783#195 of 356 by number of reviews
- Length12.1 hourslonger than 77% of them
- Last updatedFebruary 2025more recently than 63% of them
Course Description
By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
Reviews:
"The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent" -- Daniel Sandberg
"This is super helpful to me. I'm learning things I didn't know existed in Excel." - Jimmy Thrower
"I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip's courses." - Rick Romero
Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?
In this 11.5 hour course, learn how to:
Create and manage worksheets and workbooks
Create and navigate in Excel worksheets and workbooks,
Format worksheets and workbooks,
Customize options and views, and
Configure Excel worksheets and workbooks for distribution.
Manage data cells and ranges
Insert data into and format cells and ranges, and
Summarise and organize data in Excel .
Create tables
Create and manage tables,
Manage table styles and options, and
Filter and sort a table.
Perform operations with Excel formulas and functions
Summarize data,
Perform conditional operations, and
Format and modify text.
Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.
Create charts and objects
Create charts,
Format graphic elements, and
Insert and format objects in Excel .
This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel
The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.
Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.
The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.
You should take this course if:
you want to learn more about Microsoft Excel, or
you want to learn the skills you need to become a certified Microsoft Office Specialist.
Regardless whether you have Excel 2011, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!
Instructor Details
- 4.7 Rating
783 Reviews
Phillip Burton
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.
My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
More courses by Phillip Burton
PL-300 certification prep: Microsoft Power BI Data Analyst (2026)
4.6 (38,841 Reviews)
Provider: Udemy
Time: 30.3h
$18.99
70-461, 761: Querying Microsoft SQL Server with T-SQL course (2026)
4.6 (18,624 Reviews)
Provider: Udemy
Time: 28.7h
$22.99
Salesforce Tableau Data Analyst/Specialist Desktop Cert Prep (2026)
4.7 (15,238 Reviews)
Provider: Udemy
Time: 15.7h
$22.99
PL-900 prep: Microsoft Power Platform Fundamentals (2026)
4.7 (15,071 Reviews)
Provider: Udemy
Time: 11h
$99.99
SQL Server Integration Services (SSIS) - An Introduction (2026)
4.6 (11,116 Reviews)
Provider: Udemy
Time: 3.9h
$13.99
Microsoft Excel - Improve your skills quickly (2024)
4.6 (9,076 Reviews)
Provider: Udemy
Time: 1.6h
Free
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Anonymized User on 12/25/2024
it was really good but on the core topics where we learn about formulas.. if instructor kinda elaborated even more it would be really great.. on the other side, he was teaching topics that was out of syllabus meaning practical things that we would ONLY learn at job/work which was excellent.. Thank you Mr. Philip Burton.
By *harriet * on 6/26/2024
Outstanding course~ What I like best is that the instructor explains everything completely, so that you really understand it. Plus, as a course on Excel specifically for Macs, it is indispensable to me. I plan on taking all the courses in the series.
By Mayya Sharapova on 2/16/2024
Some videos were cut out, so it was impossible to see what clicked. Questions were answered quickly. The information was presented very well, with clear explanations. I would love to see more examples of how different things are used in different situations and why they can be helpful. Thank you very much. Great course.
By Gyalbo Bhutia on 10/12/2020
I took this specially for my excel is Mac version, and my only suggestion is when giving online demonstration on conditional and stat functions let it be shown on numerical problems along the present one for better grasp.
By Margaret Brehm on 5/25/2020
This course really deepened my understanding of Excel. The instructions were clear and the practice activities were all so helpful! I would definitely recommend this course- I feel like I really have a complete understanding of Microsoft Excel now.
By Precious Moses on 5/12/2020
Wonderful course! Would HIGHLY recommend this course for anyone using Microsoft Excel on a Mac. Don't worry about the year, I was working in the 2020 version with this course and found no problems. Lots of practice exercises to test the skills you learned. I have tried other courses for Excel on the Mac but this one has been the most thorough with its content. I cannot give this course enough praise! The instructor does an amazing job going over all skills you need to take the MO-200 exam.
By Sanjay Tamang on 3/2/2020
Quite comprehensive and the tutor, who's clear and concise, is easy to follow. Another good thing is the course is divided into bite-size sections which makes this relatively long course much more manageable. The practice part at the end of every section is helpful to review what you've learnt and occasionally, to check if I've missed anything when I've skipped some parts that I already knew.
By Galo Correa on 8/11/2019
I have been searching for a while for an Excel course for Mac users and I am very lucky that I found this course. Phillip Burton really goes all the way in a very generous way to share with the students his deep knowledge on the subject. His explanations and practical exercises are easy to follow and very simple to apply in the real world. I can see myself saving a lot of hours and becoming more effective and efficient in my work. I already purchased Phillip's two other advanced courses on Excel and I look forward to continually increase my knowledge of Excel. Thank you Phillip, and see you at the next courses!
By Jamila Thomas on 6/25/2018
Phillip is clear and concise in his teaching delivery. He makes Excel non-intimidating and easy to follow along. Additionally, he is prompt in his response to student questions. I highly recommend his class. Jamila Thomas
By Alex Forseth on 3/30/2018
Perfect course for the beginner. If you know the very very very rudimentary basics like opening files, moving between cells ect then skip it and go to another part of the course seamlessly without feeling like your lost. This course will also be a great tool in the future when I feel like I am stuck and need to go back and review. The instructor is very careful with words and covers all bases. Great response times. Definitely the guy to go to for learning excel.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 94 / 100












