How-To Geek on MSN

How to Use the DROP Function in Microsoft Excel

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...
HowToGeek on MSN

How to Use the AVERAGEIF and AVERAGEIFS Functions in Excel

Excel's AVERAGEIF and AVERAGEIF functions let you find the average of a set of data. However, where they differ from the more ...
TechRepublic

How to use VBA’s InputBox function to select a range on the fly in Excel

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.
TechRepublic

How to use the FILTER() dynamic array function in Excel

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...