70-779: Analyzing and Visualizing Data with Microsoft Excel (Udemy.com)

Learn all about Pivot Tables (inc. Pivot Charts), Get and Transform and Power Pivot, to perform advanced data analysis.

4.7
( 26 Reviews )

Created by: Phillip Burton

Produced in 2021

icon
What you will learn

  • Be able to create PivotTables and PivotCharts, both basic and advanced
  • You will be able to format numbers and dates, and create advanced calculations.
  • You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.
  • Building and refine models, including adding calculated columns and measures.
  • You will learn the important M and DAX functions, to enable you to build your own formulas.

icon
Quality Score

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

Overall Score : 94 / 100

icon
Course Description

This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam.----------------Do you already use Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification.
Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt.
This course comes in three parts:
Part 1 - Creating Pivot Tables and Pivot ChartsThis part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.
It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.
After only thesefirst few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.
After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.
By the end, you will be an Expertuser of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly,and you'll beable to help others with their data analysis.
Part 2 - Get and Transform Data (also known as Prepare the Data)We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the Mlanguage.
Part 3 - Refining the model (also known as Model the Data)We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.
The course will take around 16 hours to complete,but completing this will enable you to create vizzes, dashboards and storiesof your own, and know how to overcome common problems.
The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.
The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.
Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft.
Who this course is for:
This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot.
No prior experience in reporting tools is required.
This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages.
Read More product length iconTime: 16.5h

icon
Instructor Details

Phillip Burton

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

Read More

icon
More courses by Phillip Burton

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

$11.99

SQL Server Integration Services (SSIS) - An Introduction

$11.99

70-462: SQL Server Database Administration (DBA)

$11.99

Microsoft SQL Server Reporting Services (SSRS)

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

$11.99

All courses by Phillip Burton

icon
More excel courses

Excel Skills for Business: Essentials

Free

Excel Skills for Business: Intermediate I

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

$11.99

Excel with Top Microsoft Excel Hacks

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

$11.99

All excel courses

icon
Reviews

4.7

26 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete
Reset Filter
Write a Review arrow

By Marios Floros on 11/21/2020

It is extremely useful! Very good!

By Sara Alkayyal on 11/13/2020

wooow Philip doing great job to explain this course, and he make this course so exiting not boring to watch, so I will take another course with Philip on different subject

By Marcello Luigi on 11/10/2020

good examples

By Akhilesh Singh on 11/9/2020

Excellent start !

By HO SZE LEUNG on 11/2/2020

Very clear explanation!

By Amy Colby on 10/17/2020

I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job.

By Gregory Helfrich on 10/7/2020

like the delivery - although an advanced class - good refresher

By Sudhir Kumar Thakur on 9/18/2020

Amazing explanation. Very focused and good coverage for certification.

By Bobby Collins on 8/13/2020

Great course. Great pace with makes it easy to learn. I'm really enjoying it. Thanks for the work you put into this.

By David Jarju on 8/12/2020

Yes it was a good match

By Curtis Wang on 8/4/2020

it's good warn up studying pivot table before go into power BI.

By Adam Holding on 8/3/2020

Good content, pleasant voice, clear audio and some interaction

Load More

70-779: Analyzing and Visualizing Data with Microsoft Excel
Visit Course Write a Review
  • Video Duration: icon 16.5h
  • Price: 11.99 Track Price 11.99 Track Price
  • Provider: icon Udemy
  • Year: icon 2021
  • Language: icon English
  • Certificate: icon Yes
30-Day Money-Back Guarantee

Udemy Coupon Price Tracker

For any issues or feature requests please email CourseDuck's Co-Founder at michaelk@courseduck.com