How-To Geek on MSN

You need to know the difference between a range and an array in Excel

Understand the correct terminology to understand how Excel works in the background.
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.