Filters organize and prepare data for Excel reports and visualizations by selecting only relevant data for display. If you are working with a filter in an Excel worksheet, you can extend the range of ...

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, format, and ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

VLOOKUP, or Vertical Lookup, is a powerful function in Excel that allows you to search for specific data in a column and return a value from a different column in the same row. Here’s a concise guide ...

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 set up.