Google On-Demand: Sheets Data Analysis and Visualization

Working with Data Sorting Data Filtering Data Using Filter Views Grouping Data Inserting Links Working with Links Working with Data Validation Importing and Manipulating Data Uploading a Microsoft Excel Workbook into Google Sheets Importing a Table or List on a Web Page into Google Sheets Importing Data Removing Duplicates Trimming Whitespace Using Cleanup Suggestions Using Column Stats Splitting Text into Columns Randomizing a Range of Data Creating and Working with Pivot Tables Understanding Pivot Tables Creating a Suggested Pivot Table Creating a New Pivot Table Creating a Pivot Table using Explore Using VLOOKUP to Add a Column to a List Using the Pivot Table Editor Viewing Cell Details Creating a Calculated Field Using Slicers Creating a Chart from a Pivot Table Working with Formatting Working with Custom Formats Using Conditional Formatting Creating a Custom Formula with Conditional Formatting Using Alternating Colors Changing the Theme Working with Explore Sharing Spreadsheets Sharing a Spreadsheet Sharing a Link to a Spreadsheet Publishing to the Web Protecting Sheets and Ranges Working with Comments Downloading Spreadsheets in Other Formats Emailing a File Using Google Sheets Data in Other Google Apps Pasting a Sheets Range into Docs or Slides Pasting a Sheets Chart into Docs or Slides Inserting a Sheets Chart into Docs or Slides Working with Linked Objects Creating and Modifying a Chart in Docs or Slides Pasting a Docs or Slides Table into Google Sheets Creating a Form in Sheets Working with Form Data Working with Special Chart Types Becoming Familiar with Special Chart Types Creating a Geo Chart Creating a Waterfall Chart Creating a Histogram Chart Creating a Radar Chart Creating a Gauge Chart Creating a Scorecard Chart Creating a Candlestick Chart Creating an Organizational Chart Creating a Tree Map Chart Creating a Timeline Chart Creating a Table Chart Creating a Combo Chart Creating a Sparkline