As a follow-on from last week’s post about the new ApproximateDistinctCount function in DAX, I want to share something I found out from my recent testing for this function: ApproximateDistinctCount is ...

Have you ever been using Excel and thought, "I want to get a total, but which function should I use?" "I want to count only ...

In spreadsheet work, it's a common scenario in workplaces for people in their 40s to think, "I know what I want to do, but I don't know the function name."If you explain the situation to AI in your ...

As you’ve probably seen in the blog post for the September 2026 release of Power BI, Import mode and Direct Lake mode semantic models now support the ApproximateDistinctCount() DAX function. I tested ...

Build formulas that remember what came before.

Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays.

Excel tables let you create consistent formulas, build smarter filters, create expanding drop-downs, and keep charts and totals up to date.

Learn to calculate loan payments and design effective repayment schedules using Excel formulas for mortgages and other loan types.

If you run paid media, you already know the feeling. Google Ads says you drove 400 conversions last month. Meta claims another 250. Microsoft adds 60 more. Add them up, and you’ve apparently sold to ...

When it comes to analyzing data in Excel, few functions are as powerful and versatile as COUNTIF. Whether you’re sifting through vast datasets or just managing your personal budget, this function can ...

If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into a spreadsheet. The update introduces ...

Tony Phillips is an experienced Microsoft Office user with a dual-honors degree in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he worked as a document ...