SkillSoft Explore Course – Lambers, Inc.

IT Skills Data and Databases Data Visualization A Complete and Comprehensive Guide to Excel

One of the primary purposes of using Excel is to analyze and present data in a focused, accessible, and accurate way. A great way to do this is with charts and sparklines.

In this course, you'll create basic chart types, such as line, bar, and pie charts, as well as more advanced charts, like treemaps and sunburst charts. In doing this, you'll work with the different aspects of Excel's chart customization capabilities, from chart element transparency to the orientation and exploding out of slices in a pie chart.

Next, you'll advance to use more statistically-oriented chart types, including histograms, scatter plots, and box-and-whisker plots.

Finally, you'll learn to create, customize, and work with Excel's sparklines, which are lightweight visualizations usually contained within a single cell.

Asset ID	it_dacgexdj_02_enus
Course Type	Video Course
Course Category	Data and Databases

Objectives
Complete Guide to Excel 365: Working With Charts & Sparklines discover the key concepts covered in this course insert charts and customize chart elements, such as the axes, title, data labels, data callouts, and grid lines, and add analytical elements based on standard deviation, percentage, and standard error, such as trendlines and error bars use the chart design item from the toolbar ribbon to change chart layout and color, switch rows and columns, change selected data and chart type, and control whether #N/As and empty cells are displayed as gaps or zeros create charts that occupy an entire worksheet and control their appearance using worksheet functions, plot pie charts and alter transparency, glow, and other visual aspects, explode and re-orient sections of pie charts, and work with treemaps and sunburst charts use histograms to summarize the statistical properties of data, bin data by category, bin width, or fixed number of bins, perform automatic binning, and set overflow and underflow bins perform univariate EDA (exploratory data analysis), use box-and-whisker plots to plot the mean, median, inter-quartile range and outliers, and choose between inclusive and exclusive median methods in quartile calculation perform bivariate EDA (exploratory data analysis), use scatter plots to examine relationships between two numeric data columns and the Chart Design menu to create linear, exponential, and other types of trendlines, and identify positively and negatively trending data plot geographical data such as countries, states, counties, or postal codes using the Map chart type, use other chart types such 2-D and 3-D column and area charts, and combine multiple visualizations into a single chart using a combo chart type construct at-a-glance visualizations using sparklines to build lightweight charts without axes or units contained within individual cells, and use named ranges to control data displayed in a sparkline visualization contrast Line and Column sparklines, control the appearance of high, low, and negative points, apply custom formatting to first and last points, display data in reverse order, and use the Quick Access Toolbar to view undoable actions summarize the key concepts covered in this course

Objectives

Complete Guide to Excel 365: Working With Charts & Sparklines

discover the key concepts covered in this course
insert charts and customize chart elements, such as the axes, title, data labels, data callouts, and grid lines, and add analytical elements based on standard deviation, percentage, and standard error, such as trendlines and error bars
use the chart design item from the toolbar ribbon to change chart layout and color, switch rows and columns, change selected data and chart type, and control whether #N/As and empty cells are displayed as gaps or zeros
create charts that occupy an entire worksheet and control their appearance using worksheet functions, plot pie charts and alter transparency, glow, and other visual aspects, explode and re-orient sections of pie charts, and work with treemaps and sunburst charts
use histograms to summarize the statistical properties of data, bin data by category, bin width, or fixed number of bins, perform automatic binning, and set overflow and underflow bins
perform univariate EDA (exploratory data analysis), use box-and-whisker plots to plot the mean, median, inter-quartile range and outliers, and choose between inclusive and exclusive median methods in quartile calculation
perform bivariate EDA (exploratory data analysis), use scatter plots to examine relationships between two numeric data columns and the Chart Design menu to create linear, exponential, and other types of trendlines, and identify positively and negatively trending data
plot geographical data such as countries, states, counties, or postal codes using the Map chart type, use other chart types such 2-D and 3-D column and area charts, and combine multiple visualizations into a single chart using a combo chart type
construct at-a-glance visualizations using sparklines to build lightweight charts without axes or units contained within individual cells, and use named ranges to control data displayed in a sparkline visualization
contrast Line and Column sparklines, control the appearance of high, low, and negative points, apply custom formatting to first and last points, display data in reverse order, and use the Quick Access Toolbar to view undoable actions
summarize the key concepts covered in this course