Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

I have a work sheet, it has 10,000 rows.<BR><BR>2,000 of those are for the state of New York.<BR><BR>So I add a filter, then drop down on the state column and select New York.<BR><BR>I then have 2,000 ...