Data Visualization with Excel Proficiency (Advanced Level)

Topics covered

• create a box-and-whisker-plot with separate categories on the x-axis and based on the color of the box, then add lines linking the means for all categories
• create an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, in order to visualize financial data
• create a pie chart to display a few categories and the proportions that add up to a whole, then explode specific slices in the pie chart
• create a waffle or KPI chart with a grid of percentages that update based on an index that in turn updates based on the value of a spin button
• create a waterfall chart to show the cumulative effect of positive and negative values over a specified period of time to add up to a total final value
• display the relationship between two variables and understand what kind of model might be most useful to represent that relationship
• illustrate how a 100% stacked area chart is computed so that there is no overlap in the areas and the proportions of individual categories from a whole can be assessed easily
• illustrate the use of various features related to trendlines, such as predicting future N periods
• outline the use cases for heatmaps, funnel charts, sunburst charts, and Sankey diagrams
• use the pie-of-pie chart type to create one pie chart with an 'other' category and a second pie chart that expands the fields in that 'other' category