Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)

Google Sheets

As we increasingly start to work from home and work with clients globally, it is vital that we prepare our Google Sheet for the country that our users and clients are from.

In this tutorial, we will cover how to quickly change your current Google Sheet’s timezone, date and currency for the entire document.

In this tutorial, I’ll cover,

Continue reading “Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)”

Google Sheets Beginners – Spell Check(15)

Google Sheets

Did you know that you can use spell check in Google Sheets?

No? Not many people do.

Cleaning up your spelling in your Google Sheets can really give your work an edge and save you from any embarrassing moments when you using your data to present.

While Google Sheets spreadsheets is quite primitive it can certainly help you fix the odd spelling fluff here and there.

In this tutorial we will cover:

  1. Using spellcheck on a single cell or sheet.
  2. Ignoring selected mistakes.
  3. Adding special words to your personal dictionary.
  4. Some of the limitations of Spellcheck in Google Sheets

If you up for learning more about Google Sheets basics to make your life easier at work check our the playlist:

Google Sheets Basics playlist

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 Sheets Beginners – Creating Sheet Tabs (14)

Google Sheets

Sometimes just one Google Sheets tab is not enough. Maybe you want to tidy up your data, create unique insights in a separate tab or generate a spectacular graphic dashboard or all your daw data, knowing how to create a Google Sheets tab is going to be a vital part of your success as a Google Sheets creator.

In this tutorial we’ll cover:

  1. The different ways you can add a new blank sheet tab.
  2. Duplicating a current sheet tab.
  3. Renaming your sheet tab.
  4. Accessing a large number of sheet tabs.
  5. Hiding and unhiding your sheet tab.

Remember!

Don’t forget to let your team know that you are using tabs. They always forget 🤣.

If you want to learn some more Google Sheets basics skills check out the link to the playlist below:

Google  Sheets Basics playlist

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 Sheets Beginners – Hide and unhide columns and rows(13)

Google Sheets

Sometimes it is helpful to hide and unhide columns in Google Sheets. You may have some completed tasks that you want to indicate as completed to your users or you may want to hide columns that you have used for working. Whatever, the case hiding rows in columns is a helpful trick to have in your Google Sheets toolbox.

In this video tutorial we  will cover:

  1. Why you might want to hide columns and rows in Google Sheets.
  2. Hiding and unhiding individual columns and rows.
  3. Hiding and unhiding ranges of columns and rows.
  4. Hiding and unhiding selected columns or rows.

Check it out now!

If you want to grab more Google Sheets basics, you click in the link below to the playlist:

Google Sheets Beginners playlist

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 Sheets Beginners: Insert Columns and Rows (12)

Google Sheets: Insert and Shift Columns and Row

Even if you are a veteran Google Sheets users you might find a great little tip in this tutorial.

Here we will cover how to insert columns and rows in Google Sheets spreadsheets. Oh, and how to cheat at connect 4.

In this tutorial, I’ll cover,

  1. Inserting columns and sheets from the menu bar.
  2. Insert columns and sheets by right-clicking cells and row and columns references.
  3. Inserting multiple columns and rows at one time.
  4. Shifting a cell set up, down left and right by one or many cells.

 

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