Data visualization in Excel : Master Charts and Graphs, Choosing right chart at right time helps at great business decision making insights.
Course Description
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.
