Excel Tutorials

Did you know you can use Find & Replace to remove wildcard characters in Excel? You can use it to delete question marks, asterisks, or tildes – so long as you know the “special trick.” The Scenario You received a spreadsheet in which someone used asterisks to flag certain items. You, however, need to remove […]

Did you know that you can change the color of gridlines in Excel? While the default gray gridlines work well for most purposes, changing their color can make your worksheets easier to read, organize, and navigate. In this tutorial, you’ll learn two simple methods for changing gridline colors. Method 1: Change the Default Gridline Color […]

If you need to use Excel to pick a random item from a list (say a winner for a contest), shuffle data so it’s in a random order, or any other project where you need to randomize a list, this tutorial is for you! Reasons you may want to randomize a list in Excel Needing […]

The Hide feature in Excel is an easy way to hide and unhide rows and columns of data that you don’t want to display on your sheet. This can help you focus only on what you need at any given moment. But hiding can also make you forget something is there – i.e., “out of […]

If you use Microsoft 365 or Excel 2021, the RANDARRAY function just made generating random data sets in Excel a whole lot easier! Let’s take a look at this function. What is the RANDARRAY function? RANDARRAY is a dynamic array function that combines the features of the RAND and RANDBETWEEN functions, then adds even more […]

I recently got a few questions about how to access new features and beta tests in Excel. These followed the tutorial I did about an Excel beta that can help you keep leading zeros from disappearing. Let’s go over what steps you can take to help you get access to Excel’s new features, functions, and […]