Understanding Data Validation

Data Validation helps you control your data entry options, making your work easier and your spreadsheet cleaner. There are a lot of options and ways to use the tool, so check out the video and see how you can start to implement them into your own files.

How to use Freeze Panes

Freeze Panes is a must when working with tables of data where you want to keep column headers visible. You can freeze column headers, row headers or both.

Using the Filter Tool

The Filter tool is really powerful for working with tables of data where you want to be able to quickly sort and filter data based on one condition or multiple conditions.

Using the Name Box

Few people ever use the Name Box, but it can save you a lot of time. You can assign names to single cells and ranges of cells, allowing you to refer to and navigate to those cells easily, even if they get moved around in a worksheet.

Copy, Paste and Fill Tips and Tricks

There are a lot of tricks for copying, pasting and filling that will save you time once you understand how they work. Especially if you’re working with large tables of data, you’ll find these tricks extra helpful.