SKILLSHARE ULTIMATE EXCEL COURSE 8 EXCEL CHARTS FOR SIMPLE AND EFFECTIVE DATA PRESENTATION-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:08
Category:
Genre:
This class is #8 in a series called the Ultimate Excel Course.
In this class you will learn to use charts to present data effectively.
In this class we start with an introduction to creating charts and some of the fundamentals that you need to know.
We then explore some simple changes that can make a great impact on your charts. And then save these as a chart template so that next time, the process is done and just a few clicks.
It is then time for some more advanced features such as using cell values for labels and adding interactivity to the chart. We first explore settings that are built into the charts in Excel.
Then we utilise some of our skills from previous classes in this course the make the chart dynamic. We set up a drop down list, and the user selection from the list changes the data presented by the chart.
We also look at how to automatically change the colour of key values in the chart to bring them to user attention. A Conditional Formatting for charts.
Finally we see Sparklines. This feature is great for quick insights that do not monopolise the paces of your dashboard or report.
In this class you will learn to use charts to present data effectively.
In this class we start with an introduction to creating charts and some of the fundamentals that you need to know.
We then explore some simple changes that can make a great impact on your charts. And then save these as a chart template so that next time, the process is done and just a few clicks.
It is then time for some more advanced features such as using cell values for labels and adding interactivity to the chart. We first explore settings that are built into the charts in Excel.
Then we utilise some of our skills from previous classes in this course the make the chart dynamic. We set up a drop down list, and the user selection from the list changes the data presented by the chart.
We also look at how to automatically change the colour of key values in the chart to bring them to user attention. A Conditional Formatting for charts.
Finally we see Sparklines. This feature is great for quick insights that do not monopolise the paces of your dashboard or report.