Learn how to create a Heatmap in Microsoft Excel. Use Color Scales and custom rules to show heatmap in an Excel spreadsheet.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Create a drop-down list by selecting a range of cells The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.