Happy to share an in-depth review of the capabilities of Formula by Example - the next-gen of Flash Fill - It will save you time by suggesting formulas to auto-fill your data. Huge thanks to the amazing team at Microsoft who made this dream come true.
https://t.co/wxUAsj3IrH
10 Microsoft Excel shortcuts to learn ASAP:
(I'm an Excel expert and these 10 shortcuts will save you hours of time & increase your productivity 10x):
1) AutoSum: Alt + =
2) Create pivot table: Alt + N, V
3) Insert todays date: Ctrl + ;
📊4-10:
More than 1 Billion people use Microsoft Excel.
But, most of you barely know what it's capable of.
Here are 10 Excel features that'll save you hundreds of hours of your life:
Big news, #OfficeInsiders: We heard your requests for the ability to clean and shape data 📊 using the Power Query Editor in #Excel for Mac.
Now it’s here!
👉 Try out the full Power Query experience, ONLY for Office Insiders, and see for yourself: https://t.co/rB22tNeAhT
Interested in helping to shape the future of Excel? Please contribute to our Microsoft Research project that aims to anonymously crowdsource data from which we can learn how to build technology that can respond to any question - https://t.co/znHKTPijGS
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 https://t.co/ZmnlzrL5bm
Hello folks.. I am doing a 🔴live stream on "Statistical Analysis with Excel". If you significantly interested in this, come & say hello here. Bring a cup of coffee (or something strong) as this is not your average stream. https://t.co/DDvuc55rUd
Woohoo! Now you can export data from the #AzureDataExplorer as a live excel table that you can refresh directly from the source.
Power your excel files easily with live data from #Kusto
https://t.co/40iyi2jdiZ
Wrote a new tutorial on how to embed excel workbooks on your website in no time. If you run a blog and want to increase user engagement - this is for you https://t.co/1lqbLn0I1n
🆕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. https://t.co/wBrQjl4VsH