Sumit Bansal 📊📈

7.3K posts

Sumit Bansal 📊📈 banner
Sumit Bansal 📊📈

Sumit Bansal 📊📈

@TrumpExcel

Spreadsheet Geek @ https://t.co/CqfwUI4KRZ | Microsoft Excel @MVPAward | Blogger | YouTuber | Movie Buff

India Katılım Ağustos 2009
266 Takip Edilen7.8K Takipçiler
Sabitlenmiş Tweet
Sumit Bansal 📊📈
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 bit.ly/free-online-ex… If you find it useful, please spread the word! @msexcel
English
39
215
637
0
Sumit Bansal 📊📈
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 📊📈 tweet media
English
1
0
1
174
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Claude is offering double the usage in Excel, but you got to have a time machine to use it 😂
Sumit Bansal 📊📈 tweet media
English
0
0
0
191
Sumit Bansal 📊📈
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 youtube.com/watch?v=yBm4y9…
YouTube video
YouTube
English
0
1
1
324
Sumit Bansal 📊📈
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 - youtube.com/watch?v=DyAYy1… The secret? FILTER + BYROW + a clever logic trick 👀
YouTube video
YouTube
English
0
0
3
341
Sumit Bansal 📊📈
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 youtube.com/watch?v=42ePfa…
YouTube video
YouTube
English
0
0
2
640
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Here is a cool trick to hide cell values in #Excel using Custom Number formatting
English
0
1
2
388
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Renewed as an Excel MVP 12th year in a row 🎉 Grateful and honored to be part of the Microsoft Most Valuable Professional (MVP) program. Congratulations to all the renewed and newly awarded MVPs. #Microsoft #MVP #Excel #MVPBuzz
Sumit Bansal 📊📈 tweet media
English
0
0
6
394
Brian
Brian@Brian90862815·
@TrumpExcel @msexcel oops my ipad has a mind of its own, I meant to type is very pleasing😉
English
1
0
0
14
Sumit Bansal 📊📈
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 bit.ly/free-online-ex… If you find it useful, please spread the word! @msexcel
English
39
215
637
0
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Here's the longest @msexcel keyboard shortcut I use daily 👇 𝗖𝘁𝗿𝗹+𝗦𝗵𝗶𝗳𝘁+𝗔𝗹𝘁+𝗪𝗶𝗻𝗱𝗼𝘄𝘀 + 𝗫 - This opens the Excel application (I am using Windows 11 with Microsoft 365) That's five keys just to open Excel 🤯 But I have gotten used to it, and I find it faster than using a mouse. Think you might use this? Here are some more: ➡️ Ctrl+Shift+Alt+Windows + 𝗣 = Opens PowerPoint ➡️ Ctrl+Shift+Alt+Windows + 𝗪 = Opens Word ➡️ Ctrl+Shift+Alt+Windows + 𝗢 = Opens Outlook ➡️ Ctrl+Shift+Alt+Windows + 𝗡 = Opens OneNote ➡️ Ctrl+Shift+Alt+Windows + 𝗟 = Opens LinkedIn in browser What are your favorite new keyboard shortcuts? Doesn't have to be this long that makes you feel like an octopus 🐙
Sumit Bansal 📊📈 tweet media
English
0
1
5
331
Sumit Bansal 📊📈 retweetledi
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
If you missed last week's Vancouver #PowerBI and Modern #Excel meet-up, the recording is now available: youtu.be/byrtypKrdPQ Thanks again to Joseph Yeates for showing us what's new in PBI, and to Helen Wall for presenting on color theory and how to apply it to our PBI models!
YouTube video
YouTube
English
0
7
21
2.2K
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Want to get all the sheet names in one go in #Excel? There's a function for this - an old, forgotten function. Most Excel users have never heard of it. GET.WORKBOOK has been hiding in Excel since the Excel 4.0 days. You can't use it in cells anymore... But there is a workaround 👇 In today's video, I'm showing you how to pull every sheet name with one simple formula. And, for the Power Query fans out there – I'll walk you through the Power Query method too. ❓ Are you Team Formula or Team Power Query? Let me know in the comment section 👇 #Excel @msexcel #PowerQuery
English
0
0
4
380
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
@Brian90862815 @msexcel Thanks Brian... Do you mean the font in the email or on the BMAC page? While I can specify the font in my email, the one on the page is determined by the Buy Me a Coffee website.
English
1
0
0
25
Brian
Brian@Brian90862815·
@TrumpExcel @msexcel Sumit what font do you use for Sumit Bansal in your but me a coffee ad, it is beautiful! I enjoy your emails🫡
English
1
0
0
19
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Your Pivot Tables are hiding a secret - it's called Pivot Cache. Once you understand how it works, you can do some clever things with it. For example, you can: 🗑️ Delete ALL your source data, and your PivotTable still works perfectly 📉 Reduce file size by more than 95% 🔄 Get your original data back with one double-click 🎛️ Control multiple PivotTables with a single slicer ... and more I just dropped a new video breaking down what Pivot Cache is and 8 game-changing hacks every Pivot Table user should know. Which of these tricks caught your attention? Did you find any of them useful? Let me know in the comments. @msexcel #ExcelTips #PivotTable
English
0
1
5
555
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
VLOOKUP or XLOOKUP easily gets you the first matching value. But what if you want the second, the third, the fifth, or the Nth one? 🤔 That's where most Excel users hit a wall. In today's video, I'll show you a super-easy way to get the Nth lookup result. And it doesn't use VLOOKUP or XLOOKUP 🤯 Know of any other way to do this? Let me know in the comments 👇 #Excel #VLOOKUP @msexcel
English
1
1
11
638
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
SEQUENCE function in Excel isn't just for boring number lists - combine it with other functions and you can do some mind-blowing things. For example, you can: ✅ Create 30-day project schedules in seconds ✅ Get a list of working days only (skipping weekends & holidays) ✅ Build time slots with 30-minute intervals ✅ Extract every 3rd record from a massive dataset ✅ Repeat team rosters automatically ✅ Build dynamic calendars with ONE formula ....and more In my latest video, I cover some of the awesome things you can do with the SEQUENCE function Do you have any cool SEQUENCE function tricks of your own? Share them below - I'd love to see what creative solutions you've built! 👇 #Excel #ExcelFormulas #SEQUENCE
English
0
0
0
332
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Your team has no idea what your complex Excel formulas do. And in six months, neither will you. So why not add some comments within the formula itself that add some context. In my latest video, I cover three easy ways to have comments right within your Excel formulas. #Excel #ExcelFormulas
English
0
0
5
445
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
Power Query has a lot of hidden shortcuts ⌨️ If you spend a lot of time in the Power Query editor, knowing these would make a huge difference. In my new video, I have covered 15 Power Query shortcuts that are easy to learn and can save hours. ➡️Watch here: youtube.com/watch?v=bQlU54… #Excel #PowerQuery
YouTube video
YouTube
Sumit Bansal 📊📈 tweet media
English
0
0
0
279
Sumit Bansal 📊📈
Sumit Bansal 📊📈@TrumpExcel·
🔄 Sorting data in Power Query is easy, until you want to sort based on a custom list! 🤔 Here is my latest video where I share a simple trick to create custom sorting criteria (like Critical → High → Medium → Low) that don't follow standard ordering. ▶️ Video - youtube.com/watch?v=6LXXIS… No complex code needed - just one clever function that most Power Query users don't know about! 💡
YouTube video
YouTube
English
0
0
0
362