How-To Geek on MSN

The 3 best logical functions I always use in Excel

Make Excel evaluate your data for you.
How-To Geek on MSN

How to use the REDUCE function in Microsoft Excel

Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...
TechRepublic

3 ways to reconcile transactions using Excel 2016

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...
TechRepublic

How to use Microsoft Excel’s VSTACK() function to combine multiple data sets

How to use Microsoft Excel’s VSTACK() function to combine multiple data sets Your email has been sent Have you ever received data that you had to consolidate manually? It’s tedious work and prone to ...