Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

Learn how to perform Excel multiple column lookups with ease using XLOOKUP, FILTER, SUMPRODUCT, and Boolean logic techniques.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

In this post we show you how to create a Bar Graph or Column Chart in Excel. Bar graphs could be both 2-D or 3-D depending on the editor you use.