Analyzing and Visualizing Data with Microsoft Excel

Back To All Courses

210 Lessons

All

Skill Level

17:04h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

Do you already use the PC version of 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.

The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of 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.

Completing this course will help you:

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.

Who is the course 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.

Learning Path

Part 1 – Creating Pivot Tables and Pivot Charts

This 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 these first 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 Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able 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 M language.

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.

What people are saying

“Thank you Phillip for such amazing courses. I have passed both 70-778 and 70-779 exams by your courses. The videos and practice activities have been really helpful for developing strong understanding of Excel and Power BI.”
Vibhu
“I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable”
Nora
“Phillip’s presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course. I have passed my 779 exam after doing this course as well as some other learning. Many thanks Phillip!”
Dilbag
“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.”
Amy
Previous
Next

Analyzing and Visualizing Data with Microsoft Excel

210

Lessons

All