Excel GROUPBY: Create Summary Tables Without a PivotTable
Excel GROUPBY gives Microsoft 365 users a new way to summarize data without manually creating a PivotTable or building separate UNIQUE and…
Read article
Blog · Tag
Excel Tips
GROUPBY vs PIVOTBY in Excel: What’s the Difference?
GROUPBY vs PIVOTBY in Excel can be confusing because both functions summarize data, both can calculate totals, and both can create results…
Read article
Excel REGEXTEST: Check Whether Text Matches a Pattern
Need to check whether text follows a particular format without manually inspecting every cell? The Excel REGEXTEST function can look for patterns…
Read article
Excel REGEXREPLACE: Clean Messy Text With Pattern Matching
Messy data is one of the most common problems in Excel. Phone numbers arrive in different formats, product codes contain unwanted characters,…
Read article
Excel REGEXEXTRACT: Pull Numbers, Codes and Patterns From Text
The Excel REGEXEXTRACT function gives Microsoft 365 users a much more flexible way to pull information from messy text. Instead of building…
Read article
Python in Excel: What Can You Actually Do With =PY?
Python in Excel lets you write Python code directly inside an Excel workbook and return the results to your spreadsheet. Instead of…
Read article
Excel TEXTSPLIT: Split Text Without Text to Columns
Need to separate a full name, product code, or comma-separated list into multiple cells? The Excel TEXTSPLIT function can do it with…
Read article
Excel IMAGE Function: Put Pictures Inside Cells
Excel cells are normally filled with numbers, text, and formulas. But modern versions of Excel can also treat pictures much more like…
Read article
Excel Calculation Mode: Why Formulas Sometimes Don’t Update
Have you ever changed a number in Excel but noticed that the formula result stayed exactly the same? The problem may not…
Read article
Dynamic Arrays in Excel: What Does the #SPILL! Error Mean?
You enter a formula in Excel expecting a result, but instead you see #SPILL!. The Excel #SPILL! error is usually connected to…
Read article
Excel LAMBDA: Create Your Own Functions Without VBA
What if you could create your own Excel function without learning VBA or writing a macro? The Excel LAMBDA function lets you…
Read article
How to Use Flash Fill in Excel
Flash Fill in Excel helps you clean up or reshape data automatically when Excel recognizes a pattern. Microsoft says Flash Fill automatically…
Read article- 1
- 2