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.
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!
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”
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.
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: 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”
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: Checkboxes arrive in Microsoft Excel
To download the workbook from today: https://www.mrexcel.com/youtube/kunbe45v7-E/
In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.
Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the “Insert” tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true Continue reading “Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628”
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/
Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.
Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.
To download the workbook from today: https://www.mrexcel.com/youtube/UKpmNAMjygg/
This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today’s video.
#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Continue reading “Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625”