Excel

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

A complete guide to using Excel Power Query in 2026 to clean, reshape, and combine data automatically — no formulas...

Advanced Excel conditional formatting techniques including color scales, data bars, icon sets, and formula-based rules to build visual dashboards.

Master Excel LAMBDA, MAP, and REDUCE to build reusable custom functions without writing a single line of VBA. With real-world...