Power Query was HARD until I learned these 7 Tips
https://youtube.com/watch?v=xxQnsQz5aPcPower Query is an amazing feature of Excel that can save us a ton of time with our jobs. But for most people, it's not very approachable and can be…
https://youtube.com/watch?v=xxQnsQz5aPcPower Query is an amazing feature of Excel that can save us a ton of time with our jobs. But for most people, it's not very approachable and can be…
https://youtube.com/watch?v=zEbbB_al47MLearn how to use Excel’s macro recorder in combination with ChatGPT to automate any task in Excel. This technique will help you create robust VBA macros that are flexible and…
https://youtube.com/watch?v=bGUojS3EhIULearn 10 Excel tricks for faster navigation, data cleanup that will help you navigate Excel faster, save time with data cleanup, date, conversions, formatting, and more. ? Free Excel Class:…
https://youtube.com/watch?v=pOopadts_8QTired of manually combining text? TEXTJOIN to the rescue. Learn how to automate this common, repetitive task in seconds ?? #textjoin #combinedata #exceltips #timesavingtricks #excelformatting #productivity hack.
https://youtube.com/watch?v=GsTDh7Wa0qEWe show you how to use the SEQUENCE function in Excel, combined with the date function, to create lists of dates! Unlock a new level of efficiency and save valuable…
https://youtube.com/watch?v=opE3jj4U7i0Curious about automating your inventory management? ? Discover how to create an auto-updating inventory list in Excel that can save you time and effort! Say goodbye to manual updates! ?✨…
https://youtube.com/watch?v=aFGSMzL5DHoDid you know this Excel Flash Fill Shortcut? Flash Fill is a powerful tool that detects a pattern, and you can use it today with this CTRL + E shortcut.…
https://youtube.com/watch?v=HBCxkXhlnyYIn this video, we share how Power Query can replace XLOOKUP when merging data in Excel. Looking for our full tutorial on Power Query? Watch it here: https://youtu.be/HBgq0La7dj4?si=-Pz9v083bVbKEH9W @ExcelCampus **JOIN…
https://youtube.com/watch?v=6HZxH3Q0UBwIn this video you'll learn about 25 new Excel features that were released in 2024. This includes updates for formatting, formulas, Python, Copilot, grid behavior and a lot more. The…
https://youtube.com/watch?v=EEF0hveyJh4In this tutorial video, learn how to use the LOOKUP function in Microsoft Excel to return multiple values. Discover how to retrieve data from a table using multiple criteria, and…