Google Sheets: Essential Features

Objectives

At the end of this training, the participant will be able use the basic features of Google Sheets to perform data analysis.

Targeted audience

Any audience.

Content

Learn basic functions and time-saving tips

• Formula propagation and series extension
• Reference types (absolute and relative)
• Freezing panes and hiding cells or sheets
• Useful keyboard shortcuts for selecting and manipulating data ranges

Organizing and structuring your data

• Simple sorting and configuring automatic filters
• Creating filtered views (collaborative or individual)
• Validating data (numbers, dates, lists)
• Clear presentation of data: alternating colors, alignments, cell adjustments
• Formatting numbers and dates

Summarizing, calculating, and visualizing data

• Using the SUM and SUBTOTAL functions
• Displaying and reading column statistics
• Creating simple charts from data ranges
• Conditional formatting
• Introduction to pivot tables and linking them to charts

Explore advanced or Google Sheets-specific functions

• Understanding and applying the VLOOKUP function
• Best practices for getting started with tables in Google Sheets (named ranges, structured references)
• Compare Google Sheets and Excel tables to anticipate incompatibilities
• Discover exclusive and powerful functions such as QUERY, UNIQUE, FLATTEN, and FILTER, which are useful for dynamically extracting, combining, or filtering data sets