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.
A lakehouse can be intimidating especially if you don’t know Python. Patrick looks at a low-code, potentially no-code option for creating a lakehouse in Microsoft Fabric to get you going!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – <a Continue reading “Escape the Ordinary with a Low Code Lakehouse in Microsoft Fabric”
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.
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”
Step into the adrenaline-charged world of sports data analysis. This freestyle session will immerse you in a spontaneous exploration of sports data, showcasing how modern analysts interpret, visualize, and narrate compelling athletic stories.
Dive into a dynamic exploration of financial data in the modern era. This freestyle session offers a refreshing and unscripted approach to understanding, interpreting, and visualizing financial data using the latest tools and techniques.
Embark on a holistic learning journey that integrates AI, Excel, Power BI, and Python. This event is designed to provide a unified approach to mastering these powerful tools, helping you harness their combined potential.
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”