Amazing Analytical Reporting with Microsoft Excel

In this lecture we will go over getting the raw data that will eventually be used to generate insights. We will also be going over ways to clean-up the data whilst taking into account the reporting requirements.
The raw data used in this report can be found below and downloaded for your own use

The next time the report is updated, I add some extra columns by using VLOOKUP. This will be done very quickly therefore I have added some exercises to do before we move on with generating our insights.
An Excel version of the exercises can be found below.

These are the solutions to the previous exercises.

In this lecture, we create insightful pivot-tables and graphs that feed off from the raw data we cleansed in part 1.

In the next part, I will be very quickly creating a table and locking cells in a way to make the build a bit quicker.
Before this tutorial, it is recommended to do these exercises before continuing to the next part.
An Excel version of the exercises can be found below.

This video will show the results of the cell locking exercises I set in the previous video.

In this lecture, I will show you how to convert a simple summary tab into an insightful dashboard

This lecture goes over one very important aspect about generating insights which is critical thinking.  The ability to be able to honestly criticize the good and bad elements of your own work is key to understanding the insights that can be developed and the limitations this may include.

In this final lecture, I will explain to you the importance of presenting your insights clearly and in a way to keep everyone engaged when you present.