Excel Blog:

Welcome to our March 2024 update.

This month, export to CSV and show details in PivotTables are now available in Excel for the web. Also, creating Power BI-connected tables is available in Excel for Windows users, and Office Scripts for Office 365 E1 and F3 licenses.

Excel for Web:

1. Export to CSV
2. Show Details in PivotTables #FIA

Excel for Windows:

1. Create Power BI Connected Tables in Excel
2. Office Scripts for Office 365 E1 and F3 Licenses

Excel for Web

1. Export to CSV

The ability to export to CSV is now available to all Web users. This experience was already supported for Windows, and Mac users and we’ve now expanded this service to all Web users. Take advantage of this lightweight file format in Excel for the Web to exchange and use data between apps and across platforms. Read more here >


Export to CSV

2. Show Details in PivotTables
We've added a new button on the ribbon under the 'PivotTable Analyze' tab called Show Details, this button allows you to drill into your PivotTables. Previously, you were able to double-click a value cell in the PivotTable and create a new table to further analyze the details for that value. This button makes this existing capability easier to find and use. This functionality was already available for Web users.

Excel for Windows

1. Create Power BI Connected Tables in Excel
A new Insert Table option is now available for the Power BI Datasets pane in Excel. It enables users to create a connected table directly in Excel. This streamlines the workflow of adding data and is friendlier to more Excel users. This is now available for all Windows and Web users. Read more here >


Power BI Connected Tables

2. Office Scripts for Office 365 E1 and F3 Licenses
Starting today you can find the Office Scripts feature set in the Automate tab on the Excel ribbon. Office Scripts is an automation platform in Excel that allows users with all levels of programming experience to automate their repetitive workflows. To get started, use the Action Recorder to record the actions you take in Excel. These actions are then translated into a script that you can run at any time. No programming experience required! Read more here >


Office Scripts


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—"Give a compliment" or "Make a suggestion"..  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 X, formerly Twitter.

Special thanks to our Excel MVPs David Benaim and Bill Jelen for their 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. Bill is the founder and host of MrExcel.com and the author of several books about Excel.

 Source:

https://techcommunity.microsoft.com/...4/ba-p/4089056

Posted By: Brink
26 Mar 2024