MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
How to Show "Discount 10%" in Excel Using Formulas & Custom Formatting - Episode 2668
Microsoft Excel Tutorial: Formula To Show Word Next To Discount Percentage. How to Show "Discount 10%" in Excel Using Formulas & Custom Formatting. Today's question comes from Roo: How can we modify a dropdown list of discount percentages (10%, 20%, 30%) to display as "Discount 10%" on an invoice? This video covers multiple ways to achieve this, whether your percentages are stored as text or numbers. First, we look at a simple formula approach. By using a basic concatenation formula with an ampersand (`&`), we can combine the word "Discount" with the selected percentage. However, if your percentages are stored as actual numbers, you'll need to use the `TEXT` function to properly format them. But wait—there’s an even better way...
Excel Split Date Time Into Columns For Date And Then Time Episode - 2666
Microsoft Excel Tutorial: Split Date Time into Columns for Date and then Time. In this video, we tackle an intriguing Excel challenge from a real-world job interview scenario. Imagine being asked to split a column of date and time into separate date and time fields, build a pivot table, and create a report limited to certain conditions—class equals 1 and days are Tuesday or Thursday. Sounds tricky, right? Let’s break it down step by step and explore multiple approaches! First, we’ll discuss how to split the date and time using simple formulas like =INT(A2) for the date and =A2-D2 for the time, along with proper formatting tips. Then, we’ll dive into creating a pivot table that reports by date instead of date and time. We’ll even...
Excel Kill The Annoying Copilot Floating Icon - Episode 2667
Microsoft Excel Tutorial: Microsoft has a new Copilot icon that follows the active cell around Excel. It is super annoying. Here is how to get rid of it! In yesterday’s video, DR Steele asked a great question: How do we remove this annoying Copilot icon that won’t go away? Microsoft doesn’t give us a global setting to turn it off, and every time you open a new workbook, it comes right back. Frustrating, right? Well, I’ve got a workaround! Thanks to John Acampora, we found a way to manually hide the icon using a keyboard shortcut. But that’s not a permanent fix. So, I turned to my friend Suat, and together, we came up with a VBA solution that will hide the Copilot icon automatically whenever you open Excel. No more distractions—just a...
Excel - How to Quickly Convert Text URLs to Clickable Hyperlinks in Excel with VBA - Episode 2665
Microsoft Excel Tutorial: Jody needs a way to convert a column of text URLS into clickable hyperlinks in Excel. Here is the macro: Sub MakeSelectedHyperlinksHot() For Each Cell In Selection ActiveSheet.Hyperlinks.Add Anchor:=Cell, Address:=Cell.Value, TextToDisplay:=Cell.Value Next Cell End Sub In this video, we tackle a common Excel issue: converting thousands of text strings that look like URLs into clickable hyperlinks. Jody reached out with a situation—5,000 rows of exported data in Excel, all containing text that resembles hyperlinks. The manual method of right-clicking each cell and creating hyperlinks one by one is tedious and inefficient. Is there a faster way? Absolutely. Let's explore several solutions...
Excel I Need A Once In A Lifetime Formula For 2025 - Episode 2665
Microsoft Excel Tutorial: Looking for a great formula to format 2025 cells. To download the workbook from today: Excel I Need A Once In A Lifetime Formula For 2025 - Episode 2665 Sample Files - MrExcel Publishing Start 2025 with a bang by diving into an Excel adventure like no other! In this tutorial, we explore the fascinating concept of "square years"—numbers that are perfect squares of whole numbers—and why 2025 (45 squared) is truly a once-in-a-lifetime event. We’ll walk you through formulas and creative techniques to visualize this unique year in Excel, while tying it back to historical milestones like the California Gold Rush and the completion of the Hoover Dam. Discover how to create a stunning 45x45 square grid in Excel...
Excel for Mac New AddIn Brings More Data To Power Query - 2598
Power Query for Mac Excel is missing From Table/Range. Power Query for Mac Excel is missing From Folder. Power Query for Mac Excel is missing From XML. Power Query for Mac Excel is missing From JSON. A new More Data add-in from Suat Ozgur at MrExcel adds all four of these functionalities to Excel for Mac! Download the add-in from this article: MoreQuery for Mac The FREE, open-source add-in adds From Table/Range to Power Query for Mac. It adds From Folder. It adds From XML. It adds from JSON. Table of Contents: (0:00) More Data Add-In fixes Power Query for Mac (0:37) Get Data From Table/Range on Mac Power Query (1:18) Get Data From Folder on Mac Power Query (2:43) Get Data from JSON or XML on Mac Power Query (3:27) Wrap-up
Conquering Excel's Formatting Quirks with Creative Hacks - Episode 2664
Microsoft Excel Tutorial: Can you mix formatting in an Excel cell that contains a formula? How to Work Around Excel's Formatting Limitations Ever wondered if you could apply different formatting to parts of a cell populated by a formula in Excel? In today’s video, we dive into this intriguing question posed by Paul, a viewer who couldn’t find a solution to this common Excel conundrum. While Excel doesn’t allow partial formatting of a formula’s result, I’ve discovered a clever workaround using the **Paste Linked Picture** feature. Watch as I demonstrate this creative hack step-by-step! We start with a fundamental Excel tip: editing and formatting individual characters in a cell. From using **F2**, the **Home** key, and **Shift**, to...
Challenge How To Arrange A Seating Chart At A Networking Event - 2438
You have 100 people coming to a conference. There are 11 sessions. Tables seat 10 people each. How can you set up a seating chart for the 11 sessions so everyone has a chance to meet everyone else at least once? Bill tries brute-force Monte Carlo and can't get better than 65% of the way to the goal. Is there a better way? Download my workbook from here: Arrange100People.xlsm
Excel - Unlock the Secrets of Excel's New Compatibility Version! - Episode 2663
Microsoft Excel Tutorial: Unlock the Secrets of Excel's New Compatibility Version! Are you tired of mismatched results when sharing Excel files between coworkers using different versions? Microsoft has finally addressed this issue. Today we dive into the game-changing **Function Compatibility Version**. This feature offers a solution to inconsistencies caused by updates to five key functions: **LEN, MID, SEARCH, FIND, and REPLACE**. While the updates might seem minor, the implications are massive, especially for teams juggling old and new versions of Excel. Learn how the new **Compatibility Version** setting makes it easier to manage version disparities. Whether you're stuck on Excel 2016 or using the latest features in Excel 365...

Forum statistics

Threads
1,226,179
Messages
6,189,476
Members
453,549
Latest member
MBenedikt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top