Topic	Name	Description
Course Syllabus	Course Syllabus

1.1: Types of Charts	Creating Charts in Microsoft Excel	Watch this tutorial on creating column, line, and pie charts in Microsoft Excel. When the author changes the data in the original worksheet, the data automatically changes in the chart. This is one of the great features of making charts in a spreadsheet program: any changes you make to your data will automatically update your chart.
	How to Make Stacked Bar Charts	Watch this tutorial on how to make a special type of bar or column chart called the stacked bar (or stacked column) chart. These charts are useful for making comparisons between groups. The author makes a regular bar chart first, and then makes a stacked bar chart to compare data from different groups.
	Creating Charts in Google Sheets	The process for making charts using Google Sheets is quite similar to Microsoft Excel. Watch these four tutorials, which describe how to create each type of chart in Google Sheets.

1.2: Choosing a Chart	Choosing a Chart	Read this section, which details each major chart type and reviews how to create them. Review the examples to see when it is appropriate to use each type of chart.

2.1: Scatter Charts	The Scatter Chart	This section describes how to construct and format a scatter chart for supply and demand data. Pay careful attention to the section on adding trendlines, which gives step-by-step guidance using Microsoft Excel. In the example, a linear fit did not work, and they needed to use a different fit.
	Scatter Charts and Best-Fit Lines in Microsoft Excel	Watch these two examples of how to create a scatter plot and determine the best-fit trend line in Microsoft Excel.
	Scatter Charts and Best-Fit Lines in Google Sheets	This process is similar in Google Sheets. Watch this tutorial on how to create scatter plots with trendlines in Google Sheets.

2.2: Combination Charts	Creating a Combination Chart	Watch this walkthrough of how to produce a combination chart.

2.3: Sparklines	Creating Sparklines in Microsoft Excel	Watch this video on how to create sparklines.
	Creating Sparklines in Google Sheets	We can also use sparklines in Google Sheets. Watch this video on how to create sparklines in Google Sheets to display donations to an organization over time.

3.1: Adding Shapes, Callouts, and Clipart	Adding Shapes, Callouts, and Clipart	Watch this video on how to insert shapes and clipart into a spreadsheet. A toolbar pops up when you add or select a picture that lets you format and edit it. The tutorial shows many of the graphics formatting and editing options available in Microsoft Excel.

3.2: Adding Pictures	Adding Pictures	Watch this short video on how to insert a saved picture into a spreadsheet. The picture formatting toolbar pops up when you select or add a picture to a spreadsheet.

3.3: WordArt and Symbols	WordArt and Symbols	Watch this short video to learn how to use WordArt and symbols in Microsoft Excel.

3.4: Adding Hyperlinks	Adding Hyperlinks	Watch this video to learn how to add a hyperlink in Microsoft Excel.

3.5: Headers and Footers	Headers and Footers	Watch this video to learn how to insert headers and footers into a Microsoft Excel spreadsheet.

4.1: Creating and Formatting a Table	Creating a Table	This video describes how to create and format a Microsoft Excel table using a list of pets and their identifying information and how to convert columns in a worksheet into a table. Then, it explains how to do some basic formatting and how to add columns to the table.

4.2: Sorting and Filtering Data	Filtering Data	Watch this video, which uses the example of a table of donors to a charity with the amount they donated to each program to show you how to filter data in a table.
	Sorting Data	Watch this video for a tutorial on how to use the sort feature in Excel tables. This example uses a pivot table, a type of table that we will discuss in detail later. Even so, the sort feature is the same as for regular tables.

4.3: Outlining Data	Convert to Range for Subtotaling	Read this tutorial on converting a table back into a list of data and then subtotalling the data into chunks. Pay attention to the commands you need in the toolbar to perform the operations.

4.4: Pivot Tables and Pivot Charts	Pivot Tables in Microsoft Excel	Watch this detailed description of pivot tables. It explains when you should use a pivot table, how to create them, and how to edit one to get the information you want.
	Pivot Tables in Google Sheets	Watch this tutorial on how to create a pivot table in Google Sheets.

Course Feedback Survey	Course Feedback Survey