Final Exam: Data Visualization with Excel

Data Visualization    |    Beginner
  • 1 Video | 10m 32s
  • Includes Assessment
  • Earns a Badge
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 Skillsoft Aspire Data Visualization Journey.


  • 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


  • Playable
    Data Visualization with Excel


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.


Likes 0 Likes 0