How-To Geek on MSN

The simple Excel function that decides if your formula spills or returns one value

For decades, Excel worked on a simple principle: you enter a formula into one cell, and it returns a single result into that ...
SlashGear

What Is The Lookup Function In Excel & How Do You Use It?

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...
Hosted on MSN

How to Use the VALUE Function in Microsoft Excel

Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...
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 ...
Geeky Gadgets

How to use Excel GROUPBY and PIVOTBY Functions to simplify data analysis

Tired of struggling with pivot tables every time you need to summarize your data in Excel? You’re in luck! Excel’s new GROUPBY and PIVOTBY functions are here to make your life easier. These powerful ...