Pick the Right Excel Lookup, XLOOKUP or FILTER for Your Data & Stop Wasting Time

Learn when FILTER beats XLOOKUP, when it does not, and how to handle multiple matches, nth items, and multi-condition lookups with clear steps.

Excel HYPERLINK Secret Turns Messy Workbooks into Sleek Dashboards

Learn practical HYPERLINK tips, from dynamic sheet links and navigation buttons to XLOOKUP row jumps and tidy anchor text for client reports.
MrExcel on MSN

Excel Trick: Create Sorted Summary Reports With Totals — No Pivot

Learn how to create sorted summary reports with totals in Excel without using pivot tables. Perfect for clean, efficient ...
MUO on MSN

Learning REDUCE in Excel completely changed how I use spreadsheets

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a programming language. Instead of scattering your intermediate calculations ...

Chrome's New 'Split View' Is Now My Favorite Way to Use the Internet

If you're running the latest version of Chrome and still don't see Split View, you can either wait for the feature to reach ...