
This course is created to teach you how to use Pivot Tables, Pivot Charts, Slicers and other Excel features to create a dynamic dashboard.
Along the journey, you will learn many types of charts that are standard in Excel and few others that require out of the box thinking approach to create.
Just a quick heads up, Udemy usually ask for your feedback after roughly the fourth video of any course, you can't imagine how important your feedback is, it will help me improve my courses, will help me rank higher on Udemy and reach more people.
Rest assured, I review and check every one of the feedbacks and ratings I receive to ensure the students satisfaction!!
Stay Productive & Happy Learning!!
One of the most used charts in Excel are the column charts, this video will show you how to add and edit them.
Bar charts are also one of the Charts that are commonly used in Excel, this video will show you how to add and edit them.
Line charts have similar way of entering the previously taught charts, but they have different features and one can say add-ons, this is where you will learn that.
This is where you will learn how to insert a pie chart and a donut chart.
Hierarchy charts are divided into two types in Excel; sunburst and treemap. Both are used for hierarchy purpose but they have different presentations.
This is where you will learn how to insert and edit the scatter charts. It is very important to understand this very well as it will be used for an advanced charts later on in the courses.
Conditional formatting is used to change a shape, font, style etc. of a cell and its content dynamically to ease the categorization of your data. However, in this lecture, you will learn how to use conditional formatting to create a heat map.
This is one of the most beautiful charts in Excel, at least this is what I think. it can easily let you visualize your data based on their location in the world
Sparklines are simply charts that are imbedded inside one cell with no figures or legend. The are mainly used for indicational purposes.
Learn to build a dynamic doughnut chart in excel, adjust the donut hole, switch rows and columns, and link text boxes to auto-update product names and percentages with sales.
Build a dynamic infograph in Excel by combining bar and scatter charts into a combo chart, adjust axes, overlap shapes, and insert icons for a ready-to-use chart.
In this course, you will learn how to use charts & pivot tables to create amazing dynamic dashboards. But to do that you must first learn the basic charts and how to insert and edit pivot tables, slicers and pivot charts which will be taught in this course as well. During that journey, you will learn additional uncommon charts that requires an out of the box thinking as they are not an excel standard charts, such as the dynamic doughnut chart, rounded edges progress donut chart, dynamic line charts, overlay image charts and much more.
This course only requires you to know the basic principles of excel as the course will guide you to do dynamic dashboards from scratch. Therefore, this course is applicable for all levels, beginners, intermediate and advanced levels in Excel.
This is your chance to enhance you sheets, it is time to stop using standard direct methods, and level up your game to use dynamic dashboards and uncommon Excel charts.
I will be using Excel 2019 but most of the features are available in the previous Excel versions.
With that being said, I can’t wait to see you inside. If you decided to join me and other thousands students all over the world, I strongly advice you to download the resources and work on them while learning. But whatever you decide, stay productive and happy learning!!