Have you ever wanted to lock those pesky rows of headers or columns so that when you scroll the titles are still there? In Google Sheets, this is done easily.
You can either got to View > Freeze and select your preferred depth of freeze. Or you can do my favourite approach, click and drag that thick line just above and to the left of cell A1 and drag it to your preferred location.
Easy as that.
Check out the video tutorial below for more tricks on using Freeze in Google Sheets. It will cover:
What Freeze does in a Google Sheets spreadsheet.
How to freeze single or multiple columns and rows by using the menu bar.
How to freeze using right-click on columns and cells.
Want to know a quick way to update a cell or range with an already existing format in your Google Sheets? Paint Format is here to the rescue.
This versatile tool will help you to quickly replicate font, alignment, border, rotation and other styling formats in your Google Sheet.
In this tutorial, I’ll cover,
1. What the Paint Format button is and what it does.
2. Formatting one cell to another.
3. What things Paint Format will format across.
4. Using the formatting from one cell to update many cells.
5. Formatting from multiple cells to multiple cells
6. What Paint Format won’t copy across.
Send those certificates as an attached PDF to the attendees.
We’ll set it up so it is super user-friendly with a handy menu in your Google Slide template so that all you have to do is to update your Google Sheet of names each time you run the course and then click a few buttons.
Also, we will run an example so you can see how it all works and what you need to do to set it up.
For the coders out there, I think I have documented the Google Apps Script code enough for you to figure out how to quickly implement your own project. However, I have also added a smalls discussion of some parts of the code at the end.
This is a standalone tutorial. However, it draws from two main tutorials if you want to explore those first (Though it is not essential):
I always enjoy finding new ways to create documents using the Google Suite. One project I have recently worked on has been to build a Certificate of Attendance template that I can update for non-grades courses or conferences.
Why do this using a GSuite package?
Well, 1, if you haven’t noticed, I’m kinda into Google stuff and, 2, I can automate quickly using Google Apps Script and a list of students in Google Sheets so that I can produce all my student’s certificates all at once and automatically convert them to PDF.
If you are new to Google Slides, no problem. We will keep this basic. If you are a pro, skim through for some hot tips and stay tuned for a more technical follow up.