We are happy to announce that Office Scripts in Excel is now available for customers with Office 365 Enterprise E1 and Office 365 F3! Starting today you can find the Office Scripts feature set in the Automate tab on the Excel ribbon.     What is Office Scripts?  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 progr ..read more

Welcome to the February 2024 update. This month, we are excited to share that the Chart data task pane and the ability to use images and data types in your PivotTables are now available in Excel for the web. The new default theme for Office is generally available in Excel for Windows and Mac now as well.  Excel for Web: Chart Data Task Pane  Images and Data Types in PivotTables Excel for Windows: New Default Theme for Office Excel for Mac: New Default Theme for Office   Excel for Web 1. Chart Data Task Pane You can now use the data task pane to edit your chart's data on ..read more

Happy 2024!! Welcome to our first update of the year, the January update. This month, we are excited to share that users can now sync form data to Excel for the web. Insert pictures into cells is available to users of Excel on Windows and Mac, and PivotTables has expanded functionality in Excel for iPad. Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. Excel for Web: Sync Forms Data to Excel Date Picker #FIA Excel for Windows: Insert Pictures in Cells #FIA Check Performance Excel ..read more

We are excited to announce support for PivotTable creation and editing on iPad. PivotTables allow you to calculate, summarize, and analyze data. We have tailored this powerful tool for the iPad's smaller screen and touch interface. Now, you have the flexibility to move seamlessly between desktop, web, and iPad while maintaining a consistent experience across the board. Unleash the full potential of PivotTables, making every calculation and analysis simple on the go.    1. Create a PivotTable  To get started, navigate to the Insert tab, select PivotTable, and choose a Source ..read more

As we wrap up 2023, we on the Excel team want to express our heartfelt gratitude to you all across our Excel community. We greatly appreciate each and every one of you for your continued contribution to the community, helping others learn more about Excel, and giving us feedback to make Excel even better.   2023 was filled with excitement for Excel, from Excel esports on ESPN8: The Ocho to the Excel Collegiate Challenge, the Excel World Championship, and more.   Excel esports on ESPN8: The Ocho. For the second year in a row, Excel esports returned to ESPN8: The Ocho, joini ..read more

Have you ever found yourself tangled in a web of complex Excel formulas, desperately trying to pinpoint the source of an error? Fret no more! The latest experiment from Excel Labs is a new formula debugger, available within the Advanced Formula Environment (AFE).   The AFE debugger Getting started The debugging capabilities are activated using the new button on the Grid page in AFE. When the button is activated the debugger will be visible in the same editing pane, and you are ready to go!   Key features Here are some of the key features to look out for:   - Live debugging ..read more

Welcome to the November 2023 update. This month we are excited to share a number of new features rolling out across Excel for the web, Windows, and Mac. GROUPBY and PIVOTBY, and Export Loop Tables to Excel are both available to Windows and Mac Insiders. Trendline Equation Formatting is now out to all web users, and Workbook Links are now live for Windows 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: Trendline Equation Formatting   Excel ..read more

November 14th 2023 Status These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel    I’m excited to announce Excel's new GROUPBY and PIVOTBY functions. These functions allow you to perform data aggregations using a single formula. And while these functions are extremely powerful, they are also simple to get started with. In fact, you can do a data aggregation with just 3 arguments, the same number as a simple XLOOKUP.    Note: These are preview functions, their signature and results may change substantia ..read more

Happy Halloween to those who celebrate!   Welcome to our October 2023 update! This month we are excited to share several new features rolling out across Excel for the web, Windows, and Mac. The Automate Work button, Formula Authoring Enhancements, and Queries and Connection Pane are now available in Excel for the web. Web Connector Enhancements and Optimized Narrator Screen Announcements have started rolling out to users of Excel for Windows; and Checkboxes in Cells and the ability to control your Data Conversions, to Insider users [on Excel for Windows]. Many of these features are ..read more

What is the Web connector for Excel?   The web connector for Excel (AKA Get Data From Web) is a powerful tool that allows you to connect to websites and import data into your Excel workbook. The Web connector leverages the strength of Power Query in Excel to import data. You can also refresh your data connection to get the latest updates from the selected websites.   Note: The new Web connector will be available in Excel for Windows.  We have plans to support Excel for Web and Excel for Mac in the future.   What's new in the improved connector for Excel?   We are excit ..read more