News
How-To Geek on MSN4d
How to Use the GETPIVOTDATA Function in Microsoft Excel
The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...
The MID and MIDB functions in Excel return a specific number of characters from a text string starting at the position you specify.
There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.
How-To Geek on MSN9d
EOMONTH Function: How to Calculate Any Month-End Date Easily
The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...
When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.
This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback