Course length

1 day

Why come on this course?

In this hands-on instructor led course, you will learn about the Google Sheets app to an intermediate level. Following the course, delegates will be confident in analysing their data in Google Sheets using various formulas, functions and database analysis tools.

Course contents

Working with Advanced Functions

• Working with Range Names
• Mixed References
• Using Specialised Functions

Database Management

• Sorting
• Filtering
• Filter Views
• Grouping Rows and Columns
• Explore
• Database Functions

Working with Charts

• Creating Charts
• Editing and Formatting
• Exploring Chart Types

Working with Pivot Tables

• Why Use a Pivot Table?
• How to Create a Pivot Table
• Adding a Date Field
• Filter and Drill
• Adding a Calculated Field

Templates

• Working with Google Templates
• Creating a Hyperlink
• Notes and Comments