Google Sheets Shorts: Text Formatting (3)

Google Sheets: Text Formatting

If you a new to Google Sheets or spreadsheets in general, this short video is for you!

We’ll go formatting text in Google Sheet. Including:

  • Shorts cuts to access bold, italic, underline and strikethrough.
  • Changing the font type.
  • Changing the font colour.
  • Changing the size of the font.

Then I’ll wrap everything up with a quick example of some style best practice.

Did you enjoy the tutorial? Want 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: Create multiple versions of a document based on Google Sheet Data and a Google Doc Template (Mail Merge)

Google Apps Script: SpreasheetApp, DocumentApp, DriveApp; Google Sheets, Google Docs

If you have ever worked in LibreOffice or Microsoft Excel you will probably be familiar with the mail merge. Traditionally, mail merge is used to create multiple versions of a document and snail-mail them to someone.

These days, we don’t often use the snail mail approach, but it is a regular occurrence for us to need to produce multiple versions of reports based on a data set usually from a spreadsheet.

In this tutorial, we will create a document merger that will create new Google Documents based on a dataset from a Google Sheet using Google Apps Script.

If you want to quickly jump into your own project with our script, I’ll provide you with a quick-use guide.

Then, we will set up a template for our Google Doc and generate our Google Sheet data (don’t worry, I’ll share the document so you can follow along).

Finally, we will jump into the breakdown of the code for those legends who are learning how to create their own Google Apps Script.

Let’s get started:

Note: As always, take what you need and don’t worry about the rest. 

Continue reading “Google Apps Script: Create multiple versions of a document based on Google Sheet Data and a Google Doc Template (Mail Merge)”

Google Sheets Shorts: Align and Wrap Text (2)

Google Sheets: Align and Wrap Text

If you a new to Google Sheets or spreadsheets in general, this short video is for you!

We’ll go over aligning text in cells vertically and horizontally. Then we’ll show you how to wrap long pieces of text so that they fit neatly in the cell.

Lastly, we will wrap things up with an example of how you might want to use align and wrap in your own project.

Oh yeah, there is a groan worth Dad-pun at the end. So brace yourself.

Did you enjoy the tutorial? Want 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 Sheets Shorts: Sorting Data (1)

Google Sheets: sorting data. 

In this Google Sheet tutorial, we’ll go through the nuances of using sort. You’ll find out how to sort by the sheet tab and by a selected range. Then, we will show you how sort works with text numbers and a mix of the two before diving into how to sort by multiple columns.

If you are new to Google Sheets or spreadsheets in general. Skill up and get an advantage on your workmates and check out the video below.

If you want to learn more about Google Sheets hit the subscribe button in the video or on this site (top right!).

Did you enjoy the tutorial? Want 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 Sheets Shorts: Change the Column and Row Size (0)

Google Sheets: Columns and Rows

If you are new to Google Sheets or spreadsheets in general. This is the post for you.

In this tutorial, we walk through 3 ways to change the size of Columns and Rows. We also throw in some tips on change rows and columns in bulk to increase your workflow, before addressing some pitfalls you might face.

Here is a link to the Sheet containing the character matrix.

Resizing Columns and Rows

Did you enjoy the tutorial? Want 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