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

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

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-power-b…

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 🐙

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

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

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

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

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

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=bQlU548Q… #Excel #PowerQuery

🔄 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=6LXXISRu… No complex code needed - just one clever function that most Power Query users don't know about! 💡

Learn Data Analysis For Free in 2024: 1. Excel trumpexcel.com 2. SQL sqlbolt.com 3. PowerBI Reports in PowerBI (Datacamp) datacamp.com/courses/reports… 4. Tableau tableau.com/learn/training 5. Python pythontutorial.net 6. R codecademy.com/learn/learn-r Make 2024 your year.

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

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.