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. 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. Add Get Data from Dynamic Arrays (Insiders) #FIAĪfter 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.Create nested Power Query data types (Insiders) #FIA.Add keyboard shortcut to open the Power Query editor #FIA.Ĭheck out this Excel Features Flyer to find if a specific feature is in your version of Excel 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.Ĭurious 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. Also for web users are suggested links, IMAGE function, and a new search bar in the queries pane. 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.
0 Comments
Leave a Reply. |