Sheets Macros & Apps Script by Rajiv (Ex-Google, Novartis)

Automate Your Spreadsheets & Boost Productivity

What you'll learn
- Write powerful SQL queries in BigQuery to select, filter, aggregate, join, and analyze large datasets with ease.
- Master advanced BigQuery SQL concepts including subqueries, window functions, arrays, structs, and nested data types.
- Handle real-world data scenarios such as modifying schemas, transforming strings and dates, and working with NULLs and missing values.
- Optimize BigQuery performance using techniques like partitioning, clustering, execution planning, and automation.
- Apply Google-scale best practices and insider tips for writing efficient, clean, and production-ready SQL — taught by a Googler.

Requirements
- No prior SQL or BigQuery experience is required — this course is beginner-friendly and starts from the ground up.
- A Google account to access BigQuery via Google Cloud (free tier is sufficient for practice).
- Basic computer skills and comfort using web-based tools like Google Sheets or Google Drive.
- Curiosity and willingness to learn — that’s the only real must-have!

Description
Welcome toGoogle Sheets Macros & Apps Script – Taught by a Googler, your one-stop course toautomate tasks, build powerful tools, and take your spreadsheets to the next level!

In this hands-on course, you'll learn how to:

Record Macrosto automate repetitive actions.

Write custom functions and workflows using Google Apps Script (JavaScript for Google Workspace).

Buildreal-world automationslike approval workflows, data processors, custom menus, and more — the same way it’s done inside Google. You'll gain practical skills tostreamline operations and boost efficiency across your projects.Plus, discover how todebug your scripts effectivelyandimplement best practices for scalable, maintainable code.

Whether you're a spreadsheet power user, a business analyst, or a non-coder looking to unlock the true potential of Google Sheets, this course will teach you how tothink like a Googler and work smarter, not harder.

No prior coding experience? No problem. You’ll go from zero to script-savvy withclear, practical examples and guided walkthroughs. By the end of this course, you'll be building automations that impress your team and save hours every week.Empower yourself to transform tedious manual work into intelligent, automated solutions.Let’s get started!

Thank you for taking this course, I wish you all the best

Who this course is for:
- Beginners who want to learn SQL using BigQuery — no prior experience needed!
- Aspiring data analysts, engineers, or data scientists looking to build strong foundations in cloud-based SQL.
- Working professionals who want to upgrade their SQL skills and understand how things work at Google-scale.
- Students and graduates preparing for tech careers, internships, or certifications in data-related fields.
- Product managers, business analysts, and PMMs who want to query large datasets and make data-driven decisions confidently.
More Info