Technologies

Google Sheets for Excel users

Practical workshop training for Microsoft Excel users who want to work effectively in the Google Sheets environment. The course program is designed to use participants' existing Excel knowledge as a starting point for exploring the capabilities of Google Sheets. The training pays special attention to the unique features of Google Sheets related to working in the cloud and team collaboration. The class is conducted in a workshop format, where each topic is discussed through comparison to its Excel counterpart.

Issues

Google Sheets interface
Formulas and functions
Data formatting
Real-time collaboration
Version control
Google Apps Script
Integration with Google Workspace
Privilege management
Importing data
Publishing sheets
Offline work
Data security

Benefits

A smooth transition from Excel to Google Sheets
Ability to work effectively in the cloud
Knowledge of team collaboration tools
Ability to automate routine tasks
Knowledge of the unique features of Google Sheets
Ability to manage access to data
Familiarity with Google Workspace integration
Certificate confirming knowledge of Google Sheets

Who is this training for?

Excel users migrating to Google Workspace

Employees of companies switching to Google Workspace

Reporting and data analytics specialists

Individuals working in remote teams

Project coordinators using spreadsheets

Business analysts in need of collaboration tools

Managers of distributed teams

Employees of financial and controlling departments

Prerequisites

Practical knowledge of Microsoft Excel
Google account (business or private)
Basic knowledge of working in a browser
Own laptop with internet access
Permission to install plug-ins in the browser

Training program

Basic operations and keyboard shortcuts
Organizing files and folders in Google Drive
Configure settings and preferences

Excel function equivalents in Google Sheets
Google Sheets' unique features (GOOGLEFINANCE, IMPORTDATA)
Conditional formatting and validation rules
Working with named scopes and references

Access and privilege management
Simultaneous operation of multiple users

Version history and restoring changes

Google Apps Script Basics
Integration with other Google Workspace tools

Publishing and embedding sheets

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

For Google Sheets for Excel users we recommend: Practical knowledge of Microsoft Excel; Google account (business or private); Basic knowledge of working in a browser.

What is the format and duration of this training?

The training lasts 2 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: Excel users migrating to Google Workspace; Employees of companies switching to Google Workspace; Reporting and data analytics specialists.