Final Exam: Data Visualization with Excel
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.
WHAT YOU WILL LEARN
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 plotclassify the advantages and disadvantages of variants of line charts, such as stacked line charts, 100% stacked line charts, and 3D line chartscreate a basic area chart, illustrate a major disadvantage of an ordinary area chart, then change the opacity of areas to overcome this problemcreate 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 chartcreate a Gantt chart out of a basic stacked bar chartcreate an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, to visualize financial datacreate band charts to quickly visualize the trend in a line chartcreate various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that featurecreate various special histogramscustomize 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 relationshipformat the background fill, texture, axes, and title of a column chart and line chart and change the position of two charts relative to each otherillustrate the use of the gradient fill feature, change various aspects of a gradient-filled line chart, and work with radial gradients and linear gradientsimport data from a PDF document and a Microsoft Access database as well as all files from a folder into Excellist the best practices while building charts and visualizationsopen up Microsoft Excel and read in data from an Excel workbook and a CSV filerecall the right special case for Heatmaps, Funnel Charts, Sunburst Charts, and Sankey Chartsrecall why data visualization is important in this age of big datause a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar chartsvisualize 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
IN THIS COURSE
1.Data Visualization with Excel33sUP NEXT
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
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 platformDigital badges are yours to keep, forever.