Product Manager on Microsoft Excel. Grid's for the win.
Seattle 🇦🇺🇿🇦🇳🇦🇮🇪
Joined June 2009
- Tweets363
- Following388
- Followers1.5K
- Likes610
Pinned Tweet
One of the oldest rules of spreadsheets: one cell, one value. No longer!
I’m excited to announce a set of new features: Lists, Arrays in Cells and Nested Arrays in Excel 🎉
Here’s a quick demo👇
Want to learn more about how this changes Excel? Blog post link in comments
Joe McDaid retweeted
Yeah, so I helped the Excel team with this. Excited that it's out! techcommunity.microsoft.com/…
Joe McDaid retweeted
Python in Excel is now a thing! Python is now a peer of the Excel formula language and you can mix both languages seamlessly in the Excel grid. Python runs on Azure and is powered by the @anacondainc Python distribution.
This was a multi-year collaboration between the Python team in Developer Division and the Excel team. It was a privilege of a lifetime to work daily with @gvanrossum @ahejlsberg @keyurp32 @jjmcdaid @zooba @iritkatriel @oterocarlos and a few other folks who don't use this site.
techcommunity.microsoft.com/…
I'm excited to announce that the latest set of Excel functions are generally available. 🎉 They simplify common text manipulation tasks and unlock dynamic array scenarios.
TEXTBEFORE/AFTER, TEXTSPLIT, EXPAND, TAKE, DROP, V/HSTACK, CHOOSEROWS/COLS, TOROW/COL and WRAPROWS/COLS.
We are bringing 14 new functions to Excel. These functions will help you manipulate text and arrays via formulas. TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK,TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, EXPAND, CHOOSEROWS and CHOOSECOLS techcommunity.microsoft.com/…
🆕Today we rolled out lambda function support to Excel users on the current channel. If you use dynamic arrays, I'd recommend starting with BYROW and BYCOL which can be used to aggregate rows/columns and spill the results. techcommunity.microsoft.com/…
Solve your Wordle using Excel and Dynamic Arrays. Great video @MrExcel! youtube.com/watch?v=qUpGwORQ…
Desmond Tutu passed away today. 🕊He fought for an apartheid free South Africa and was central to the reconciliation effort. An inspirational human being, with a great sense of humor and an infectious laugh. He will be missed. #DesmondTutu
Joe McDaid retweeted
From the interview with Joe McDaid around 1:46:10: "Excel is a programming language. It's a functional programming language, if you want to get technical, but it's the world's largest programming language by user base." 👏👏👏
This is awesome. I'll be lining up to buy a copy of Tommy's next album "Music for fellow nerds" as soon as it drops.
Today @msexcel fans, Tommy Tutone sings about a formula to search in reverse in #Excel ! This could be his biggest hit since 867-5309 #Jenny youtube.com/watch?v=6a3jFF5e…
We would love to hear about your experience importing data from websites into Excel. If you'd like to share and help make Excel better, please reach out to my colleague Jakob. 👇
Are you downloading data from websites and importing the data using files into Excel for analysis? We are curious about your experience and how we can make Excel better meet your needs. Message me, if you are interested. #data #excel #powerquery #ux #userexperience
@Patrick_Spence This 3rd party app is masquerading as the Sonos app in the App Store by paying for an ad and appearing 1st. All written reviews are from confused Sonos users disappointed at Sonos for needing to pay. Sad to see the App Store profit from this poor behavior.
We just announced a new wave of lambda functions. If you like dynamic arrays, you are going to love BYROW and BYCOL -- they allow you to aggregate rows/columns and have them spill. 💯techcommunity.microsoft.com/…
Wooo! PowerQuery comes to Excel for Mac.
#PowerQuery on #Mac for #Excel has been a key user request and great to see us get to this point. Many kudos across both the teams to enable this with this partnership. @mspowerquery @msexcel #dataprep lnkd.in/g6-bjcx
Carlos from the #Excel team has an open role! If you have a passion for Excel & data analytics, check it out. 👇
My team is hiring! Help shape the future of #Excel and impact 100s of millions of people. We are looking for a strong product leader with experience at the intersection of data analytics and product management. Details: careers.microsoft.com/us/en/…
ALT Building Excel
The Excel team will be doing an AMA on March 10th @ 10am PT. I'll be there to help answer questions about Excel formulas, functions and the calculation engine. Come join us.
We're here with open ears 👂, ready to answer your #Excel questions! msft.it/6015pfmkB
ALT A tablet screen showing Microsoft Teams on the screen laying on a green desk next to a succulent plant and mug of coffee
Joe McDaid retweeted
Excel formulas, the world’s most popular programming language, is now Turing-complete. Go check it out!
Excel keeps evolving to give users even more. Now, with the power of LAMBDA, you can write your own reusable functions with the Excel formula language. See how we're transforming Excel: msft.it/6014pF2Oa
ALT A graphic showing the Excel LAMBDA function, a custom formula without code