Sumit Bansal 📊📈

I share Excel tips and tricks | Microsoft Excel MVP | 520K+ on YouTube | AI enthusiast

[Sumit Bansal 📊📈 @TrumpExcel]

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

https://t.co/qlbGFJE7ES

If you find it useful, please spread the word! @msexcel

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

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.

https://t.co/979J07JjuJ

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

I share more practical Excel tips in my free weekly newsletter.

You can join here and get my free Excel tips ebook:
https://t.co/Flryqw1PpH

[Sumit Bansal 📊📈 @TrumpExcel]

If you spend a lot of time in Excel, these 5 keyboard shortcuts are worth remembering:

[Sumit Bansal 📊📈 @TrumpExcel]

5. Ctrl+`

This switches the worksheet between formula results and the formulas themselves.

Very handy when you're trying to work out what someone else's file is doing.

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

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.

[Sumit Bansal 📊📈 @TrumpExcel]

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

[Sumit Bansal 📊📈 @TrumpExcel]

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

[Sumit Bansal 📊📈 @TrumpExcel]

🔁 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

https://t.co/J5NRu21Xov

[Sumit Bansal 📊📈 @TrumpExcel]

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 - https://t.co/b6Rp7yTgS8

The secret? FILTER + BYROW + a clever logic trick 👀

[Sumit Bansal 📊📈 @TrumpExcel]

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

https://t.co/GdRzeMWTpS

[Sumit Bansal 📊📈 @TrumpExcel]

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