PRDV007: Spreadsheets III: Presenting Data

Watch this Microsoft Excel tutorial on creating column, line, and pie charts. 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.

Watch this tutorial on how to make a stacked bar (or stacked column) chart. These charts help present comparisons among groups. The author makes a regular bar chart and then a stacked bar chart to compare data from different groups.

Making charts using Google Sheets is similar to Excel. Watch these four videos to explore how to create each chart type in Google Sheets.

Watch this Microsoft Excel tutorial on presenting data in a chart using ALT FI, Quick Analysis, and Recommended Charts. If you are unsure about the best chart, these methods can help you get started.

Read this text to review each primary chart type and the steps for creating them. Be sure to study when it is more appropriate to use specific charts than others.

Watch this video to see how the author formatted the title, axes, and colors for a series of column charts.

Read this Microsoft Excel tutorial to learn tips for formatting various elements of your chart, such as the axes, title and legend, data series labels, plot area, and annotations. Each section provides step-by-step guidance with screenshots on how to perform the formatting.

Watch this video to learn how to use charts in Excel and other Microsoft Office products.

Read this text on constructing a scatter chart for supply and demand data. The reading outlines the steps for creating a scatter chart after Figure 4.45. Most of the text details how to format these charts. Pay careful attention to the section "Adding a Trendline and Equation" since it provides step-by-step guidance on how to add a trendline in Excel. Note that a linear fit did not work in the example, and they needed to use a different fit.

Watch these two brief videos showing worked examples of creating a scatter plot and determining the best-fit trend line.

This process is similar to Google Sheets. Watch this tutorial on creating scatter plots with trendlines in Google Sheets.

Watch this video, which walks you through producing a combination chart.

Watch this video on how to create sparklines in an annual sales spreadsheet.

We can also use sparklines in Google Sheets. Watch this video on creating sparklines in Google Sheets to display donations to an organization over time.

Watch this video, which shows how to insert shapes into a spreadsheet. Notice that the drawing format tab pops up when you add a shape so you can format and edit it. The tutorial shows many of the Excel shapes and formatting options.

Watch this video, which shows how to format shapes to enhance visibility and draw attention to essential elements in the chart or spreadsheet.

Often, shapes do not convey the information you need to display in your spreadsheet or chart. Insert pictures and graphics from your computer or another online source into your Excel file. For example, you may wish to insert your company logo into your spreadsheet.

Watch this short video to learn how to insert a saved picture into a spreadsheet. The picture tools format tab pops up when you select or add your picture.

Watch this video to learn how to add a hyperlink to an Excel file.

Watch this short video to learn how to use WordArt and symbols in an Excel file.

Watch this short video to learn how to add a SmartArt graphic to help visually communicate data.

Watch this short video to learn how to use conditional formatting to represent your data visually in Excel.

Watch this video on how to use conditional formatting to highlight data using Google Sheets.

Watch this video to learn how to insert headers and footers into an Excel spreadsheet.

Watch this video on creating and formatting an Excel table using an example of a list of pets and their identifying information. The tutorial shows how to convert columns in an Excel worksheet into a table. Then, it explains how to do some basic formatting and add columns to the table.

This video provides key moments focusing on basic and more advanced table functions.

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 an Excel table.

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 we discuss in detail in the last section of this unit. However, the sort feature is the same as for regular tables.

Read this chapter, which provides a visual tutorial on converting a table back into a list of data and then subtracting the data into "chunks."

Watch this video for a detailed description of PivotTables. The presenter explains when to use them, how to create one, and how to edit one to obtain your desired information.

Watch this video to learn about slicer filtering controls, how to use timelines to filter specific periods, and how PivotCharts can be used to analyze PivotTable data.

Finally, watch this video for a tutorial on how to create a Pivot Table in Google Sheets.

Watch this video on the features of Microsoft OneDrive.

Google Drive and Microsoft OneDrive offer many of the same collaboration features. Watch this video, which shows how to copy, sort, rename, and organize your files using Google Drive. The presenter also shows how to convert a Word document to Google Docs.

Watch this video to learn how to protect worksheets, ranges, and cells in Google Sheets.

Watch this video on ways to prevent collaborators from making accidental or unauthorized changes while sharing files.

Watch this short video on how to use comments in Excel.

This video explains how to insert comments in Google Docs and Google Sheets.

Watch these two videos, which explore Excel's Power Automate feature.

Watch this brief video on how to create a Form in Microsoft Excel.

Watch this video, which introduces Google Forms and discusses using the advanced features in a teaching and learning environment. The instructor explains how to construct a page, add videos, draft questions, create branches, provide feedback to students, and organize statistics and summaries.

Watch this video, which details how to create a Google Form, add questions, create a color palette or theme, adjust the default settings, preview your form before sending it, send it to collaborators, view responses, and perform additional actions (such as making a copy, deleting the form, printing, and adding collaborators).

Watch this video for six additional tips on using Google Forms.