Analyzing Data with Tables & Charts in Google Sheets 2020

IN THIS COURSE

• 1.  Analyzing your data with a pivot table in Google Sheets 2020
  4m 51s
  Once you have inserted a certain amount of data into your document, you may find it useful to reorganize your table to analyze it differently. This video will show you how to create a pivot table, which can be used to manipulate data in different ways with Google Sheets.  FREE ACCESS
• 2.  Developing your pivot table in Google Sheets 2020
  5m 24s
  Once you have created your pivot table, you will find that you can develop it and change the ways that it analyzes your data. In this video, you will find out how to add values to your Google Sheets' pivot table, change the formula used to summarize your entries, as well as to group your data by columns and rows. FREE ACCESS
• 3.  Sorting & filtering a pivot table in Google Sheets 2020
  4m 8s
  A pivot table report is an interactive table that allows you to interpret data in different ways without ever having to enter a formula. You can summarize and analyze a large set of data through different categorizations and calculations. Filtering and sorting will allow you to view yet another perspective of your data in Google Sheets. By combining both the sort and filter tools, you can narrow down your data and display what's most important to you. FREE ACCESS
• 4.  Adding calculated fields to your pivot table in Google Sheets 2020
  4m 8s
  Google Sheets allows you to add calculated fields to your pivot tables so that you can apply formulas to the data contained within them. Learn how to add a calculated field to your pivot table. You will also see how to customize or remove it. FREE ACCESS
• 5.  Copying & exporting your pivot table in Google Sheets 2020
  5m 5s
  There are a number of ways of sharing your Google Sheets' pivot table. You can copy or move your table within your worksheet or to another spreadsheet. This video will show you everything you need to know to share the data contained in your table. FREE ACCESS
• 6.  Creating a quick chart in Google Sheets 2020
  4m 4s
  The new Insights tool in Google Sheets allows you to create charts automatically using the data which has been entered into your spreadsheet. These charts can then be customized in order to present the data in a clear and compelling way. FREE ACCESS
• 7.  Inserting a chart in Google Sheets 2020
  4m 3s
  If you want to present your data in an illustrated form, you can use the chart function in Google Sheets. This tutorial will show you how to select the data you want included in the chart, and the different graphic styles available. FREE ACCESS
• 8.  Customizing your chart in Google Sheets 2020
  5m 32s
  Once you have inserted your chart, you can customize it in different ways. Here you will see out how to change the style of a chart, add a title, and also how to adjust the color and format of series and legends. FREE ACCESS
• 9.  Customizing your chart's axes in Google Sheets 2020
  5m 52s
  The axes of a chart give us a lot of information. They display units of measurement as well as minimum and maximum values. Google Sheets allows for the customization of your axes, which can increase the aesthetics as well as the readability of your chart. FREE ACCESS