Are you still opening the Power Query editor every time you need to change a filter? Maybe you need to see sales for "Chicago" instead of "New York," or you need to swap between "Product A" and "Product B." Going into the M-code or the filter settings just to change one word is a waste of time. What if you could control your data from your spreadsheet like a remote control? The Power of Dynamic Filtering In my latest video, I show you how to link a single Excel cell directly

Are you tired of staring at endless rows of data, trying to find insights, trends, or the "story" hidden within your spreadsheets? Do Pivot Tables and complex formulas give you a headache? Good news, Office Newbs! There's a game-changing feature built right into Microsoft Excel that uses Artificial Intelligence (AI)  to do the heavy lifting for you. It's called "Analyze Data,"  and it's like having a super-smart data analyst working for you, 24/7, inside Excel. Meet Your New

For years, helper columns have been the go-to solution in Excel. Need to clean text? Add a helper. Match keywords? Another helper. Determine a category? One more column. Before you know it, a simple spreadsheet turns into a maze. Modern Excel gives us a better option. The problem with helper columns Helper columns aren’t wrong , but they come with trade-offs: They clutter your worksheet They make spreadsheets harder to maintain They increase the chance of errors They often ex

If you’ve ever seen two dashes (--) inside an Excel formula and thought “What is that doing?”  — you’re not alone. The double dash, also called the double unary operator , is one of those small Excel tricks that looks strange at first but solves very real problems once you understand it. Excel doesn’t always treat values the way you expect. For example: Logical tests return TRUE or FALSE Functions like TEXTAFTER and TEXTSPLIT return text Functions like SUM don’t automatically

If you’ve been using Excel for a while, you’ve probably leaned on VLOOKUP  to pull information from a list or table. And while it’s been around forever, VLOOKUP also comes with a handful of limitations that make your spreadsheets more fragile than they need to be. Enter XLOOKUP —Excel’s modern, flexible, and far more powerful lookup function. In my newest video, I walk through exactly why XLOOKUP should replace VLOOKUP in your everyday workflow. The upgrade isn’t subtle… once

Creating reports in Excel often means sorting, filtering, and copying data every week. But with modern Excel functions, you can automate most of that work. In this post, I’ll show you how to build a fully automatic, real-world report  using just three functions: FILTER  – pulls the rows you want SORT  – orders them by date TAKE  – returns the latest top rows This combination creates a clean, dynamic report that updates itself whenever new data is added. The Scenario: Latest H

If you ever find yourself scrolling, filtering, or copying rows just to get the latest data in Excel, there’s a much easier way. Excel now includes a function called TAKE() , and it can instantly pull the exact rows you want from any range. Whether you need the top 5  rows, the bottom 10 , or the latest entries  from a growing list, TAKE makes it automatic. What Does the TAKE Function Do? TAKE() pulls a specific number of rows or columns from the start or end of a range. Exam

If you use Excel at work, these five shortcuts will save you time and make your spreadsheets look clean and professional. They’re easy to learn and you’ll use them every day. 1. Ctrl + 1 — Open Format Cells This is the master shortcut. Use it to change: number format alignment borders colors 2. Ctrl + Shift + $ — Currency Format Highlight your numbers and use this shortcut to turn them into: $1,234.56 Perfect for budgets, invoices, and financial sheets. 3. Ctrl + Shift + % —

When most people think about Excel, they imagine writing a formula in one cell and then dragging it down thousands of rows. It works… but it’s slow, messy, and prone to mistakes. Enter one of Excel’s most underrated power tools: The MAP Function The MAP function lets you take any  formula you want and apply it to an entire list — all at once — without filling anything down, without helper columns, and without repeating yourself. Whether you're cleaning data, applying a transf

Meet Excel’s SCAN function  — one of the most powerful and underrated Dynamic Array functions  introduced in Microsoft 365. Once you understand what it does, you’ll never go back to the old methods again. What Is the SCAN Function? The SCAN function iterates (or “scans”) through a range of data and returns all intermediate results  — not just the final total. Think of it as Excel’s version of a “running memory.” It keeps track of the cumulative results as it moves through you

If your Excel workbook is full of the same formula repeated over and over , you’re not alone. In fact, one of the most common inefficiencies I see in real-world Excel files is formula duplication : Hundreds of rows each containing the same logic Long formulas copied across multiple sheets Slight variations that break over time Manual fixes every time something changes Good news: There’s a faster, cleaner, and smarter  way to work. Excel now allows you to turn any formula into

If you’re still typing formulas like =SUM(A2:A100) or =FILTER(A2:B100, A2:A100=E1), it’s time to level up. Using cell ranges  in Excel formulas is fine for small datasets — but as soon as you add new data, everything starts to break. Formulas stop updating. Charts go stale. PivotTables miss new rows. There’s a smarter, cleaner, and more future-proof  way to work in Excel. It’s called Excel Tables  — and once you start using them, you’ll never go back. See this in action in my

If you’ve ever spent time copying and pasting data  from one part of an Excel sheet to another — trying to pull out just the records you need — you’re not alone. It’s one of the most common (and time-wasting) habits in Excel. The good news? You don’t need to do it anymore. With the FILTER function , Excel can automatically extract just the data you want — and it updates instantly when your source data changes. No more manual work, no more broken copies, and no more forgetting

If you use PivotTables in Excel regularly, you know the routine: you update your source data, switch to your PivotTable, right-click, and select Refresh  — every. single. time. But that’s all changing. Microsoft has introduced a brand-new feature that lets PivotTables automatically refresh  when their source data changes — and it’s one of the most useful quality-of-life updates Excel users have seen in years. What Is the PivotTable Auto Refresh Feature? Traditionally, PivotTa

If you’ve ever built a formula in Excel that points to a large range, you know the struggle: blank cells at the bottom get included, and...

I’m excited to share something brand new with you—my very own Etsy shop ! For years, I’ve been teaching Microsoft Excel and other Office...

Microsoft is bringing AI directly into the formula bar with the new COPILOT()  function. Instead of crafting long nested formulas, you...

If you’ve ever worked with international teams or global datasets in Excel, you’ve probably come across reviews, comments, or content...

If you’ve ever found yourself spending way too much time manually moving columns around or using complex formulas to extract specific...

Are you looking to level up your data summarization game in Excel? Microsoft has rolled out a new dynamic function that’s turning heads:...