Google Sheets Training Course
- Price
- Duration
- number of hours
Even if you are the only one registered, the session will still take place (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. Also discover our Google Docs training course and our Google Workspace training Course.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Even if you are the only one registered, the session will still take place (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.
This training course is part of our Cloud Office Tools Training. Discover our trainings on Microsoft 365, Google Workspace and collaborative suites to boost daily productivity.
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
- 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
Creating dynamic charts, conditional formatting, summaries with pivot tables, integration with Google Data Studio (Looker).
Collaboration and Versioning
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.).
FAQ – Google Sheets Training
What is Google Sheets?
Google Sheets is the cloud spreadsheet in Google Workspace. It offers advanced functions (ARRAYFORMULA, QUERY, IMPORTRANGE, REGEXMATCH), pivot tables, charts, Apps Script integration, BigQuery and Looker Studio connectors, and Gemini AI assistance.
Sheets or Excel: which one to choose?
Excel remains more powerful for advanced analysis, Power Query, and complex models. Sheets shines with real-time collaboration, cloud automation, APIs, and Google Workspace integration. Many organizations use both. MFE-IT helps you choose based on your use cases.
How do you automate processes in Google Sheets?
Via Apps Script (JavaScript), scheduled triggers, custom functions, recorded macros, external connectors, and Gemini for formula generation. MFE-IT provides hands-on practice with a complete automation case study.
How long does it take to master advanced Google Sheets?
Our Google Sheets training runs over 2 days (12 hours) in a 100% tailor-made format. It covers advanced functions, automation, and efficient collaboration.
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.