Learn Google Workspace & 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, BlueSky, Medium, or Instagram for updates. Your journey to Workspace efficiency starts here!

Over a million people have visited this site!! 😊 I’m chuffed to bits to have helped so many people! Thanks for visiting! 😀

Do you want to know about the latest features in Google Workspace? And / or want to receive my latest posts and videos straight to your inbox? Sign up to my free fortnightly newsletter below and get a list of 50 lesser-known yet highly useful features in Google Workspace.

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.

NEW BOOK!!

Do you use Google Sheets but would like to learn how to use it better but don’t have the time? This is the book for you!!

In just about an hour, you’ll learn everything you need to confidently start using one of the most versatile tools for organising and analysing data.

Written with simplicity and clarity in mind, each chapter guides you step-by-step through essential features, building your skills and confidence as you go.

This takes you from the very basics like formatting your data and freezing rows to advanced areas like using pivot tables, creating drop-down menus, creating filter views, and the new Sheets Tables.

I wrote this book especially for those short on time but who still want to learn all the essential features to use Sheets with confidence.

Reflection – One of the things that set me off on my Google Workspace journey was learning spreadsheet functions. 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 spreadsheets, spreadsheet functions and / or Google Apps Script! You won’t regret it! 😎

• Create charts in Google Sheets with easeJanuary 9, 2025
  A chart truly is worth a thousand numbers! In this post, we’ll explore how to create and customise charts in Google Sheets to transform raw data into compelling visuals. How to create a chart in Google Sheets To create a chart, start by selecting the data you want to visualise, then click the Insert Chart… Continue reading Create charts in Google Sheets with ease
• Chart your data with Sparklines in Google SheetsJanuary 6, 2025
  Charts can simplify complex data, allowing us to quickly identify trends and make informed decisions. Sparklines in Google Sheets are a powerful tool for visualising data within cells. These mini-graphs are easy to create and customise, making them perfect for dashboards or reports. Let’s explore how to use sparklines effectively. How to insert sparklines to… Continue reading Chart your data with Sparklines in Google Sheets
• Google Workspace 2024 Recap (Pt 2)January 3, 2025
  In this second part of the 2024 Google Workspace recap, (Part 1 here) we delve into exciting updates to tools like Google Forms, Docs, Slides, and the innovative Google Vids and Notebook LM platforms. From enhanced organisation features to AI-driven content creation and improved presentation tools, these updates empower users to collaborate, communicate, and create… Continue reading Google Workspace 2024 Recap (Pt 2)
• Google Workspace – 2024 Recap (Pt 1)December 29, 2024
  In 2024, Google Workspace unveiled a host of updates across its suite of apps, aimed at enhancing productivity, collaboration, and user experience. This post summarises the key improvements to Google Chat, Drive, Sheets, and Meet. Google Chat Huddles for Quick Calls Chat introduced “huddles,” a feature powered by Google Meet that allows users to initiate… Continue reading Google Workspace – 2024 Recap (Pt 1)

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