FPCH Admin AWS Posted August 31, 2022 FPCH Admin Posted August 31, 2022 (edited) Welcome to the August 2022 update. This month, we have many new features rolling out to Insiders and many more becoming generally available (GA) across web, Windows, and Mac. New functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now GA; and the IMAGE function to insert images in cells is rolling out to the Beta channel for Insiders. Check out this Excel Features Flyer to find if a specific feature is in your version of Excel Excel for the web New Excel Functions Power Query Group operations Improvements to the connected Power BI experience Add and edit rich text formatting Sort by color or icon from auto filter menu Edit files with legacy data connections Edit files with legacy Shared Workbook feature Delete chart elements Multiline formula bar Excel for Windows New Excel Functions IMAGE function (Insiders Beta) Improvements to the connected Power BI experience (Insiders Beta) Show Changes (Insiders CC Preview) Excel for Mac New Excel Functions IMAGE function (Insiders Beta) Show Changes (Insiders CC Preview) Android New Excel Functions IMAGE function (Insiders Beta) iOS New Excel Functions IMAGE function (Insiders Beta) Excel for the web New Excel Functions 14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more > Text manipulation Power Query Group operations You can now perform various operations on Power Query groups to better organize your queries and easily consume the data on the queries pane. Read more > Power Query group operations Improvements to the connected Power BI experience In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more > Power BI connected PivotTable Add and edit rich text formatting Rich text formatting allows the user to add formatting to only part of the text within a cell. You can use the ribbon or shortcuts to add the formatting. Edit rich text Sort by color or icon from auto filter menu Sorting is now easier and more convenient with new sort-by-color or icon options. Sort by color or icon from auto filter menu Edit files with legacy data connections You can now edit files that contain legacy data connections like Text Queries, Web Queries, Query Table, or SharePoint Lists. This enables interaction with the workbook and access to the previously stored data from these connections, but without interaction, modification, or refreshing of the connections themselves. We recommend switching to import data via Power Query to connect and refresh data. Edit files with legacy data connections Edit files with legacy Shared Workbook feature You can now edit files that use the legacy shared workbook feature, with a provision for one-click turn-off of the legacy feature, thus allowing you to interact and collaborate with the workbook. Edit files with legacy Shared Workbooks Delete chart elements Deleting a data series from charts is now easier by selecting a series and pressing the delete/backspace key to remove it. Delete chart elements Multiline formula bar Users can now expand and collapse the formula bar by using the chevron or manually resizing it. This capability Improves the readability of long formulas or text Multiline formula bar Excel for Windows New Excel Functions 14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are rolling out to users in the Current Channel. Read more > IMAGE Function (Insiders Beta) 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 > Insert Image Function Improvements to the connected Power BI experience (Insiders Beta) In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more > Show Changes (Insiders CC Preview) Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more > Show Changes Excel for Mac New Excel Functions 14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more > IMAGE Function (Insiders Beta) 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 > Show Changes (Insiders CC Preview) Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more > 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. Check out this Excel Features Flyer to find if a specific feature is in your version of Excel :) Continue reading... Edited September 1, 2022 by AWS Quote Off Topic Forum - Unlike the Rest
FPCH Staff Tony D Posted September 1, 2022 FPCH Staff Posted September 1, 2022 It's not your dad's Excel anymore. 1 Quote
Recommended Posts