Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.Microsoft Excel, the spreadsheet app, lets you create, view, edit, and share your files quickly and easily. You can also submit new ideas or vote for other ideas via Microsoft Feedback. Please let us know how you like a particular feature and what we can improve upon- send us a smile or frown. Your feedback helps shape the future of Excel. Read more >Ĭheck if a specific feature is in your version of Excel Click here to open in a new browser tab This function is currently rolling out to Mac users now. You can move and resize cells, sort, and filter, and work with images within an Excel table. The IMAGE function inserts images into cells from a source location, along with the alternative text. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort, and filter, and work with images within an Excel table. The IMAGE function is rolling out to Current Channel users now. This feature is currently rolling out to Windows Production. Get Data from Table/Range now supports importing data from Dynamic Arrays – so you can load them into Power Query and transform your data. This feature is currently rolling out to Insiders users for Windows.Ĭreate nested Power Query data types #FIAĪdd Get Data from Dynamic Arrays (Insiders) Organize your data even better, by creating nested data types ( Power Query Data Types with multiple levels). Press Alt + F12 (Win32) or Option + F12 (Mac) to open the Power Query Editor quickly.Ĭreate nested Power Query data types (Insiders) Read more >Īdd keyboard shortcut to open the Power Query editor This feature is rolling out to production for web users.Įasily find your queries within the Queries search pane. There is currently only support for the English language. Formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX.
0 Comments
Leave a Reply. |