SKILL BENCHMARK

Data Visualization with Excel Competency

  • 14m
  • 14 questions
The Data Visualization with Excel Competency benchmark will measure your ability to recall, relate, and demonstrate how to apply underlying data visualization concepts and techniques in Excel. You will be evaluated on your ability to recognize the concepts of data visualization and Excel techniques and functions for various types of charts and graphs. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand and apply visualization techniques in projects using Excel.

Topics covered

  • classify the advantages and disadvantages of variants of line charts, such as stacked line charts, 100% stacked line charts, and 3D line charts
  • create a basic area chart, illustrate a major disadvantage of an ordinary area chart, then change the opacity of areas in order to overcome this problem
  • create a histogram to bin a continuous data series, visualize the counts of rows in each bin, and create histograms for normally and non-normally distributed data series
  • 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
  • customize a clustered column chart, add trendlines and format the chart, then create a basic line chart
  • customize histograms using various options, such as the overflow and underflow bins to truncate the histogram on either side
  • describe the difference between a column chart and a bar chart, create a clustered bar chart, and perform various operations, such as sorting on that chart
  • format various aspects of a radar chart's appearance, add individual points to it, and create filled radar charts
  • illustrate the use of various features related to trendlines, such as predicting future N periods
  • import an Excel file as an XML file and separately import a JSON file into Excel and open it up in the Power Query Editor
  • use a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar charts
  • 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
  • use trendlines to explore the suitability of various kinds of regression models, such as linear regression and polynomial regression via a line chart
  • visualize the trend of a stock's performance based on high, low, and close values over a specific period of time using the Excel High-Low-Close stock chart