Want to learn and get better in #Excel? I just released my entire Excel (Basic to Advanced) course for FREE. You get instant access to 26 Excel videos (12+ hours of training) & download files bit.ly/free-online-excel-tra… If you find it useful, please spread the word! @msexcel

If your Pivot Table freezes for a few seconds every time you drag a field, use this fix. There's a checkbox at the bottom of the PivotTable Fields pane called Defer Layout Update. Tick it, and Excel stops recalculating after every change. Make all changes, then apply in one go.

One Excel shortcut worth remembering: Alt+= Select the cell below a column of numbers, press Alt+=, and Excel inserts a SUM formula for the range above. It works at the end of a row too.

Too many columns in Power Query? Don't scroll through the preview looking for the one you need. Press Ctrl+G, type the column name, then double-click it to jump straight there. Small trick, but it saves me time every day.

Excel's =COPILOT() function didn't fly for long. Microsoft is removing it on September 14. Copilot in Excel is staying. Only the in-cell function is going away. Microsoft said not to use it for calculations. Quite a warning for an Excel function. support.microsoft.com/en-us/…

Need a quick total in Excel? Skip the formula. Select the numbers and look at the status bar. You'll see the Average, Count, and Sum. Right-click the bar to add Minimum and Maximum. You can also click any value to copy it, although Excel copies the rounded value shown there.

Here's a small Excel trick you might not know. Hover over an active filter icon and Excel will show you the criteria applied to that column. Handy when you inherit a filtered workbook and have no idea what's been selected.

A few days ago, I was so happy with Claude Opus 4.8. I was getting some amazing work done with it. Then Fable 5.0 showed up for a few hours. Now I'm back on Opus 4.8, and I can't stand it. It feels slow and dull. Wonderful how our brains work.

Claude in Excel can now work across all open workbooks. It can even work alongside open PowerPoints at the same time. And this thing is still in Beta 🤯 #Excel #AI

Claude is offering double the usage in Excel, but you got to have a time machine to use it 😂

🔁 Want to repeat rows in Excel? Most people would reach for Power Query, but sometimes... a formula is just easier. In today's video, I'll show you how to: ✅ Repeat each row N times ✅ Repeat rows a specified number of times youtube.com/watch?v=yBm4y9c-…

Want to remove blank rows from your data in Excel? Most people reach for Go To Special or start deleting manually. But there's also a formula that does it instantly. 🎥 Here is the full video - youtube.com/watch?v=DyAYy1gK… The secret? FILTER + BYROW + a clever logic trick 👀

No need to copy a formula down the column in Excel. BYROW handles it all in one shot 🎯 It takes the entire dataset and performs the specified calculation row-by-row. Here is a video that covers everything you need to know about this new Excel function youtube.com/watch?v=42ePfaij…

Here is a cool trick to hide cell values in #Excel using Custom Number formatting