Intermediate Google Crash Course

Career Skills and CPD

Certificate

Learn in-depth Google Sheets functions, work with Google Form data, and get a light intro to Apps Script. Perfect for Excel users wanting to explore Google Sheets.

Yes

Familiar with basic spreadsheet usage (Excel or Google Sheets)

U Phone Myat Than Oo
Bachelor of Computer Science (Hons)
Applied Data Science Lab (World Quant University, U.S.A)
Google Data Analytics Professional Certificate (v2)
Google IT Automation with Python
Head of Business Operations & Instructor (Matrix College)
Data Consultant (MPG)

Campus and Online

18 hours

Matrix Curriculum

Intermediate

By the end of this course, participants will have achieved the following learning outcomes:
- Use a wide range of Google Sheets formulas
- Clean and structure data for business usage
- Process and organize data from Google Forms
- Build a functional digital system for managing all types of business records
- Master Sheets functions, apply logical and lookup operations, automate simple tasks, and structure business data in a scalable format.

Not Available

75%

This course teaches intermediate-level Google Sheets functions, data cleaning, business data structure, and an intro to automation. It's ideal for those switching from Excel and those preparing to build business pipelines using Google Sheets.

- Comparing Excel and Google Sheets
- Google Form data processing
- Intermediate formulas: SUM(), IF(), QUERY(), etc.
- Advanced logic: IFS(), ARRAYFORMULA(), FILTER()
- Date and time functions
- Lookup formulas (VLOOKUP(), XLOOKUP(), INDEX()+MATCH())
- Regular expressions and text functions- Intro to Apps Script
- Supermarket business case study: inventory, sales, and reporting system

Anyone who want to learn effeiciently via Google Platform