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.
Duration
2 days
Schedule
See training dates for details
Regular fee
$790
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$710
Objectives of the training
By the end of this training, participants will be able to use basic features to analyze data in Google Sheets.Targeted audience
Anyone who handles data in an administrative, operational, or commercial context and wants to use the essential features of Google Sheets more effectively.Prerequisite
Proficiency with office tools and experience using Google Workspace. Basic familiarity with Google Sheets is desirable.Trainers
Benefits for Participants
- 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).
Course architecture
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 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
Pedagogical details
Type of training
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
See training dates for details
Regular fee
$790
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$710
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote