
Please take 2 minutes to give your instructor feedback for this course so that it will be useful for other intended learners to take up this free
You can download the chart data set, I have used in this course to do hands on practice along with me.
Funnel chart - the sales pipeline tracker
radar chart - the multivariate profile
The cheat sheet summarizing the usage of the important charts discussed in this course is attached to this lecture
The cheap sheet explained in this lecture could be downloaded under the filled map lecture.
This course is intended for data analyst, business analyst, professionals and students who use charts in ms excel to present their data. Here I have explained the differences in usage of each chart and then I demonstrated creating each charts with some good examples to get better understanding of their usage. Then I have also demonstrated formatting of the charts I explained. The lecture started with the highlighting difference in using bar chart and column chart, then explained other basic charts like line chart, pie chart and donut charts and area charts. After that the advanced excel charts like combo charts , waterfall charts, tree map charts etc... were also discussed in detail with a short demo using a business scenario. This course builds confidence in excel users in choosing the charts for their data without just guessing them. Few tips were given to improve the formatting of the charts created to present them professionally in a business meeting. Many of the us have great confusion in choosing the charts. If you choose wrong charts your data will be ruined and story telling will be poor. with this course you will improve your choices and your story telling will become wonderful.