Formulas & Functions
7 articles
Excel REGEX Functions: REGEXTEST, REGEXEXTRACT, REGEXREPLACE
Learn REGEX functions in Excel. Use REGEXTEST, REGEXEXTRACT, and REGEXREPLACE to match text patterns without VBA.
COUNTIF & COUNTIFS: Beginner to Pro
Learn COUNTIF and COUNTIFS in Excel. Count cells by single or multiple conditions with step-by-step examples.
Excel June 2026 Update: All New Features Explained
Microsoft added new features to Excel in June 2026. See what changed, from new functions to performance improvements.
GROUPBY Function in Excel: The End of Manual Pivot Tables?
Excel's new GROUPBY function creates reports with one formula. Learn how it works and when to use it.
How to Use INDEX-MATCH in Excel: Complete Guide
Learn INDEX and MATCH in Excel. Step-by-step guide to left lookups, two-way lookups, and advanced scenarios.
VLOOKUP vs XLOOKUP: Which One Should You Use in Excel?
Compare VLOOKUP and XLOOKUP in Excel. Learn key differences, limitations, and when to use each with real examples.
XLOOKUP Function in Excel: Complete Guide with Examples
Learn XLOOKUP in Excel with examples. Left lookups, error handling, multiple values, and advanced scenarios.