Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter ...

Let’s work through a quick example using Excel 2003: This method has three benefits: You won’t have to re-create the list if the first item changes. A short header reduces the number of ...