Update New Excel features added by Microsoft in 2022

[silversurfer]

Excel for the web

• Sheet protection
• “PivotTable Connections” in slicer settings pane
• Semi-select for links creation

Excel for Windows

• Data from Picture (Insider Beta)
• Automatic alt text suggestions on charts and PivotCharts (Current Channel & Monthly Enterprise Channel)

Excel for Mac

• Automatic alt text suggestions on charts and PivotCharts
• Import from local text, CSV, and XLSX files with data preview

What's New in Excel (June 2022)

Welcome to the June 2022 update. We are excited to share the general availability of sheet protection and semi-select for links creation in the web for Excel for the web and automatic alt text suggestions for charts and PivotCharts across Excel for Windows and Excel for Mac - among other...

techcommunity.microsoft.com

 

[silversurfer]

Excel for the web

• Search for fields in PivotTable field List

Excel for Windows

• Control automatic data conversions (Insiders Beta)
• Natural Language Query improvements (Current Channel & Monthly Enterprise Channel)

Excel for Mac

• Natural Language Query improvements
• Resizable Conditional Formatting dialog (Insiders Beta)

What's New in Excel (July 2022)

Welcome to the July 2022 update. We are excited to announce Excel Live, an enhanced collaboration solution for working on Excel workbooks in real time with your Teams meetings. Read more > Also we want to share the general availability of Natural Language Query improvements in Excel for...

techcommunity.microsoft.com

 

[silversurfer]

Microsoft has confirmed that it is rolling out “@mentions” for its spreadsheet software. Users of Microsoft Excel workbooks will soon have the ability to tag colleagues or team members.

In the entry on the official Microsoft 365 roadmap, the company notes that @mentions can be used to "create, assign and track tasks within your workbook." The entry indicates the feature has a General Availability (GA) date of October 2022. However, the feature has already been added to the "rolling out" cycle. This means some users who have updated their Microsoft Office suite may already be able to use the feature to tag people.

It is important to note that only the desktop iteration of Microsoft Excel will get the feature for now. However, the feature will be rolled out to users across the world.

Microsoft Excel to get @mentions to tag team members and assign tasks

Microsoft Excel will have the ability to tag users using the @mentions feature. Only the desktop iteration of the spreadsheet software is getting the feature, for now, indicated Microsoft 365 roadmap.

www.neowin.net

 

[silversurfer]

Microsoft has announced a new function for Excel, thus addressing a popular request to let users insert images directly into cells. The IMAGE function is now available in preview versions of Excel on Windows, macOS, iOS, and Android.

Inserting images into cells instead of floating on top unlocks many new scenarios, such as tracking inventories, creating employee dashboards, or building games and brackets. In addition to mere image insertion, the IMAGE function supports additional properties for better customization and accessibility. You can add alt text and specify size, width, and height.

Excel gets new function for inserting images into cells

Excel has received a new function responsible for inserting images directly into cells. The IMAGE function is now available for Office Insiders on Windows, macOS, iOS, and Android.

www.neowin.net

 

[silversurfer]

What's New in Excel (August 2022)​

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)

What's New in Excel (August 2022)

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...

techcommunity.microsoft.com

 

[silversurfer]

Microsoft appears to be in a mood to make Office Scripts support for Excel more accessible. A few months ago, it added the ability for the team members of a SharePoint site to easily collaborate, view, and run team-owned scripts on their Excel workbooks. However, Office Scripts, an automation feature-set, is currently limited to Excel for the web. This will change next month, as Microsoft promises to bring it to more platforms, namely Mac and Windows.

According to Microsoft 365 Roadmap page, Excel users on Mac and Windows will be able to automate their repetitive spreadsheet tasks come October. Users will be able to create, edit, and run Office Scripts in Excel for Windows and Mac using the Code Editor and All Scripts taskpane, exactly like Excel for the web.


The ability to create, edit, and run Office Scripts in Excel will be very useful, especially in workplaces. You can easily automate your day-to-day tasks, which means you do not have to worry about forgetting steps. However, you have to wait patiently until October to use it on Excel for Mac or Windows. You can learn how Office Scripts work on Excel for the web here.

According to the roadmap page, the automation feature-set will be available as a preview first in October. Microsoft also promises general availability in the same month. Although not confirmed, a preview of the automation feature-set will likely be available for Office Insiders early next month. And it may have a broader rollout in the middle or late October. Worse, Microsoft could also postpone it as well.

Excel users on Mac and Windows will soon be able to automate repetitive tasks

Microsoft is working on a new feature to enable Excel users on Windows and Mac to automate their repetitive tasks. The functionality is already available for the Microsoft Excel web client.

www.neowin.net

 

[silversurfer]

Excel for the web

• Check performance
• Sharing a section of Excel workbook
• Dynamic array support in charts

Excel for Windows

• Modern comments
• Dynamic array support in charts (Insiders Beta)

Excel for Mac

• Shape data with Power Query Editor (Insiders Preview)
• Manage your storage accounts (Insiders Preview)

What's New in Excel (September 2022)

Welcome to the September 2022 update. We are excited to announce the release of Check Performance for Excel web users to help speed up your workbooks and modern comments for Windows users to allow for a more streamlined commenting experience across products. For Insiders using Mac, you can now...

techcommunity.microsoft.com

 

[silversurfer]

Excel for the web:

• Quickly Find the Command you need

Excel for Windows:

• Automate Tasks with Office Scripts (Insiders Beta)
• Navigation Pane
• Quickly Find the Command you need
• New DAX Functions in Excel Data Models and Power Pivot (Insiders Beta)
• New Paste Options when using keyboard shortcuts (Insiders Beta)

Excel for Mac:

