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 (Twitter) for updates. Your journey to Workspace efficiency starts here!

Update

I’ve spent the last few weeks updating my books so they are bang up-to-date. They carry the 2024 edition label. I’m also working on a number of posts and videos showing the latest changes to Google Workspace.

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

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. 😎

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.

• How to search in Google SheetsApril 14, 2024
  In this post, we’re going to look at how we can search in Google Sheets for specific text, numbers, formulae, and links. Search in Google Sheets Here we have a list of customers and we want to find any called “pott”. Press Ctrl + F and the search box will appear. Type in the search… Continue reading How to search in Google Sheets
• How to sort in Google SheetsMarch 18, 2024
  In this post, we’re going to learn how to sort in Google Sheets. We’re going to see how we can sort data in one or more columns, and look at the different options that are available. How to sort data by one column Here we have a list of students’ exam results, which is a… Continue reading How to sort in Google Sheets
• How to randomize a list in Google SheetsMarch 18, 2024
  In this short post, we’re going to look at how to randomize a list of names. For example, a teacher may want to change the order of a group of students. First, select the cells you want to randomize. Then right-click on the range and then click View more cell actions > Randomise range. Alternatively,… Continue reading How to randomize a list in Google Sheets
• How to merge cells in Google SheetsMarch 17, 2024
  In this post, we’re going to look how to merge cells, which combine cells multiple cells into one cell. This allows you to format the cell and can simplify your data and make it easier to read and understand. It’s often used for headers in tables or where you have long text which goes across… Continue reading How to merge cells in Google Sheets

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 a column of figures.

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 2024? Learn spreadsheet functions and / or Google Apps Script! You won’t regret it! 😎

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