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.
Houston Chronicle

How to Compare Two Excel Spreadsheets & Highlight What Is Missing

If you have two similar Excel spreadsheets, or different versions of the same original spreadsheet, it can be useful to compare the Excel files and see how they differ. If the spreadsheets are short, ...

Excel Lookup Showdown, Use XLOOKUP for Fixed Lookups, VLOOKUP for Relative Columns

The XLOOKUP or VLOOKUP choice is tied to scenario, as most needs are fixed lookups, letting you save time with the simpler ...
Computerworld

How to use Excel as a data visualization tool

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more. Everyone knows Microsoft Excel as a ...