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

We asked some of the Speakers of Bulgaria #Excel Days 2024, what they think about #AI? Sumit Bansal 📊📈 Sumit Bansal, Andrew Grigolyunovich, Financial Modeling World Cup , Chandeep Chhabra Chhabra, Mark Proctor Excel Off The Grid, Jordan Goldmeier Jordan Goldmeier , youtu.be/AE-lJFa7tdw?si…

Which Excel lookup function do you prefer?

A cool MS Excel Filter trick you may not know already. #Excel #MSExcel

Here is an easy formula to Flip data in Microsoft Excel

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.

Here is a video that shows some advanced Find and Replace tricks in Excel. How many did you know already? youtu.be/cCorF_UIQ9s

🔄 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 -

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:

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

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) ✅

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

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% 🔄

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!

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

Here's the longest Microsoft Excel 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

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 Sumit Bansal 📊📈 will walk you through everything you need to know to start using these functions. Sign up here: meetup.com/vancouver-powe…

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

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

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…