G Suite Sheets - Advanced

Course Description

This course aims to fine-tune data manipulation and presentation skills for experienced GSuite Sheets users. The content is focused on how to clean, slice and dice data to allow in-depth data analysis. The new Macros feature in Sheets will also be covered.
1 days
Contact us for pricing

Prerequisites

This course is for experienced Sheets users who have attended the Intermediate level course, or who have commensurate skills and experience.

Pivot Tables

• Creating Pivot Tables
• Group data
• Create Calculated fields
• Creating a Pivot Chart

Functions

• Nested If Functions
• IF with And/Or/Not
• IF / VLookup
• Index / Match

Clean-up Functions

• Using Text to Column
• Upper case
• Lower case
• Left/Right
• Trim
• Len
• Concatenate
• Text

Sheets Tools

• Data Validation Rules
• Creating Lists

Pulling Data from a Spreadsheet

• Using ImportXML
• Using ImportHTML

Recording a macro

• How to record a macro
• Customising a recorded macro
• Launching a macro

DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteMacroSlidesGoogle