Month: October 2023

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

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

Escape the Ordinary with a Low Code Lakehouse in Microsoft Fabric

Posted on by Annie D

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

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.

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

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!

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.

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.

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