Google Sheets Beginners: Paint Format (10)

Google Sheets: Paint Format

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.

Google Sheets Paint Format button

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.

Check out the video below:

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

 

Google Apps Script: Automated PDF Certificated Creator That Is Emailed to the Attendee (Updated Feb 2022)

Google Apps Script: DriveApp, PropertiesService, SpreadsheetApp, GmailApp, SlidesApp. Google Slides, Google Sheets.

Have you ever wondered how people create certificates en mass and send them out automatically? You are in the right place.

In this tutorial, we are going to:

  1. Create Certificates of Attendance for multiple attendees using Google Slides and a list of attendees in Google Sheets.
  2. 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.

Google Apps Script Menu Items in Google Slides

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):

Let’s get cracking.

Continue reading “Google Apps Script: Automated PDF Certificated Creator That Is Emailed to the Attendee (Updated Feb 2022)”

Google Sheets Beginners: Conditional Formatting (09)

Google Sheets: Conditional Formatting

Conditional formatting is a powerful tool that helps you to highlight cells that meet a certain value. You can format cells, that contains:

  • date ranges
  • Number ranges or specific numbers
  • Exact text or partial text

Once you have identified your condition you can change the cell’s background colour, font-weight or font colour.

You can access conditional formatting in Google Sheets by going to Format > Conditional formatting. Make sure you select the range you want to format first, though.

In this video tutorial we will cover the basics of Conditional Formatting in Google Sheet:

  1. What is conditional formatting and how to use it.
  2. Basics of conditional formatting.
  3. Example 1: Conditional Formatting Grade Ranges 0:23
  4. Example 2: Conditional Formatting empty cells or cell only containing values. 4:36
  5. Example 3: Conditional Formatting text that contains certain words or letters. 6:06

If you are keen to follow along here is a link to the Google Sheet I was working in:

Unformatted template to follow along with the video.

Simply, go to File > Make a copy to have your own copy of the file.

If you want to create custom conditions that are not in the list you really should check out this tutorial:

Google Sheets: Conditional Formatting with Custom Formula

If you want to check out more on my Google Sheets Beginners course you can check the playlist out here:

Google Sheets: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Create a Student Certificate of Attendance with Google Slides and Export it as a PDF or Print it

Google Slides – Beginners

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.

Continue reading “Create a Student Certificate of Attendance with Google Slides and Export it as a PDF or Print it”

Google Sheets Beginners: Borders (07 & 08)

In this next part of our Google Sheets Beginners Youtube course, we take a look at borders. Borders can provide a huge boost to the readability of both your digital Google Sheet and your printed spreadsheets. Not only that, but careful use of border styles, weight and colour can help guide your reader to the most important bits of information on your spreadsheet.

These tutorials are for the Google Sheet or even spreadsheet beginner. I’ve broken the border tutorial down into two parts:

Google Sheets Border Basics

In this tutorial, I’ll cover,

  1. How to add borders to a range specifying what part of the range the border will be.
  2. Adding colour to your borders.
  3. Adding border thickness or dashes and dotted borders.
  4. Troubleshooting a few issues you might face when creating multiple border types.

A Borders Style and Usage Guide

In this tutorial, I’ll cover,
1. Fast workflow for styling borders in a larger “real” project.
2. Using borders to attract the user to important pieces of information.
3. Show common mistakes to watch out for in workflow.

Can you think of any other great ideas for using borders in Google Sheets? I love to hear them. Feel free to add your thoughts in the comments below.

Keep an eye out for more Google Sheets basics tutorials. You can even subscribe! Top right!

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: