FPCH Admin AWS Posted June 27, 2023 FPCH Admin Posted June 27, 2023 Welcome to the June 2023 update. We celebrated Pride this month, read more on how to add a touch of Pride to your Excel here. This month we also bring you Formula Suggestions and Formula by Example for Excel web users. Use Image and Data Types in PivotTables are now available for Windows and Mac Insider users, and Generate an Accessible PDF is available to all Mac users. Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps make Excel better for everyone. Excel for web: Formula Suggestions Formula by Example Support Chart Formatting via Selection & Ribbon Buttons Move Chart Elements within Chart Player Name Manager #FIA Excel for Windows: Office Scripts (Current Channel and Monthly Enterprise Channel) Get data from Dynamic Arrays (Current Channel) #FIA Rapid Refresh (Current Channel) #FIA Guided Reapply (Current Channel) Use Image and Data Types in PivotTables (Insiders) Excel for Mac: Generate an Accessible PDF #FIA Enhanced Search Experience #FIA Use Image and Data Types in PivotTables (Insiders) Excel for web 1. Formula Suggestions Type the “=” sign in a cell or the formula bar and 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. This feature is now available for all web users who have English set as their primary language. Read more here > 2. 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. This feature is now available for all web users. 3. Support Chart Formatting via Selection & Ribbon Buttons Format your chart using the Home Ribbon Formatting controls. 4. Move Chart Elements within Chart Player Click and drag chart element and trend line equation to move them in the chart. This expands users' ability to customize how their chart looks. #FIA 5. Name Manager Create named ranges from the Name Box in Excel for the web. Users can also search in the name box for any named ranges. Excel for Windows 1. Office Scripts Automate repetitive worksheet tasks without needing any programming experience. Perform the actions you want in Excel, and the recorder will create an Office Script to replay those actions for you. Read more > Record worksheet actions using Office Scripts #FIA 2. Get Data from Dynamic Arrays Get Data from Table/Range now includes Dynamic Arrays! Select any Dynamic Array on the grid and import it using Power Query. #FIA 3. Rapid Refresh Rapid Refresh is a feature that automatically reloads the workbook in coauthoring scenarios where the user may be prompted to refresh manually. Multi-workbook support and support in Excel for Mac coming soon. Rapid Refresh experience on Win32 4. Guided Reapply Previously, when coauthoring got interrupted for one reason or another, users would have to select “Save As” (which creates another copy of the file) or “Discard” their changes to get back to the shared file. With Guided Reapply, users can review the pending changes and return to the shared file with confidence. Guided Reapply for Windows 5. Use Image and Data Types in PivotTables (Insiders) Data types and in-cell images are a powerful part of modern Excel, and now, they come intact to your PivotTable rows and columns including the same interactions you have in your source data (image cards, data type icons, data type cards, and so on). Read more > Use images and data types in PivotTables, for Windows and Mac Insiders Excel for Mac #FIA! 1. Generate an Accessible PDF Previously when you exported to PDF on Mac, there were no tags added to communicate the structure of the document so all of the content was jumbled together. Now, the PDF service automatically creates accessibility tags, which brings the experience on par with Win32. Generate an accessible PDF on Mac #FIA 2. Enhanced Search Experience (Insiders) The search experience has been revamped to provide a single place to find content from multiple sources. This function provides smart search suggestions before you type as well as supporting searching for more than just text in your document, i.e., you can also search for commands, help articles, or web results (such as definitions, media, and Bing results). Read more here > Enhanced Search Experience in Excel for Insiders Mac users 3. Use Image and Data Types in PivotTables (Insiders) Data types and in-cell images are a powerful part of modern Excel, and now, they come intact to your PivotTable rows and columns including the same interactions you have in your source data (image cards, data type icons, data type cards, and so on). Read more > Use images and data types in PivotTables, for Windows and Mac Insiders 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. Special thanks to our Excel MVP David Benaim for his contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. 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.