Excel

A practical side-by-side comparison of XLOOKUP and VLOOKUP with real examples showing why XLOOKUP is faster, more flexible, and less...

Covers Flash Fill, Conditional Formatting tricks, Power Query basics, Name Manager, and other underused Excel gems most users never discover.

A practical side-by-side comparison of XLOOKUP and VLOOKUP with real examples showing why XLOOKUP is faster, more flexible, and less...

In this article, we will demonstrate how to reduce Excel file size by deleting blank rows. Often a file in...

Covers Flash Fill, Conditional Formatting tricks, Power Query basics, Name Manager, and other underused Excel gems most users never discover.

Complete guide to using Copilot in the Excel sidebar to analyze data, generate charts, write formulas, and add calculated columns...

Complete guide to using =PY() in Excel cells — running pandas, NumPy, Matplotlib, and scikit-learn directly inside Microsoft 365. Covers...

Practical guide to the new GROUPBY and PIVOTBY dynamic array functions — syntax, real examples, filtering, sorting, combining with other...

Comprehensive tutorial on Excel's LAMBDA function and its array companions MAP, REDUCE, SCAN, BYROW, and BYCOL — with real-world examples...

Complete guide to Excel's three powerful new text manipulation functions — TEXTSPLIT, TEXTBEFORE, and TEXTAFTER — with real-world examples for...