This video is on the longer side, but it will give you a comprehensive run down of how to format cells and cell data within your spreadsheet. You'll learn how to:

• Stylize text and adjust font

• Apply colors

• Align and wrap text

• Quickly apply formatting from one cell to another

• Insert checkboxes

• Format numbers and dates

• Merge cells

• Apply cell borders

In this video you'll learn options for adding and deleting rows and columns as well as how to move and adjust data within your spreadsheet.

You can perform bulk actions within your sheet such as duplicating a tab, renaming it, and applying a color. You'll also learn some other options that are available for tabs within your Google Sheet.

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. Conditional formatting is useful for highlighting cell data and helps aid visual analysis of your data. In this video you will see how to apply conditional formatting to text and numbers as well as get a glimpse of an advanced skill (formatting with a custom formula). Finally, at the end of the video, I'll show you a couple of ideas for creating self-grading assignments in Sheets using conditional formatting features.

Learn how to quickly split text into columns, remove duplicate entries, and trim whitespace from cells. You'll also see how Sheets can find and replace data automatically. These skills are essential for creating consistency within a data set which is especially important if you plan to use formulas or charts.