Analyzing tables & customizing charts in Sheets 2022

IN THIS COURSE

• 1.  Overview: Analyzing tables & customizing charts in Sheets 2022
  59s
  This video outlines the key content covered in the Analyzing tables & customizing charts in Sheets 2022 course, including developing your data with a pivot table, creating a quick chart, and customizing your chart. FREE ACCESS
• 2.  Analyzing your data with a pivot table in Sheets 2022
  4m 49s
  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. You can create a pivot table, which can be used to manipulate data in different ways with Google Sheets. FREE ACCESS
• 3.  Developing your pivot table in Sheets 2022
  4m 41s
  Once you have created your pivot table, you will find that you can develop it and change the ways that it analyzes your data. You are able 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
• 4.  Sorting & filtering a pivot table in Sheets 2022
  3m 37s
  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
• 5.  Adding calculated fields to your pivot table in Sheets 2022
  4m 29s
  Google Sheets allows you to add calculated fields to your pivot tables, so you can apply formulas to the data contained within them. You are also able to customize and format calculated fields or remove them. FREE ACCESS
• 6.  Copying & exporting your pivot table in Sheets 2022
  4m 35s
  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. It is also possible to export a pivot table and open it in Microsoft Excel. FREE ACCESS
• 7.  Creating a quick chart in Sheets 2022
  3m 34s
  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
• 8.  Editing a chart in Sheets 2022
  3m 22s
  If you want to present your data in an illustrated form, you can use the chart function in Google Sheets. You can select the data you want to include in the chart, and the different graphic styles available. FREE ACCESS
• 9.  Customizing your chart in Sheets 2022
  3m 55s
  Once you have inserted your chart, you can customize it in different ways. You are able to change the style of a chart, add a title, and also adjust the color and format of series and legends. FREE ACCESS
• 10.  Customizing your chart's axes in Sheets 2022
  5m 32s
  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
• 11.  Connecting a sheet to BigQuery in Sheets 2022
  3m 30s
  In Google Sheets, you can connect a sheet to BigQuery, where you can schedule or manually run queries. You can save those queries in the spreadsheet for analyzing and sharing. FREE ACCESS
• 12.  Managing your connected sheet in Sheets 2022
  3m 30s
  When using connected sheets, you have access to many tools to manage your data. You can apply and remove filters to the columns in the table, as well as use functions to help analyze your data. FREE ACCESS