How-To Geek on MSNOpinion

You need to know what the double unary operator (--) does in Excel

The double dash is crucial for complex array logic operations in your spreadsheet.
MUO on MSN

Excel's REDUCE is clever, but this old-school function is what I trust

Not every problem needs Excel’s newest trick.
TechRepublic

How to use UNIQUE() to populate a dropdown in Microsoft Excel

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.
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 ...