The BEST Google Sheets Course For Home & Business

In this introduction, we'll begin with a brand new Google account, showing you how to get started with Google Sheets even if you've never used it before. If you're just getting started with Sheets, this is for you!

A thorough, but brief walkthrough of the menus and where to look for various tools within Sheets.

A quick tip on keeping your Google Sheets organized so that you can keep track of and find everything you work on. If you're as absent-minded as I am, you'll love this lesson!

Get to know the lay of the Google Sheets land...understand the basics of how the program is laid out.

We'll focus on how to format text within a cell -- bold, italics, strikethrough, colors, and more.

We'll learn three different ways to format text that stretches beyond the edge of the cell.

We'll go over how to fix a misteak (ha!). It's easy!

This is a fun one...find out multiple ways to change the size and shape of cells, rows and columns so they fit your data or fit a specified pixel size. (And what "pixel size" means!)

Learn how to change 2 or more cells into 1 and WHY you would want to do so.

Every Google Sheets user's SECRET WEAPON for cutting down on time by "borrowing" the formatting from an already-formatted cell and pasting it into another cell without changing the data already there.

Gain greater control over your cell design by implementing different types, colors and size borders.

Don't like white? Make it blue! Red! Purple! And more!

Learn this powerful trick to applying some color pre-formatting to a data set with a single click!

Let's learn how to ALWAYS keep your header row/s or column/s on screen while you scroll through the sheet so you always know what you're looking at!

The power of Google Sheets rests in its ability to work with numbers and formulas...this is your basic intro to using them in the program.

And here's how to start applying formulas to manipulate how different numbers relate to each other. (Don't worry...we'll start super simple!)

Let's learn how to move numbers and data around with a single click so you can better organize your info.

Here we'll find out how to filter your data so you only see what's important to you (without losing that data from the sheet!)

Also known as the "Fill Handle," this is one of the COOLEST shortcut tools of the entire program...find out how one little blue dot is going to cut down your work time exponential and make things a whole lot easier!

This sneaky little Easter Egg gives you the ability to perform some powerful calculations by simply selecting a series of cells.

Gain power over your sheet by creating rules that validate information that you or other users try to enter...and reject that information if the data doesn't agree with the rules you've created.

You know those convenient dropdown lists you see on website forms? We're going to learn 2 different ways to create and use them in your Google Sheets!

One of the best features of the program...change cell formatting (colors, text options, etc.) based on rules you create! 

After you hit "Copy" (cntrl or Apple + "C"),  Sheets gives you the power to paste your data back in multiple ways. Learn about these various options.

Here are 2 methods of inserting images into your Sheets, including the advantages and drawbacks of each.

When creating formulas, you're not just limted to the tab in which you're working. Learn the secret to using formulas that span multiple tabs.

Another essential function in Google Sheets, learn how to use the Count and CountA functions, as well as in which situations to use each one.

Learn how to perform rounding functions in Google Sheets.

We've learned how to SUM and COUNT, but what if you could add a stipulation so Sheets only sums and counts the numbers you specify?

The first in a series of lessons that teaches you how to move text in and out of columns based on certain stipulations. This one in particular allows you to take a string of text, like a first/middle/last name and split it into multiple columns.

Just as in the last lesson we split text into multiple columns, now we're going to learn how to take text from multiple columns and move it into one. There are several ways to do this, and this is arguably the most widely used.

This lesson expands on the Concatenate function, presenting various alternatives and their applications.

Quantum leap your data calculations with this powerful formula. It's the equivalent of finding a librarian to search through your data and retrieve precisely what it is you ask for.

Graphs and charts are essential to creating visualizations for your data, allowing you to visually display trends, changes, and other ups and downs throughout your sheets. Trust me, your clients and bosses can't wait to see these vibrant visuals.

Just a taste of one of the most wizardrous features of Sheets. Learn how to shortcut hours of building formulas and calculations; Pivot Tables make it easy and fast.