Microsoft Excel Tutorial: The Mysterious Chart Label That Wouldn’t Update – Solved!

A completely evil Excel problem! A chart label refuses to update, no matter what you do. My friend Kelly sent me this chart, and everything seemed fine—except for one stubborn label that always says “Test 1.” Even after checking that the labels are correctly linked to a range using “Value From Cells,” this one label remains broken. After trying everything, I had to reach out to someone on the Excel team, and they finally gave me the answer.

Turns out, the label became disconnected from the data, and there’s a Continue reading “Excel The Mysterious Chart Label That Wouldn’t Update – Solved! – Episode 2670” →

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 Continue reading “How to Show “Discount 10%” in Excel Using Formulas & Custom Formatting – Episode 2668″ →

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. Continue reading “Excel Kill The Annoying Copilot Floating Icon – Episode 2667” →

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, Continue reading “Excel Split Date Time Into Columns For Date And Then Time Episode – 2666” →