MrExcel Excel Videos

Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com. Try this web app now to search my videos: MrExcel's Video Search 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 using just 18 Excel functions. Let's dive in! Have you ever wondered how to create a web app from your Excel workbook without giving away your intellectual property? Well, I...

Microsoft Excel Tutorial: Quickly download YouTube Thumbnails into Excel. TubeBuddy Link: Pricing Formula for Edit Hyperlink: =HYPERLINK("YouTube"&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 you enjoy this video, please click the like button below to help...

Microsoft Excel Tutorial: Three New Functions Debut in Excel: GROUPBY, PIVOTBY, and PERCENTOF. To download the workbook from today: Excel - First Look GroupBy PivotBy PercentOf Functions - Episode 2633 Sample Files - MrExcel Publishing Read the Microsoft Announcement: New aggregation functions: GROUPBY and PIVOTBY 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 categories...

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 ahead and click "optimize all", it's important to take a look at what Check Performance has found. It looks for excess formatting, unused cell styles, and unneeded...

Microsoft Excel Tutorial: Display an in-cell tooltip based on a calculation. To download the workbook from today: Excel Cell Tool Tip Calculated On The Fly - Episode 2631 Sample Files - MrExcel Publishing 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 efficient and accurate. In this old video from 2019, I showed how to create a cell tool tip. However, after...

Microsoft Excel Tutorial: Using OpenAI from a formula in Excel. To download the workbook from today: Excel Labs Function To Get Answers From OpenAI In Excel - Episode 2630 Sample Files - MrExcel Publishing 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 singers. But behind the scenes, there's a great Excel story to be told. We used the Labs...

Microsoft Excel Tutorial: Multi-select all checkboxes and flip from true to false or back. To download the workbook from today: Excel VBA Macro To Flip All Checkboxes In Excel - Episode 2629 #excelhacks Sample Files - MrExcel Publishing Copy this code and put it in your personal macro workbook: Sub FlipCheckboxes() On Error Resume Next For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4) cell.Value = Not (cell.Value) Next cell On Error GoTo 0 End Sub Sub AllTrueCheckboxes() On Error Resume Next For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4) cell.Value = True Next cell On Error GoTo 0 End Sub Sub AllFalseCheckboxes() On Error Resume Next For Each...

Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel To download the workbook from today: Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel Sample Files - MrExcel Publishing In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district. Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the "Insert" tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true or false values...

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel. Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages. In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting a certain number of days from the first service date. MrExcel then demonstrates how to calculate the age of each repair using the DATEDIF function. He suggests using a pivot...