DATA - Google Sheets 101 - Basics

Here we'll talk about the very basics of Google Sheets, including how to access it, create new sheets, find sheets you've created, and navigate the interface.

This video goes over what to expect from this section and gives a quick overview of each topic.

This video covers simple tables, headers, data values, and Summary vs. Data table types.

In this video, we cover useful menu/keyboard commands for keeping data organized and your workflow moving forward smoothly.

This video will cover working directly with rows & columns, including adding, deleting, moving, sizing, and merging.

In this video, we'll spend time making your data easier to read by modifying colors and patterns.

In this video, I'll show you how borders & alignment can help keep your sheets readable even as you fill them with more data, and the near-magical thing called "white space."

In this video, we'll talk about data format, why it matters, and how the various formats differ.

This video will add more information about data formats and why they matter when using formulas, including how to force certain formats when cells don't want to cooperate.

Here we'll talk about math (feel free to panic before continuing), the order of operations, and how that impacts your formulas.

In this video, we're going to cover the five most useful beginner formulas: SUM, COUNT, AVERAGE, MAX, & MIN.

This video will go through breaking data into smaller chunks by separating long values in one cell out into multiple columns.

Here we'll talk about the exact OPPOSITE of the previous lesson: combining data from multiple columns into a single cell value using both mathematical and text concatenation techniques.

In this video, we'll look at how to handle duplicate data entries using Google Sheets' built-in functions.

In the last video for this section, we'll review useful white space, compare it to extraneous value space, and talk about how to trim things down using Google Sheets' built-in functions.

This video will cover freezing the sheet view at various spots to enhance ease of use.

Here we'll talk about keeping data clean using the various sorting methods, as well as making your data more useful by filtering.

The last video in this section will look at creating and using three basic (but useful) chart types: Line, Column, & Pie.