Data Visualization with Excel Proficiency (Advanced Level)

  • 10m
  • 10 questions
The Data Visualization with Excel Proficiency benchmark will measure your ability to recall, relate, demonstrate, and apply data visualization concepts and techniques in Excel. You will be evaluated on your ability to draw, customize, and visualize various types of charts and graphs in Excel. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand, apply, and work independently on visualization projects using Excel.

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