Google Sheets Data Analysis and Visualization (Live Online)

This one-day Google Sheets Data Analysis class will show you some of the amazing things that Google Sheets can do. While Google Sheets is easy to use at an introductory level, it also has significant power to do more complex things. Covered in this class are advanced features and functions for conditional processing (IF statements and conditional functions), dealing with text, database lookups, working with date fields, queries and much more! You will be amazed by all of the advanced features that you never knew were available in Google Sheets.Who Should AttendThe class is for Google Sheets Power Users.PrerequisitesBefore taking this class, we recommend that you have experience creating worksheets in Google Sheets or have taken ONLC’s Introduction to Google Sheets class.Course OutlineWorking with DataSorting DataFiltering DataUsing Filter ViewsGrouping DataInserting LinksWorking with LinksWorking with Data ValidationImporting and Manipulating DataOpening a Microsoft Excel Workbook in Google SheetsImporting a Table or List on a Web Page into Google SheetsImporting DataRemoving DuplicatesTrimming WhitespaceUsing Cleanup SuggestionsUsing Column StatsSplitting Text into ColumnsRandomizing a Range of DataCreating and Working with Pivot TablesUnderstanding Pivot TablesCreating a Suggested Pivot TableCreating a New Pivot TableCreating a Pivot Table using ExploreUsing VLOOKUP to Add a Column to a ListUsing the Pivot Table EditorViewing Cell DetailsCreating a Calculated FieldUsing SlicersCreating a Chart from a Pivot TableWorking with FormattingWorking with Custom FormatsUsing Conditional FormattingCreating a Custom Formula with Conditional FormattingUsing Alternating ColorsChanging the ThemeWorking with ExploreSharing SpreadsheetsSharing a SpreadsheetSharing a Link to a SpreadsheetPublishing to the WebProtecting Sheets and RangesWorking with CommentsDownloading Spreadsheets in Other FormatsEmailing a FileUsing Google Sheets Data in Other Google AppsPasting a Sheets Range into Docs or SlidesPasting a Sheets Chart into Docs or SlidesInserting a Sheets Chart into Docs or SlidesWorking with Linked ObjectsCreating and Modifying a Chart in Docs or SlidesPasting a Docs or Slides Table into Google SheetsCreating a Form in SheetsWorking with Form DataWorking with Special Chart TypesBecoming Familiar with Special Chart TypesCreating a Geo ChartCreating a Waterfall ChartCreating a Histogram ChartCreating a Radar ChartCreating a Gauge ChartCreating a Scorecard ChartCreating a Candlestick ChartCreating an Organizational ChartCreating a Tree Map ChartCreating a Timeline ChartCreating a Table ChartCreating a Combo ChartCreating a Sparkline