Do you want to improve your charting and visualization skills in Excel? Do you want to master the common and lesser well-known charts available in your spreadsheets? Would you like to be able to create non-standard visually effective Excel charts and interactive dashboards that will all KPI's to be tracked, help aid business decisions, and reveal insights from your data? If so then this course is the course for you. Excel is not only an awesome tool for storing data and carrying out calculations, but it is also an amazing visualization tool from which you can design and create interactive dynamic dashboards and we are here to show you how it all works.
We will start this course by looking at the basics of charting in Excel. You will explore ways to insert charts and formatting options. After this, we will take a deep dive into creating the most commonly used charts such as line charts, pies charts, and columns charts. And we will then finish the basics by looking at less common charts.
Once we have mastered the basics, you will then learn how to create dynamic non-standard visually effective charts and visualization. You will learn advanced use functions and formulas to drive interaction and by the end of this course, you will be comfortable taking on a dashboard project from scratch.
This is a hands-on course, with workbooks to download and a lot to practice and master, giving you Excel dashboard skills that are in high demand in this growing world of data.