Microsoft Excel Tutorial: Create an Excel Pivot Table to Identify Which Customers Are Paying Less than Average for a Product.

To download the workbook from today: https://www.mrexcel.com/youtube/4XrKZhiBB-k/

Hey Excel enthusiasts! 👋 In this MrExcel netcast, we tackle a fascinating question from Glenn, who joined our recent Nashville IMA webinar. Ever wondered which customers are paying less than the average? 🧐 We’ve got you covered!

🔍 Using a special pivot table based on the Data Model, we delve into the powerful DAX function CALCULATE. Follow along as we transform our data into a table named “Sales” and explore 12,000 rows of Continue reading “Excel Customers Paying Less Than Average – Episode 2639” →

Microsoft Excel Tutorial: Finding best routing for a trip with 148 locations.

Hey Excel fam! 🚀 Bill Jelen here with an epic Excel challenge. 🏋️‍♂️ Joined forces with the Supernatural workout community to optimize a 148-location quest using Excel magic. 🌍 Check out the journey, from Tahiti to Antarctica, and witness the distance-cutting madness unfold. 🌐

💡 First attempt started in Tahiti, but the route was a rollercoaster. 🔄 Tried a radical pivot, starting in Antarctica. 🏔️ Improved the distance to 90,253 miles, but still seeking perfection.

🤔 Experimented with K-Means clustering, exploring different strategies. 🧩 Finally settled on a plan starting in Continue reading “Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637” →

Microsoft Excel Tutorial: Quickly download YouTube Thumbnails into Excel.

TubeBuddy Link: https://www.Tubebuddy.com/pricing?a=mrexcel

Formula for Edit Hyperlink: =HYPERLINK(“https://studio.youtube.com/video/“&B2&”/edit”,”Edit”)
Formula to Wrap Thumbnails into 9 columns: =WRAPROWS(FILTER(F2:F2417,G2:G2417=1),9)

Welcome to episode 2634 of MrExcel’s Net Cast! In this video, we will be exploring two new Excel functions that will help us quickly review over 2400 YouTube thumbnails. As we approach the 25th anniversary of MrExcel, I am grateful for the opportunity to connect with friends and followers from around the world through 67 books, thousands of articles, over 5 million posts on our message board, and 2400 videos on YouTube. If Continue reading “Excel – Review 2400 YouTube Thumbnails Using 2 New Excel Functions – Episode 2634” →

Microsoft Excel Tutorial: A new Check Performance Feature debuts in Excel to clean excess cell formatting that can cause large file sizes.

Welcome to episode 2632 of MrExcel’s Net Cast! In this video, we’ll be discussing a new feature in the Windows version of Excel that has been available in Excel online for some time now. It’s called Check Performance and it can help you clean up unwanted cell formats and reduce file sizes. This feature can be found on the Review tab and is definitely worth checking out for any workbook that you’ve been using for years.

Now, before you go Continue reading “Excel New Check Performance To Reduce Excel File Size – Episode 2632” →

Microsoft Excel Tutorial: Using OpenAI from a formula in Excel.

To download the workbook from today: https://www.mrexcel.com/youtube/oh4rZCKssPM/

Welcome back to the MrExcel Netcast, where we explore all things Excel. In today’s episode, we’re diving into the world of Open AI and how you can use it right inside of Excel. Thanks to the amazing team at Excel Labs, we now have access to this powerful tool that can generate answers and content for us in a matter of seconds.

If you caught our silly videos for Spreadsheet Day, you may have noticed that we had some help from some unexpected Continue reading “Excel Labs Function To Get Answers From OpenAI In Excel – Episode 2630” →

Thanks to Jamaican Dancehall legend D’Angel for going along with my crazy songs for spreadsheet day 2023.

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.