Google Sheets: Google Sheets fundamentals

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

• Basic tips and tricks: propagating a formula, extending a series, freezing panes, reference types, hiding cells and sheets, keyboard shortcuts for selecting data
• Setting up sorting and automatic filters for data
• Creating a filtered view
• Using SUM and SUBTOTAL functions
• Presenting a data table with alternating colors
• Data validation: numbers, dates, choice lists
• Column statistics
• Creating and setting up a chart
• Formatting numbers and dates
• Cell formatting: alignment, text and background color, wrapping, width and height
• Conditional formatting
• Google Sheets tables
• Using pivot tables
• Associating a chart with a pivot table
• Understanding the VLOOKUP function
• An overview of some powerful and exclusive Google Sheets functions (UNIQUE, FLATTEN, FILTER)