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 MSN

I made a dynamic Excel timeline in 10 minutes (and you can too)

Transforming a simple line chart into an adaptable timeline is easier than you think.

Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.