Data Visualization with Excel Literacy (Beginner Level)

Topics covered

• add up/down bars and high/low lines to a line chart, copy and paste a line chart to a new sheet, and format the line chart
• 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 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 various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature
• customize various aspects of the line on a line chart, such as the thickness of the line and whether a line is represented using dashes, dots, or both.
• 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
• identify use cases that require tables and bar charts
• list use cases and best practices for line charts and pie charts
• open up Microsoft Excel and read in data from an Excel workbook and a CSV file
• outline different presentation types and considerations before choosing a chart type for your data
• recognize the importance of data visualization in the age of big data
• recognize use cases that require histograms and box plots
• visualize data using built-in Excel charts, explore various column chart types, and create basic and clustered column charts