• Automate Tasks with Office Scripts (Insiders)

What's New in Excel (October 2022)

Welcome to the October 2022 update. This month, we had Microsoft Ignite taking place on October 12-14 - check out this What's New in Excel video from our team. Also, Navigation Pane is now generally available (GA) on Excel for Windows - GA coming soon on Excel for Mac. For Windows and Mac...

techcommunity.microsoft.com

 

[silversurfer]

Excel for the web:

• Chart Data Foils

Excel for Windows:

• Show Changes #FIA
• Automate Tasks with Office Scripts

Excel for Mac:

• Show Changes #FIA
• Automate Tasks with Office Scripts

iOS:

• Get Fast and Fluent for Office on iPhone (Insiders)

What's New in Excel (November 2022)

Welcome to the November 2022 update. We are excited to announce the release of two features that are now generally available (GA) to all Excel users on Windows and Mac - Show Changes and the ability to Automate Tasks with Office Scripts. For our web users, Chart Data Foils allows you to see a...

techcommunity.microsoft.com

 

[silversurfer]

Welcome to the December 2022 update. 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. Also for web users are suggested links, IMAGE function, and a new search bar in the queries pane. 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.

Excel for the web:

• Formula Suggestions
• Formula by Example
• Suggested Links
• Add search bar in queries pane
• IMAGE Function

Excel for Windows:

• Add keyboard shortcut to open the Power Query editor #FIA
• Create nested Power Query data types (Insiders) #FIA
• Add Get Data from Dynamic Arrays (Insiders) #FIA
• IMAGE Function

Excel for Mac:

• IMAGE Function

What's New in Excel (December 2022)

Welcome to the December 2022 update. 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. Also for web users are suggested...

techcommunity.microsoft.com

 

[silversurfer]

Microsoft has rolled out several updates over the last month aimed at improving at fixing various features and issues. Of particular note are updates to Microsoft Excel’s famous formulas feature, which will make them easier to use and more powerful to boot. The updates have also addressed issues relating to broken links and functionality relating to adding images to spreadsheets.

These updates will be especially useful for web users, who include all Microsoft 365 (previously known as Office 365) users, even those without access to the full desktop client. Some updates will also be available for Windows and macOS client users.

Microsoft Excel update makes formulas more powerful and more accessible - gHacks Tech News

Microsoft has rolled out several updates over the last month aimed at improving at fixing various features and issues. Of particular note are updates to Microsoft Excel’s famous formulas feature, which will […]

www.ghacks.net

 

[silversurfer]

The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.

With this new tab, create and modify scripts that automate your repetitive tasks using Office Scripts. Enhance your workbook by connecting popular applications like Microsoft Teams or SharePoint to build workflows with Power Automate. Combine these productivity technologies to have Power Automate schedule your Office Script. This tab represents the first stage of uniting automation solutions across platforms. We’re eager to hear your feedback!

Automate your tasks with the Automate tab—now in Excel for Windows and Mac

The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web. With this new tab, create and modify scripts that...

techcommunity.microsoft.com

 

[silversurfer]

Welcome to the January 2023 update. This month we are excited to announce the release of PivotTable show details to Excel for the web and the ability to automate your tasks with the Power Automate tab in Excel for Windows and Mac. For Insiders users on Windows and Mac, you can try recording your worksheet actions using Office Scripts and checking your formula with the value preview tooltip.

Curious 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.

Excel for the web:

• PivotTable show details #FIA

Excel for Windows:

• Automate your tasks with the Power Automate tab
• Record worksheet actions using Office Scripts (Insiders)
• Check your formula with value preview tooltips (Insiders)

Excel for Mac:

• Automate your tasks with the Power Automate tab
• Record worksheet actions using Office Scripts (Insiders)
• Check your formula with value preview tooltips (Insiders)

PivotTable show details

View the source data for a PivotTable value cell, now in Excel for the web. Double-click or right-click and choose Show Details from a value cell in your PivotTable to create a new sheet with the detailed rows for that cell. There is also a new button to activate the same functionality from the PivotTable tab of the ribbon.

Show Details is useful to help you understand how the values in your PivotTable were calculated. For example, if you see an unexpected value in your PivotTable, you can use Show Details to confirm whether the source data used to calculate that value is as expected or if there is an issue with the underlying data.

What's New in Excel (January 2023)

Welcome to the January 2023 update. This month we are excited to announce the release of PivotTable show details to Excel for the web and the ability to automate your tasks with the Power Automate tab in Excel for Windows and Mac. For Insiders users on Windows and Mac, you can try recording your...

techcommunity.microsoft.com

 

[silversurfer]

Welcome to the February 2023 update. This month we are bringing the ability to manually sort row and column values in PivotTables to users of Excel for the web. For Insiders, those using Excel for Windows can check out automatic recalculation optimization and blocking untrusted XLL add-ins; and those using Excel for Mac, Power Query Editor to import data from SQL Server databases - as well as from additional sources such as SharePoint, local files, OData, and many others.

Curious 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.

---

Excel for the web:

• PivotTables: Manual sort (drag) of rows and column values

Excel for Windows:

• Automatic Recalculation Optimization (Insiders)
• Block untrusted XLL Add-Ins (Insiders)

Excel for Mac:

• Power Query Editor
• Import Data from Additional Sources
• Import Data from SQL Server Databases (Insiders) #FIA
• Automatic Recalculation Optimization (Insiders)

What's New in Excel (February 2023)

Welcome to the February 2023 update. This month we are bringing the ability to manually sort row and column values in PivotTables to users of Excel for the web. For Insiders, those using Excel for Windows can check out automatic recalculation optimization and blocking untrusted XLL add-ins; and...

techcommunity.microsoft.com