Category: Power Pivot

Excel – First Look At Copilot AI For Excel – Episode 2636

Posted on by Annie D

Microsoft Excel Tutorial: Preview of AI Copilot for Excel.

Welcome to episode 2636 of Mr. Excel’s netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I’m excited to share it with you.

In this video, we will be exploring the Copilot feature and its capabilities. We will be working Continue reading “Excel – First Look At Copilot AI For Excel – Episode 2636” →

Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050

Posted on by Annie D

Microsoft Excel Tutorial: 🎵 Celebrating Spreadsheet Day in Times Square with the Naked Cowboy! 🎵 | Excel Song and Serenade.

Welcome to my latest video, where the Naked Cowboy, is celebrating Spreadsheet Day from the iconic Times Square in New York City. As a lover of all things Excel, he couldn’t resist the opportunity to serenade the accounting team and all spreadsheet enthusiasts out there with a special song. So, grab your calculators and get ready to sing along with me!

For those who may not know, Spreadsheet Day falls on October 17th and is a day dedicated to celebrating the powerful Continue reading “Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050” →

Excel Customers Paying Less Than Average – Episode 2639

Posted on by Annie D

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

Excel Show Details In Excel Pivot Table – Episode 2638

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points.

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

Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡

🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab – it’s a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the Continue reading “Excel Show Details In Excel Pivot Table – Episode 2638” →

Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637

Posted on by Annie D

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

Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635

Posted on by Annie D

Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com.

Try this web app now to search my videos: https://c07.sheetcast.com/view/c79f93d2-0dcf-441f-97ac-b0c100f02a4f/~/d174333f-e3fe-4b14-a13b-ef6e384af5bb?embed=True&expand=true&showTitle=true

Welcome to episode 2635 of the MrExcel podcast! It’s been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn’t be more grateful for your support. Today, I have something truly amazing to show you – how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I’ll also be sharing how you can search through 25 years of MrExcel content Continue reading “Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635” →

Excel – Review 2400 YouTube Thumbnails Using 2 New Excel Functions – Episode 2634

Posted on by Annie D

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

Excel – First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel – Episode 2633

Posted on by Annie D

Microsoft Excel Tutorial: Three New Functions Debut in Excel: GROUPBY, PIVOTBY, and PERCENTOF.

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

Read the Microsoft Announcement: https://techcommunity.microsoft.com/t5/excel-blog/new-aggregation-functions-groupby-and-pivotby/ba-p/3965765

Welcome to episode 2633 of MrExcel’s netcast, where we explore the latest and greatest features of Microsoft Excel. In this episode, we will take a first look at three new functions: GROUPBY, PIVOTBY, and PERCENT OF. These functions are incredibly simple to use, yet offer deep options for data analysis. So let’s dive in and see what they can do!

First up, we have GROUPBY. This function allows us to group data by Continue reading “Excel – First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel – Episode 2633” →

Excel New Check Performance To Reduce Excel File Size – Episode 2632

Posted on by Annie D

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

Excel Cell Tool Tip Calculated On The Fly – Episode 2631

Posted on by Annie D

Microsoft Excel Tutorial: Display an in-cell tooltip based on a calculation.

To download the workbook from today: https://www.mrexcel.com/youtube/Q5vwz18lir4/
Rather than type the code, download the workbook and copy it from my workbook.

Welcome to episode 2631 of MrExcel’s netcast! In this video, we will be discussing an amazing idea that was sent in by one of our viewers on YouTube. The idea is to have a cell tool tip that is calculated on the fly, meaning that the recommended value in the tool tip changes based on the data entered. This is a great way to make data entry more Continue reading “Excel Cell Tool Tip Calculated On The Fly – Episode 2631” →

Excel Labs Function To Get Answers From OpenAI In Excel – Episode 2630

Posted on by Annie D

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

As You Celebrate Spreadsheet Day Tonight, Not Too Many PowerPivotinis! #spreadsheetday #excel

Posted on by Annie D

October 17 is Spreadsheet Day!

Welcome to my channel, where we celebrate all things Excel and spreadsheets! Today is a special day, as we honor the invention of the spreadsheet on Spreadsheet Day. As we raise our glasses to toast this incredible tool, let’s not forget to also raise a glass to the advancements in technology that have made our lives easier and more efficient.

As we reflect on the evolution of spreadsheets, let’s also take a moment to appreciate the hard work and dedication of those who have contributed to its development. From the early days of the typewriter Continue reading “As You Celebrate Spreadsheet Day Tonight, Not Too Many PowerPivotinis! #spreadsheetday #excel” →