Automation & Development
Google Sheets & Apps Script
Master Google Sheets for data analysis, collaboration, and automation. From formulas and formatting to Apps Script and advanced data tools, learn the full power of Google's cloud-native spreadsheet.
Live virtual sessions or on-site training
3 Levels
Need a custom curriculum for your team? Contact us
What You Will Learn
Advanced Formulas
Apps Script
API Integration
Collaborative Workflows
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modules01
Day 1: Spreadsheet Essentials
- Navigating the Google Sheets interface and toolbar
- Creating, renaming, and organizing spreadsheets in Drive
- Cell formatting: fonts, borders, colors, and number formats
- Essential formulas: SUM, AVERAGE, COUNT, IF, COUNTIF
- Absolute and relative cell references
- Conditional formatting rules for visual data highlights
- Sorting, filtering, and creating filter views
02
Day 2: Charts, Collaboration, and Sharing
- Building bar, line, pie, and combo charts
- Formatting and customizing chart appearance
- Sharing settings: viewer, commenter, and editor permissions
- Real-time collaboration and commenting
- Protected ranges and sheets for controlled editing
- Importing data from CSV and connecting to other sheets
- Printing, downloading as Excel/PDF, and version history
After This Level
- Build formatted spreadsheets with essential formulas and functions
- Create charts and apply conditional formatting for data visualization
- Collaborate in real-time with sharing, comments, and protection
- Import and export data across formats including Excel and CSV
Who Is This For
- Teams using Google Workspace
- Analysts and project managers in cloud-first organizations
- Anyone transitioning from Excel to Google Sheets
Prerequisites
Basic computer literacy.
Ready to master Google Sheets & Apps Script?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.
More in Automation & DevelopmentView all courses