Google Sheets Training Course
- Price
- Duration
- number of hours
Our sessions are guaranteed with a minimum of one participant (except in cases of force majeure).
Description of this Google sheets training course
Already using Google Sheets but want to take it to the next level? Whether you want to save time, automate certain tasks or present your data more effectively, this Google Sheets training course will help you professionalise your spreadsheets and harness the full power of Google’s spreadsheet software.
Through practical examples, you will learn how to create powerful formulas, structure your spreadsheets, secure your data and collaborate effectively with your colleagues.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Sessions are guaranteed with a minimum of one participant (except in cases of force majeure). A preliminary interview is held between the participant and/or a company representative in order to fully assess the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment : during the training course, the trainer assesses the participants’ progress through multiple-choice questions, role-playing exercises and practical work. Participants receive a certificate of completion at the end of the training course.
objectives of this Google sheets training course
By the end, each participant will be able to :
- Create advanced formulas (IF, VLOOKUP/XLOOKUP, QUERY, IMPORTRANGE, etc.)
- Use named ranges, data validation, and drop-down menus
- Build dashboards and visualise your data effectively
- Use advanced filters, custom sorting, and filtered views
- Collaborate securely with sharing and commenting features
- Use add-ins and automate with simple triggers
prerequisites of this Google sheets training course
- Master the basics of Google Sheets (simple formulas, navigation, creating tables)
- Be comfortable with office software logic (copy/paste, filter, sort, use multiple tabs)
Because each participant is unique, a personalised interview with our expert allows us to design a training course that is perfectly aligned with their objectives, level and professional challenges.
target of audience
Ideal for assistants, project managers, management controllers, analysts, project leaders, or support staff.
detailed of this Google sheets training course
Mastering advanced formulas
Conditional functions, lookup functions, cross-references, nested formulas, common errors to avoid.
Data structuring and security
Named ranges, validation, drop-down lists, range and cell protection, locking.
Visualisation and dashboards
Création de graphiques dynamiques, mise en forme conditionnelle, synthèses par tableau croisé dynamique, intégration avec Google Data Studio (Looker).
Collaboration et versionnage
Advanced sharing, version history, assigned comments, change notifications.
Automation and add-ons
Use of simple scripts, automatic functions, integration of useful extensions (e.g. Autocrat, FormMule, Power Tools, etc.).
The advantages of this training course
- Is business-oriented : it provides directly applicable skills.
- Offers clear teaching methods, even for non-technical profiles.
- Combines productivity + rigour + collaboration.
- Provides concrete examples from professional situations (reporting, planning, data collection, internal CRM, etc.).
FORMA-IT's training courses are also supportive
At Forma-IT, we believe that training can also be a lever for solidarity. This is why part of each registration is donated to associations that work in areas that are close to our hearts:
The SPA, for animal protection
The Restos du Cœur, for the fight against precariousness
Ludopital, to make the daily lives of hospitalized children easier
- APF France Handicap, for the rights of people with disabilities and their families
By choosing Forma-IT, you invest in your skills while contributing to essential causes.
Our related training courses
Google Docs training Course – Master advanced features to produce professional and collaborative documents
Optimise your layout, styles, automation and efficiency.
Google Workspace training Course – Master Gmail, Drive, Docs and Meet for everyday teamwork
Develop the right collaborative habits in the Google environment.
Would you like to know about upcoming sessions ?
Would you like to schedule this Google Sheets Training Course on a specific date ? Contact us by email or by filling out the contact form.