How to Use the FILTER Function in Microsoft Excel
To use the FILTER function, simply enter the array and range for your criteria. To avoid an Excel error for…
How to Use the Scenario Manager in Microsoft Excel
If you’ve ever had to decide between two or more financial situations, you may have done some spreadsheet manipulation. You…
How to Extract a Substring in Microsoft Excel
If you want to extract a substring from the left, right, or middle of your text, you can use Microsoft…
How to Calculate Average in Microsoft Excel
The average for numerical values is calculated by adding all the numbers and dividing the sum of those numbers by…
How to AutoFill Dates in Microsoft Excel
You don’t have to manually type the sequential dates if you want to fill the cells in your spreadsheet. Microsoft…
How to Count Colored Cells in Microsoft Excel
Using color in Microsoft Excel can be a terrific way to make data stand out. So, if a time comes…
How to Change Formats in Microsoft Excel
There are several settings available here in the Format cell, including your location and the type of calendar you prefer.…
How to Compare Two Lists in Microsoft Excel
A quick way to compare two lists in your spreadsheet is to use Excel’s unique highlight feature. This feature highlights…