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.

Using the Quick Access Toolbar

Using and customizing the Quick Access Toolbar is a great way to keep your most-used tools handy in any file you’re working in. Check out the video to see more.