Category: Excel

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

FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841

Posted on by Annie D

Learn about how to use FILTER function with a complex filter based on a BETWEEN, AND and OR Logical Tests. Chapter 13 in the book, The Only App That Matters. Learn about Advanced Filter also.
Topics:
1. (00:00) Introduction
2. (00:05) Complex Filter
3. (00:30) Logical Tests
4. (02:00) Filter Function
5. (06:02) Advanced Filter)
6. (07:54) Summary
7. (08:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup #filter #filterfunction #logical #advancedfilter

D’Angel of Dancehall Rhymes for Spreadsheet Day 2023

Posted on by Annie D

Thanks to Jamaican Dancehall legend D’Angel for going along with my crazy songs for spreadsheet day 2023.

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

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

Posted on by Annie D

October 17 is Spreadsheet Day!

My dad’s favorite actor, Max Gail, who played Det. Stan “Wojo” Wojciehowicz for eight seasons on Barney Miller reflects on how far Excel has come in one lifetime.

Also – if you are going out to celebrate tonight, take it easy on the Powerpivotini’s or you might end up down at the 12th Precinct!

This is the last of my 2023 Spreadsheet Day Cameos. Have a great evening!

Do NOT ask your Boss for Time Off to Celebrate Spreadsheet Day! #OITNB #SpreadsheetDay #Excel #nsfw

Posted on by Annie D

I don’t care how good you are at spreadsheets, do NOT try to ask your boss for time off to celebrate Spreadsheet Day. It won’t go well!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Many thanks to Alysia Reiner, the amazing actress who plays Fig on Orange is the New Black. I asked if she could improv, as Fig, her reaction to my request for time off for Spreadsheet Day. Awesome. My new favorite spreadsheet day Continue reading “Do NOT ask your Boss for Time Off to Celebrate Spreadsheet Day! #OITNB #SpreadsheetDay #Excel #nsfw” →

Spreadsheet Day – Never Merge Cells – PSA from Sheriff Buford T. Justice #excel #spreadsheetday

Posted on by Annie D

Even Buford T. Justice knows that Center Across Selection is better than Merge Cells in Excel!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Happy Spreadsheet Day from Roy Stride (Scouting for Girls) Original Song #spreadsheetday #excel

Posted on by Annie D

To celebrate Spreadsheet Day (October 17 2023), I convinced Roy Stride, frontman for Scouting for Girls to sing this little song for all spreadsheet fans everywhere!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1840.xlsx
Learn about how to extract the city name from a description using Power Query with the List.Accumulate function and a Custom Function.
Topics:
1. (00:00) Introduction
2. (00:05) What we did last video
3. (00:38)) Excel Worksheet REDUCE function to help visualize what happens in Power Query
4. (02:54) Power Query Finished Formula List.Accumulate and Custom Function
5. (04:01) Build List.Accumulate and Custom Function formula
6. (06:14) Formula for more than one city in description
7. (07:11) Summary
8. (07:33) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup #powerquery #poowerbi #extraction #records #clean #datacleaning Continue reading “Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840” →

Excel – How to Remove Lines, Borders, Gridlines, or Strikethrough #shorts #excel #walkthrough

Posted on by Annie D

Microsoft Excel Tutorial: Remove lines from Excel, whether they are borders, gridlines, or strikethrough.

In this quick and helpful Excel tutorial, we’re going to show you exactly how to clean up your spreadsheet and get rid of those pesky lines and gridlines that can clutter your view. Whether you’re dealing with borders, gridlines, or even strikethrough text, we’ve got you covered!

🔵 Borders Be Gone!
If you’re dealing with border lines that you want to remove, it’s as easy as 1-2-3. Just select the data with borders, head to the Home tab, open the Borders drop-down, and choose “No Border.” Your spreadsheet will Continue reading “Excel – How to Remove Lines, Borders, Gridlines, or Strikethrough #shorts #excel #walkthrough” →

Excel VBA Macro To Flip All Checkboxes In Excel – Episode 2629 #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Multi-select all checkboxes and flip from true to false or back.

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

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 = Continue reading “Excel VBA Macro To Flip All Checkboxes In Excel – Episode 2629 #excelhacks” →