Gain autonomy and efficiency with the key data analysis features offered by Google Sheets
Too often underestimated, Google Sheets is a powerful tool that can transform your daily efficiency, particularly when it comes to data analysis. However, without a clear method or guidelines, its many features, including sorting, formulas, formatting, and pivot tables, can quickly discourage unfamiliar users.
This training is for people who want to consolidate the basics needed to effectively manipulate, structure, and present data in Google Sheets. Suitable for users with minimal experience with Google Sheets (or Microsoft Excel), it teaches good habits and simple practices to gain autonomy and productivity.
From organizing a table to using essential calculation functions, creating charts, filters, and pivot tables, each section is designed to provide a practical understanding of the available tools. An introduction to some advanced features exclusive to Google Sheets will complete the training.
Is it for you ?
Anyone who handles data in an administrative, operational, or commercial context and wants to use the essential features of Google Sheets more effectively.
Prerequisites
Proficiency with office tools and experience using Google Workspace. Basic familiarity with Google Sheets is desirable.
What You'll Walk Away With
- ✓ Learn the right techniques for organizing data in a clear, structured, and easy-to-use way in Google Sheets.
- ✓ Save time by using essential calculation functions, filters, and pivot tables to better read and analyze your data.
- ✓ Improve the readability and impact of your tables with a polished visual presentation (conditional formatting, charts, dynamic formats).
Training content
1 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
2 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
3 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
4 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 spreadsheets to anticipate incompatibilities
- Discover exclusive and powerful functions such as UNIQUE, FLATTEN, and FILTER, which are useful for dynamically extracting, combining, or filtering data sets
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
