Excel Tutorials

Whether it’s the result of getting data from online or typing errors, there are many reasons why you may need to clean up extra spaces in Excel. These extra spaces can make your sheet look messy and keep you from correctly using some of Excel’s tools and features. 3 Ways to Remove Extra Spaces from […]

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 […]