Excel Tutorials

You tried to make a slider with percentages in Excel, but it didn’t work! It’s NOT you, it’s Excel. The trouble with this is that the Form Control inputs only accept whole numbers. This means no decimals, percents, or negative numbers. To use percentages with your slider, you need to do a little extra formatting. […]

You want to create a macro or a form in Excel and all the instructions you find tell you to go to the Developer tab. Except, you can’t find it! Where is the Developer tab in Excel??? If you don’t see the Developer tab, don’t panic, it just means that you need to enable it. […]

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

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 cm to inches or vice versa. You can also choose millimeters. Changing the unit of measurement will affect what is displayed on rulers and […]

A viewer recently asked me how he could apply multiple data validation to the same cells in Excel 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 created. This […]