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

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

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

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

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

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

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

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

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

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

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”

Excel – Better Checkbox Style in Excel – Quick Tips #shorts #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”

Excel Formula: Extract City Name from Description. Excel Magic Trick 1839

Download Excel File: https://excelisfun.net/files/EMT1839.xlsx
Learn about how to extract the city name from a description using the SEARCH and LOOKUP functions. Then see how to spill the formula with BYROW and LAMBDA functions.
Buy excelisfun’s book: The Only App That Matters:
Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Mr Excel Web Site: https://www.mrexcel.com/products/microsoft-365-excel-the-only-app-that-matters/

Topics:
1. (00:00) Introduction
2. (00:05) SEARCH and LOOKUP functions
3. (02:39) BYROW and LAMBDA functions
4. (03:43) Summary
5. (03:52) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #BYROW #LAMBDA #dataanalysis