MS Excel Exam Guide: Analyzing and Visualizing Data
Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.
4.50 (700 reviews)
20,962
students
4 hours
content
Mar 2024
last update
$84.99
regular price
What you will learn
Building queries in Excel
Combining data from multiple files
Modeling data in Excel’s Data Model
Transforming and cleaning data
Splitting data
Merging data
Pivoting data
Building relationships between data sets
Calculating implicit DAX measures
Calculating explicit DAX measures
Building Basic and Advanced DAX functions
Creating KPIs in Excel
Creating Hierarchies in Excel
Building and formatting Pivot Tables
Building and formatting Pivot Charts
Creating and using calendar tables
Understanding Question styles and formats for the Excel certification exam
Using both Excel with Power BI
Why take this course?
Microsoft Excel is one of the most important software programs ever created. Businesses large and small, in countries all around the world, run off of systems and processes built on and around Excel. With so many people using Excel as part of their day-to-day jobs, it is more important than ever for you to stand out from the crowd and certify your Excel skills so you can contribute and be entrusted with these business-critical opportunities.
Enter this course. Designed directly off the study guides and outlines for the Excel 70-779 Exam, this course provides not only the theory but also the practical and foundational skills needed to pass the certification exam and stand out from the crowd. Not only will you be well prepared for the exam, but you’ll also build out a skill set that will be in demand for years to come.
When you’re ready to professionally certify your Excel skills, this is the course for you.
Screenshots
Reviews
Aileen
June 27, 2023
i dont have course to compare this too so i will give it full marks. i still need to go through the full course again to absorb it. but im glad i reached the end point
Mauricio
August 2, 2022
Si, fue una buena elección!
Solo agregaria subtitulos al español porque puede ser complicado de entender para personas que tienen un nivel bajo del idioma Inglés
Olorunjuwon
April 24, 2022
The course was quite engaging and interactive with the accompanying resources and explanations throughout the course. It is amazing, to say the least!
Kareem
May 23, 2021
very clean and in point, and changed the way i am using excel, well this is why i am here anyway
Thank you
Michael
March 1, 2021
Instructor is very knowledgeable on the subject matter. He has a smooth quick voice and tone that is easy to follow and digest information.
Javier
March 1, 2021
Fantastic. I am excel savvy, but was not familiar with Power Queries and Power Pivot... this is similar to Access, but less cumbersome.
Alex
January 22, 2021
Excellent course.
Extremely thorough, linked to resources where necessary (including updated resources if you messed up your example sheet but didn't know how/have time to fix before the next session), and I never once felt lost as I often do with online courses.
I've already recommended this to 3 other Analysts as a refresher and opportunity to learn a few new things.
Fernando
December 28, 2020
Nice work. Good course if taken as an Elementary 70-779 preparation. Not a 5-star though. I believe the lectures about DAX could be better. Specifically, the filter and row contexts should be explained deeply so that the attendee with no previous DAX knowledge can understand and build solid knowledge. Another example: the difference betwen SUM and SUMX is not explained. The CALCULATE, ALL and FILTER functions also deserve a much more detailed description. I guess someone with no previous DAX knowledge would get very confused.
Sharubala
December 23, 2020
Amazing and excellent course! Ben is a great story-teller. He explained all topics and it's functionality through a practical example which was very easy to follow. He covered all the necessary topics needed to learn for the exam.
Muhammad
July 2, 2020
I think this course would be better if add a resume from every course. So if I or another user want to review the course, we can just see a resume.
The course is very good but maybe the server or something like that must can be better than this. I often experienced buffer when I stream the video
James
July 1, 2020
Superb course. Very helpful to me as I will use what I have learnt in my day to day work. The lecturer is also superb, very clear and concise and actually making the concept sink in very well. Highly recommended course for learning advanced Excel!
Josiah
June 30, 2020
I am experiencing how to use Data Model and Power Pivot. It's a great functionality in excel. It's fun using all of these functionalities.
Christian
June 30, 2020
The instructor is very articulate and I have clarity on some questions that have disturb me prior to going through this video
Shiyi
June 5, 2020
Instructors did a great job in explaining and presenting all the steps clearly and at a reasonable pace.
Rohan
March 25, 2020
I have been using excel since years but never realized it's power and depth of features on offer. This course does a very good job in introducing these features hence I will keep in mind in future in my work. Presentation is good and explanation is clear .
Charts
Price
Rating
Enrollment distribution
Related Topics
2751520
udemy ID
1/10/2020
course created date
2/25/2020
course indexed date
Bot
course submited by