Welcome to Learn Google Workspace and Apps Script!
Here you will find a comprehensive resource hub for mastering Google Workspace and Google Apps Script! Whether you’re new to Google Workspace or intrigued by Apps Script’s automation potential, you’re in the right place.
Explore tutorials on Google Drive, Docs, Forms, Meet, Sheets, Slides, Sites and Apps Script. From basics to advanced topics, the pages cater to all levels.
Discover user-friendly Apps Script to automate Google Apps, with real-world use cases. Follow me on X (Twitter) for updates. Your journey to Workspace efficiency starts here!
Site search
Update
I’ve recently published a free Google Sheets course on YouTube. It takes you step-by-step through all the main areas of Sheets so you can use it with confidence. Check it out here!
Over a million people have visited this site!! 😊 I’m chuffed to bits to have helped so many people! Thanks for visiting! 😀
Learn how to use spreadsheets!
Reflection – One of the things that set me off on my Google Workspace journey was learning spreadsheet functions. Initially, I did it in Excel then I discovered Google Sheets, and like they say I never looked back! If you’re new to them, they are things like =SUM(A1:A100), which would add figures in column A.
I’m always surprised that even though so many people use spreadsheets every day in their work that they only know the basics, and learning things like functions would make their lives so much easier.
It was certainly also the springboard for making a number massive improvements in my department and then it led to me learning Google Apps Script, which is the easy-to-learn code that sits behind the Workspace apps. That basically changed everything and over the years I’ve been amazed what you can do with it.
So, my advice for this year? Learn spreadsheet functions and / or Google Apps Script! You won’t regret it! 😎
Newsletter Sign up
If you’re interested in receiving regular news and posts on Google Workspace and Apps Script, sign up to my newsletter below.
Form not shown if you’ve already signed up. I 100% respect your data privacy and you will only receive news and posts related to Google Workspace and Apps Script and of course you can cancel at any time.
Latest Posts
- Enhance your Google Sheets: Cell FormattingCell formatting in Google Sheets is a simple but powerful way to make your data more readable and visually appealing. By customizing how your information looks, you can make patterns and insights stand out. Let’s dive into some key formatting techniques! For a detailed, step-by-step guide on how to apply these formatting techniques, check out… Continue reading Enhance your Google Sheets: Cell Formatting
- Google Sheets – The BasicsMastering the basics of Google Sheets Google Sheets is an incredibly powerful tool, capable of much more than just data entry. You can perform complex calculations, send emails, draw pictures, and even play games! However, before jumping into advanced functions, it’s important to start with the basics. Check out this video which covers all the… Continue reading Google Sheets – The Basics
- How to quickly group data in SheetsDo you ever find yourself staring at a spreadsheet full of information, wishing there was an easier way to organize it? Well, fret no more! Google Sheets has a powerful tool called the Group By View that can help you quickly categorize and analyze your data in seconds. This post will walk you through the… Continue reading How to quickly group data in Sheets
- How to send automatic notifications from SheetsStop the Status Update Emails! Automate Notifications with Google Sheets. Tired of your team emailing you every time they complete a task? There’s a better way! Google Sheets can now send you automatic email notifications when data is changed, saving you and your team time. Learn how to set up this handy feature in this… Continue reading How to send automatic notifications from Sheets
Latest Book!
I’m pleased to announce my latest book: Google Sheets Functions 2! If you’re ready to take your spreadsheet expertise to new heights, this is your ultimate guide.
Stay ahead of the game with the latest functions, including XLOOKUP, BYROW, and LAMBDA, introduced to Sheets in 2022. Each chapter centres around one or two functions, demonstrating their seamless integration with others. In fact, you’ll encounter more than 50 functions throughout the examples.
But that’s not all! To enhance your learning experience, I’ve included all the files and examples from the book, absolutely FREE. No need to wait—immediately put your newfound knowledge into practice.
If you’re ready to take your spreadsheet expertise to new heights, this is your ultimate guide. 😎
Google Workspace and Apps Script Books
My intention is to keep this site ad-free, so you can find the information you want easily and without distracting ads. If you would like to support this site, then you can find book links at the end of every post. Just click on a book to open the page on Amazon. I update the books periodically to reflect the latest changes to Google Workspace and Apps Script. They are all available on Amazon HERE.
Your help is very much appreciated. I hope you find this site useful – please share it. Thank you! – Baz