In this post, we’re going to see how we can very quickly format multiple Google Sheets with a little help from Apps Script. The idea of this post, came from the Department of Education in Hawaii, where they have about 300 schools and a guy who works there told me he had to format about… Continue reading Quickly format multiple Google Sheets with Apps Script
Category: Sheets Posts
Using Google Meet directly from Sheets Docs & Slides
In this post, we’re going to look at how we can quickly access Google Meet directly from Google Sheets, Docs, and Slides. From April 2022, Google added the ability to open a Meet directly from a Sheet, etc and where the Meet will then appear in the sidebar, allowing you to collaborate on the document… Continue reading Using Google Meet directly from Sheets Docs & Slides
Importing Amazon royalty data from Excel to Google Sheet
In this post we’re going to look at how we can get data from an Excel spreadsheet and import some of it into a Google Sheet. As an example, we’re going to upload an Excel which contains the current month’s royalty data from Amazon and add it to a central sheet which contains all the… Continue reading Importing Amazon royalty data from Excel to Google Sheet
How to automate Google Sheets tasks with Macros
Do you get fed up with doing the same monotonous tasks over and over again on your spreadsheets? Well, there’s one thing that may save you time – Macros. These record you doing actions on your sheets, then with a click of a button you can repeat those actions in seconds. Here, we’re going to… Continue reading How to automate Google Sheets tasks with Macros
Forms & Sheets – Attendance System
In this post we’re going to make an attendance system using Google Forms and Sheets. The user will fill in the attendance on the form (possibly on their mobile) and the data will then be stored and organised automatically per student. This will also use a Form add-on called FormRanger to easily populate a Google Form… Continue reading Forms & Sheets – Attendance System
Google Sheets – Grouping rows and columns
Grouping and ungrouping columns Sometimes we have large spreadsheets where we want to work with only certain rows or columns. Sheets gives the option to group rows or columns, allowing you with one click to show and hide numerous rows and columns, rather than having to go into the menus and hide the ones you… Continue reading Google Sheets – Grouping rows and columns
Google Sheets – Controlling Rows & Columns (Part 1)
In this post, let’s look at various ways you can modify the rows and columns on your sheet. Part 1 (this post) Changing the row size of rows and columns (to fit data / manually / enter size) Selecting a whole row or column Inserting and deleting a row or column Inserting and deleting specific cells… Continue reading Google Sheets – Controlling Rows & Columns (Part 1)
Google Sheets – Formatting your data
Once you’ve added your data onto a sheet, you’ll probably want to format it in some way. In this post, we’ll look at formatting data in Sheets. By default, numbers entered are considered just that, normal numbers, but sometimes you want specific types of numbers, e.g. percentages, currency, dates, times, scientific, numbers to certain decimal points.… Continue reading Google Sheets – Formatting your data
Google Sheets – Cell formatting
The fundamental building blocks of any spreadsheet are the cells. So clearly, it’s important to understand how to use them well. In this post, I will focus on the various ways you can format cells, so that the cells display the information you want, visually look professional and most importantly, will help you understand your… Continue reading Google Sheets – Cell formatting
Questionnaires – Automatically send feedback to individuals
It’s common to use questionnaires at the end of a course to get feedback on the course and teacher. When you have a lot of teachers, it can be hard work analysing that feedback and splitting into the different teachers. Here we’re going to look at how we can automatically send the individual feedback to… Continue reading Questionnaires – Automatically send feedback to individuals