SkillSoft Explore Course – Lambers, Inc.

Aspire Data Visualization Mastery Data Visualization Track 1: Data Visualization with Excel

Final Exam: Data Visualization with Excel will test your knowledge and application of the topics presented throughout the Data Visualization with Excel track of the Aspire Data Visualization Journey.

Asset ID	it_fedvp_01_enus
Course Type	Video Course
Course Category	Data Visualization Mastery

Objectives
Final Exam: Data Visualization with Excel add labels to a box-and-whisker plot, create a box-and-whisker plot with two sets of boxes and whiskers grouped based on a category, and perform various formatting operations on this plot 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 to overcome this problem create a basic line chart, experiment with the data label options in a line chart, and change the fill color of the line in a line chart create a Gantt chart out of a basic stacked bar chart create an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, to visualize financial data create band charts to quickly visualize the trend in a line chart create various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature create various special histograms customize various aspects of a bar chart, such as the axis configurations, the overlap between the bars, and the size of the bars display the relationship between two variables and understand what kind of model might be most useful to represent that relationship format the background fill, texture, axes, and title of a column chart and line chart and change the position of two charts relative to each other illustrate the use of the gradient fill feature, change various aspects of a gradient-filled line chart, and work with radial gradients and linear gradients import data from a PDF document and a Microsoft Access database as well as all files from a folder into Excel list the best practices while building charts and visualizations open up Microsoft Excel and read in data from an Excel workbook and a CSV file recall the right special case for Heatmaps, Funnel Charts, Sunburst Charts, and Sankey Charts recall why data visualization is important in this age of big data use a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar charts visualize the trend of a stock's performance based on high, low, and close values over a specific period using the Excel High-Low-Close stock chart

Objectives

Final Exam: Data Visualization with Excel

add labels to a box-and-whisker plot, create a box-and-whisker plot with two sets of boxes and whiskers grouped based on a category, and perform various formatting operations on this plot
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 to overcome this problem
create a basic line chart, experiment with the data label options in a line chart, and change the fill color of the line in a line chart
create a Gantt chart out of a basic stacked bar chart
create an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, to visualize financial data
create band charts to quickly visualize the trend in a line chart
create various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature
create various special histograms
customize various aspects of a bar chart, such as the axis configurations, the overlap between the bars, and the size of the bars
display the relationship between two variables and understand what kind of model might be most useful to represent that relationship
format the background fill, texture, axes, and title of a column chart and line chart and change the position of two charts relative to each other
illustrate the use of the gradient fill feature, change various aspects of a gradient-filled line chart, and work with radial gradients and linear gradients
import data from a PDF document and a Microsoft Access database as well as all files from a folder into Excel
list the best practices while building charts and visualizations
open up Microsoft Excel and read in data from an Excel workbook and a CSV file
recall the right special case for Heatmaps, Funnel Charts, Sunburst Charts, and Sankey Charts
recall why data visualization is important in this age of big data
use a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar charts
visualize the trend of a stock's performance based on high, low, and close values over a specific period using the Excel High-Low-Close stock chart