Excel Tutorials

There are a lot of steps to cleaning up a spreadsheet, especially if you’re working with raw data. A common need is to remove spaces at the end and the beginning of a cell in Excel. This is super easy to do using Excel’s TRIM function. How to Use the TRIM Function in Excel WATCH: […]

Depending on what you’re working on or the type of unit of measurement you feel comfortable with, you may need to change the measurement type in Excel. For example, change from centimeters to inches or vice versa. You can also choose millimeters. Changing the unit of measurement will affect the rulers and row/column size adjustments […]

A viewer recently asked me how he could apply multiple data validation to the same cells in Excel. He wanted to prevent duplicate entries AND limit the number of characters for those same entries. Because the Custom Data Validation feature allows only a single formula to be used, a nested formula would need to be […]

Autofill in Excel is a feature that automatically completes typing lists of items for you. This means less typing and more time savings! How Autofill Works in Excel Autofill works by looking for a pattern in your data to predict what you’ll type next. If Excel identifies what you’re typing as part of an Autofill […]

You’ve probably heard someone talk about a nested formula in Excel and wondered what on earth is a nested formula??? After all, there’s no nest button or nest function. Turns out, you’ve probably been using nested formulas all along! So, what exactly is a Nested Formula in Excel? Click to Watch: What is a Nested […]

A viewer reached out wanting to know how he can count how many cells are referenced in a formula in Excel. Was this even possible??? For example, say he has a formula like AVERAGE(A1,A2,A3) in cell A4. What formula could he use to let him know that 3 cells were referenced? I thought about this for a while and […]