Sumit Bansal 📊📈
@TrumpExcel
Spreadsheet Geek @ https://TrumpExcel.com | Microsoft Excel @MVPAward | Blogger | YouTuber | Movie Buff
You might like
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
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.com
YouTube
🚫 STOP Copying Formulas Down - Excel's BYROW Function does it...
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
The new Regex functions in #Excel can be a powerful tool when it comes to #DataCleaning. 🧼 Never used Regex before? Don't worry, on August 7 @TrumpExcel will walk you through everything you need to know to start using these functions. Sign up here: meetup.com/vancouver-powe…
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…
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.com
YouTube
Exploring Color Theory | Helen Wall
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…
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% 🔄…
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…
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) ✅…
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…
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:…
🔄 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 -…
Learn Data Analysis For Free in 2024: 1. Excel trumpexcel.com 2. SQL sqlbolt.com 3. PowerBI Reports in PowerBI (Datacamp) datacamp.com/courses/report… 4. Tableau tableau.com/learn/training 5. Python pythontutorial.net 6. R codecademy.com/learn/learn-r Make…
Here is a video that shows some advanced Find and Replace tricks in Excel. How many did you know already? youtu.be/cCorF_UIQ9s
youtube.com
YouTube
8 Awesome Find and Replace Tricks in Excel (Advanced)
While it's easy to remove duplicates in different cells in Excel, doing that from the same cell is not that straightforward. Here is a video where I show how to remove duplicate values from within the cell.
We asked some of the Speakers of Bulgaria #Excel Days 2024, what they think about #AI? @TrumpExcel Sumit Bansal, Andrew Grigolyunovich, @FMWC_ , @chandeep2786 Chhabra, Mark Proctor @exceloffthegrid, Jordan Goldmeier @JLOOKUP_ , youtu.be/AE-lJFa7tdw?si…
youtube.com
YouTube
Bulgaria Excel Days 2024 Speakers about AI
United States Trends
- 1. Veterans Day 33.9K posts
- 2. Packers 101K posts
- 3. Good Tuesday 20.9K posts
- 4. Eagles 129K posts
- 5. SoftBank 4,421 posts
- 6. Benítez 13.9K posts
- 7. Jordan Love 15.6K posts
- 8. #WWERaw 142K posts
- 9. Matt LaFleur 9,050 posts
- 10. JOONGDUNK BRIGHT SKIN 266K posts
- 11. Bond 59.1K posts
- 12. Berkeley 70.9K posts
- 13. Green Bay 19.2K posts
- 14. Jalen 24.2K posts
- 15. Grayson Allen 4,756 posts
- 16. Sirianni 5,201 posts
- 17. Kevin Patullo 7,162 posts
- 18. AJ Brown 7,307 posts
- 19. Tsushima 2,349 posts
- 20. McManus 4,555 posts
You might like
-
MyOnlineTrainingHub
@OnlineTrainingH -
ExcelDemy
@ExcelDemy -
MyExcelOnline.com
@myexcelonline -
howtoexcelatexcel
@howtoexcelatex -
Bill Jelen
@MrExcel -
Contextures
@contextures -
Excel University
@Exceluniversity -
Excel (A-Z)
@masterexcelaz -
Ryan Wells
@ryanwellsr -
Ken Puls, FCPA, FCMA
@kpuls -
Microsoft Excel
@msexcel -
Learn Excel to excel
@exceltoexcel -
Excel Easy
@ExcelEasy -
Debra Dalgleish
@ddalgleish
Something went wrong.
Something went wrong.