Course Length

1 day

Why come on this course?

In this course you will learn about the Google Sheets app to an advanced level.  Following the course, you will be confident in analysing and manipulating your data in Google Sheets using various advanced formulas and functions. You will cover more advanced sheets functionality like conditional formatting, data validation and sheet protection. 

Course contents

Automating Tasks in Sheets with Macros

  • What is a Macro
  • Record Macros
  • Comparing Relative and Absolute Macros
  • Running a Macro
  • Edit or Delete a Macro

Formatting Cells with Conditional Formatting

  • Add Conditional Formatting to a Range of Cells
  • Add Multiple Conditional Formats
  • Apply a Conditional Format with Colour Scales
  • Apply Conditional Format with Formulas

Use Data Validation to Restrict User Entry

  • Restrict User Entry with Numbers
  • Restrict User Entry with Text
  • Dropdown List Validation
  • Creating Dynamic Validation Lists

Google Sheet Protection and Sharing

  • Protecting a Cell Range
  • Protecting a Google Sheet
  • Applying an Editable Range to a Protected Sheet
  • Share a Protected Sheet with a Colleague

Advanced Formulas and Functions

  • Date and Time Functions
  • Logical Functions – IF, AND, OR, SUMIFS
  • Lookup Functions – Index, Match
  • Array Formulas in Sheets

Working with Sparklines

  • What are Sparklines
  • Insert Sparklines into a Google Sheet
  • Change Sparkline Options

Importing and Exporting

  • Importing a Range of Data from another Google Sheet
  • Importing Data from a Web Page
Contact Alpha Training