FPCH Admin AWS Posted December 20, 2022 FPCH Admin Posted December 20, 2022 Welcome to the December 2022 update. We are excited to announce the release of Formula Suggestions and Formula by Example for Excel web users - a couple exciting capabilities designed to help save you time and learn more about Excel formulas as you use them. Also for web users are suggested links, IMAGE function, and a new search bar in the queries pane. For Windows users, a new keyboard shortcut is available to open the Power Query editor, and Insiders users on Windows can now get data from dynamic arrays and create nested Power Query data types to better organize your data. Curious to see how we at Excel utilize and implement your feedback? You can now see which features are a direct result of your feedback as they'll be marked with the Feedback In Action tile #FIA. Check out this Excel Features Flyer to find if a specific feature is in your version of Excel Excel for the web: Formula Suggestions Formula by Example Suggested Links Add search bar in queries pane IMAGE Function Excel for Windows: Add keyboard shortcut to open the Power Query editor #FIA Create nested Power Query data types (Insiders) #FIA Add Get Data from Dynamic Arrays (Insiders) #FIA IMAGE Function Excel for Mac: IMAGE Function Excel for the web Formula Suggestions After you type the “=” sign in a cell or the formula bar, Excel will auto-suggest the best formula based on contextual insights from your data. Formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. There is currently only support for the English language. This feature is rolling out to production for web users. Formula by Example As you are performing manual and repetitive data entry in a column, Excel will now suggest you to fill the entire column with a formula in case we identify a pattern. This is similar to Flash Fill, however, instead of static text - now formulas can be suggested. Suggested Links Suggested Links allow for new cloud workbook storing for data that detects when an external link to a Cloud workbook is broken and suggests you a new location to fix the broken link. This feature is currently rolling out to Production. Add search bar in queries pane Easily find your queries within the Queries search pane. Search bar in queries pane IMAGE Function 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. Read more > IMAGE Function Excel for Windows #FIA Add keyboard shortcut to open the Power Query editor Press Alt + F12 (Win32) or Option + F12 (Mac) to open the Power Query Editor quickly. #FIA Create nested Power Query data types (Insiders) Organize your data even better, by creating nested data types (Power Query Data Types with multiple levels). This feature is currently rolling out to Insiders users for Windows. Create nested Power Query data types #FIA Add Get Data from Dynamic Arrays (Insiders) 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 Windows Production. IMAGE Function 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. Read more > IMAGE Function Excel for Mac IMAGE Function 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. This function is currently rolling out to Mac users now. Read more > IMAGE Function Check if a specific feature is in your version of Excel Click here to open in a new browser tab Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown. You can also submit new ideas or vote for other ideas via Microsoft Feedback. 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. Continue reading... Quote Off Topic Forum - Unlike the Rest
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.