Google Sheets Intermediate Training

AcademyX's Google Sheets Intermediate class covers the more power features in Google Sheets. This class will provide hands-on training on Google Sheets Pivot Tables, advanced functions, advanced charting techniques, splitting text into columns, and much more.

Topics covered:

  • Pivot Table Analysis
    • What is a Pivot Table
    • Creating a Pivot Table
    • Changing the Layout of a Pivot Table
    • Editing the Pivot Table Source Data
    • Creating a Calculated Field
    • Changing the Summary Function in a Pivot Table
    • Changing the Relationship of the Value Field
    • Sorting Values in a Pivot Table
    • Grouping Pivot Table Fields
    • Expanding or Collapsing Grouped Fields
    • Formatting Pivot Table Data
  • Applying Advanced Functions
    • Applying Advanced Functions
    • Best Practice for Creating Functions
    • Logic Functions
    • Condtional Logic Functions
    • Lookup Functions
    • Date Functions
    • The NetWorkDays Function
    • The DateDif Function
    • The Year and Month and Text Functions
    • The Upper, Lower, and Proper Text Functions
    • The Len and Find Text Functions
    • Concatenate Function
    • Split Text To Columns Command
  • Applying Conditional Formatting
    • What is Conditional Formatting
    • Use a Formula to Conditionally Format Rows
    • Use Color Scales To Conditionally Format Rows
  • Protecting Google Sheet Data
    • Protecting Google Sheet Data
    • Hide Google Sheets
    • Set Notification Rules
    • Set Data Validation
    • Share a Google App File
  • Advanced Charting Techniques
    • Advanced Charting Techniques
    • GEO Charts
    • Publishing Charts To A Website
  • Appendix
    • Logic, Date, and Text Function Definitions
    • Date And Time Functions
    • Text Functions
    • Keyboard Shortcuts
    • Importing Excel Data Into Google Sheets
    • Excel File Converted to Google Sheets
    • Import Excel Data Into Existing Google Sheet
    • Importing Excel Conversion Issues
    • Common Conversion Issues Importing From MS Excel to Google Sheets
    • Setting Google Sheets to Auto-Convert Excel Worksheets
    • Exporting A Google Sheet File To Microsoft Excel

Prerequisites:

  • Familiarity with web browsers, tabs, new windows, links, and filing systems with files and folders
  • Understanding of cell references, formulas and functions.

Google Sheets Intermediate training offered at