Skip to content
UdemyExcelPaid courseAll LevelsCertificate

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

icon
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

icon
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!

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.7

783 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 783 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100