Category: Excel

Excel Kill The Annoying Copilot Floating Icon – Episode 2667

Posted on by Annie D

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

Excel Split Date Time Into Columns For Date And Then Time Episode – 2666

Posted on by Annie D

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

CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38

Posted on by Annie D

If you do not have file extensions turned on on your computer, trouble can occur. See how to change the worst Microsoft Office Default Setting: Uncheck the Box for Hide Known File Extensions.

Learn #excel #excelformulas #excelfunctions
#office #microsoft #microsoftexcel #microsoftoffice

Excel – How to Quickly Convert Text URLs to Clickable Hyperlinks in Excel with VBA – Episode 2665

Posted on by Annie D

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 Continue reading “Excel – How to Quickly Convert Text URLs to Clickable Hyperlinks in Excel with VBA – Episode 2665” →

MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34

Posted on by Annie D

See how to use a formula to spill a rectangle Range of Weekly Commission Paid Amounts. Microsoft 365 Excel makes life easy! Download Excel file: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelShort34.xlsx

Learn #excel #excelformulas #excelfunctions