Carlos Otero
@oterocarlos
Followers
919
Following
789
Media
77
Statuses
837
#Excel Team @Microsoft. Creating experiences that help people make sense of data. Previous stints in corporate strategy and finance
Seattle
Joined September 2009
Yeah, so I helped the Excel team with this. Excited that it's out!
285
3K
15K
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
54
393
2K
It's been awesome partnering with @anacondainc on this project. I am excited to provide access to Anaconda Distribution for Python directly within #Excel.
1
0
6
Microsoft is bringing Python to Excel. The two worlds of Excel and Python are colliding thanks to Microsoft’s new integration to boost data analysis and visualizations. Details here:
theverge.com
Python code will run on Microsoft’s Cloud.
53
278
2K
We built a thing! #Python in #Excel - now in preview, brings the best of Python analytics straight to the Excel grid. I cannot wait to see what our community builds leveraging pandas, matplotlib, scikit-learn, and more! See: https://t.co/AzsFNImvxz
5
37
134
My team is #hiring! Help shape the future of #Excel and impact 100s of millions of people around the world. We are looking for a creative product leader with an entrepreneurial spirit to help us build and grow data analysis user experiences at scale. You… https://t.co/8xfWqH6Gbv
0
0
2
Love this!
Today on Decoder: Kat Norton, the Microsoft Excel influencer making up to six figures *a day* selling Excel tips and tricks. This one... goes places. I loved it. https://t.co/0Q3vekDZ9i
0
0
2
More #Excel + #PowerBI news! We are broadening availability of recent integration features to support customers with Premium Capacity + PBI Free. This means more people will now be able to analyze PBI data in Excel, w/o having to leave Excel! See details: https://t.co/ZCN5Kjuzle
techcommunity.microsoft.com
Connected PivotTables and Organization data types coming soon for users with Power BI free licenses
2
23
66
Note that these updates will sit at this stage for a bit while we react to any feedback and complete the equivalent work in Excel for the web (being tested internally right now). This is a particularly complex area in the code base, so testing and feedback are appreciated!
0
0
4
Of course, having explicitly defined DAX measures in the underlying dataset is still a best practice for more complex calculations. The challenge here is that most folks interacting with the PivotTables might not have access or know how to create the measures in the first place.
1
0
3
This means that PivotTables connected to #PowerBI datasets will now support drag-and-drop aggregation of fields (e.g. sum, average, distinct count, etc.). This helps you to quickly get answers within Excel without needing pre-defined measures in the underlying Power BI datasets.
1
0
7
Quick update on the #Excel + #PowerBI integration front. The Windows specific updates mentioned in this post (e.g. drag and drop aggregations) are now available to the Current Channel Preview (aka Insiders Slow). Please test these out and send us feedback! https://t.co/LRAP3XsLPZ
techcommunity.microsoft.com
Power BI connected PivotTables in Excel for the web now available
2
7
13
Love this! Excited to see what else you cook up at the intersection of Cube Functions, #Excel Lambdas, and Dynamic Arrays!
#Excel cube functions, dynamic arrays and lambdas, Part 1: getting all the items from a set #PowerBI #PowerPivot #SSAS
0
0
2
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. 💯 https://t.co/BtckTipH70
techcommunity.microsoft.com
Excel has new LAMBDA functions
5
13
48
Modern #Excel templates powered by Data Types for the win! You can find more of those here:
0
5
11
Awesome overview @wynhopkins! Excited to see what folks build with these new capabilities. I hear you on the access friction - still some more to go to polish the experience.
1
2
12
Connected PivotTable Refresh in Excel for the web is now 100%available to all Office users. @jeroenterheerdt
@lukasztweets
#PowerBI #PivotTable #Excel #Microsoft #dataculture #PowerBIandExcel
https://t.co/RSlgXeTrlp
powerbi.microsoft.com
We are excited to announce that connected PivotTable refresh in Excel for the web is now 100% available to all Office tenants. This feature is part of a broader investment to enable seamless and...
0
9
23
Quick update on the #PowerBI + #Excel front! The ability to interact and refresh PBI PivotTables in Excel for the web should now be available to 100% of eligible users. Thank you for the patience and feedback as we addressed issues with the initial release.
I am happy to share we have started the rollout of #PowerBI connected PivotTables in #Excel for the web. This means that interacting with and refreshing PivotTables connected to Power BI Datasets in a browser will now be supported. #MSBizAppsSummit
https://t.co/hTAoJl2jVR
2
11
28
#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
linkedin.com
#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...
0
4
10