How-To Geek on MSN

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

Above all else, knowing the difference between a range and an array is the key to understanding how Excel processes data, giving you better insight into modern dynamic functions. An Excel range is a ...
How-To Geek on MSNOpinion

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

It's marginally more efficient: While the difference is negligible, the double-unary operator can be more efficient in ...