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

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.

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

Microsoft Excel Tutorial: Better looking checkboxes in Excel.

📊 Want to upgrade the look of your Excel checkboxes? In October 2023, a new Checkbox icon was introduced on the Insert tab. While it offers a convenient way to toggle checkboxes using your mouse or the spacebar, it can feel a bit cluttered.

👉 In this quick tip, discover a sleeker alternative! Learn how to add checkboxes and then make them disappear with a simple press of the Delete key. They’ll reappear when you hover over the cells, and with a click or spacebar press, you can easily turn them on.

🔘 However, keep Continue reading “Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks” →

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 Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →

Microsoft Excel Tutorial: Modeling the rest of the MLS Season 100,000 times.

Which teams are still in the hunt for the MLS Supporters Shield?

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/