Excel's exciting June 2023 updates: Check these new features to boost your productivity

Microsoft has introduced several valuable additions to Excel in June 2023, catering to various user needs to boost productivity.

| Updated on: Jul 02 2023, 09:41 IST
Microsoft shares crucial tips to guard against cyber attacks
image caption
1/6 One of the most popular ways to steal information is ‘Phishing’. Phishing emails and websites created to attack corporate targets only need to succeed once to gain credentials that can be sold to and shared with other bad actors.  (Microsoft)
2/6 Another way is 'Push-bombing,' which is an attack that triggers multiple access attempts with stolen credentials. It causes a rush of push notifications and can confuse the user and cause them to mistakenly allow authentication. So, how you can avoid such scenarios? (Pexels)
image caption
3/6 First, always use Multi-Factor Authentication (MFA) with "Number Matching" or similar functionality. This also includes accepting a push notification and inputting a matching number.   (Pexels)
image caption
4/6 To regain control and ensure security, isolation plays a vital role by enabling strict control of communications and access between security zones. Without proper isolation, the security model becomes ineffective. Therefore, remote administration necessitates a computer within the same security zone. (Unsplash)
image caption
5/6 Keep your operating systems updated and maintain secure administrative practices. (Unsplash)
image caption
6/6 Finally, implement comprehensive centralized log collection with a well-defined retention policy.   (Pixabay)
icon View all Images
Microsoft adds exciting new features to Excel in June 2023. (Microsoft)

Microsoft Excel continues to be a powerhouse tool used in both business and personal settings, catering to data crunching, visualisation, testing, documentation, and planning needs. To stay at the forefront of user requirements, Microsoft consistently enhances Excel with new features. Let's take a closer look at the updates.

For Excel on the web, users can now save time with recommended formulas that pop up when typing the "=" symbol in the formula bar. Although limited to basic formulas like SUM, AVERAGE, COUNT, and others, this feature presents contextualised insights. Additionally, users working with data containing a pattern will benefit from formula suggestions for entire columns, offering dynamic formulas instead of static text, setting this apart from traditional Flash Fill. These functionalities are currently available to users with English as their primary language.

Visualisations in Excel for the web have received an upgrade, allowing users to format charts using the controls in Home Ribbon Formatting. Additionally, chart elements can be moved within the chart, allowing for greater customization options. A highly-requested feature, the Name Manager, has been reintroduced, allowing users to assign names to selected cell ranges easily.

For Excel on Windows, Current Channel and Monthly Enterprise Channel members can now leverage Office Scripts, enabling them to record actions and automate repetitive tasks. Furthermore, Current Channel customers can use Guided Reapply while co authoring an Excel file. This feature streamlines the process of handling interruptions during editing, providing the option to save a copy of pending changes or revert to previous versions.

Current Channel users also have access to "Feedback in Action (#FIA)" features, including Dynamic Arrays from the Get Data option in Power Query, Rapid Refresh for automatic refresh in shared workbooks during co-authoring (soon to support multi-workbook and Excel for Mac), and the ability to incorporate images and other data types within PivotTables.

Excel for Mac introduces three new capabilities based on user feedback. First, users can now generate Accessible PDFs, mirroring the functionality of the Win32 version. Second, an improved unified search experience helps Insiders find content across documents, commands, help articles, and Bing-powered web results. Lastly, support for images in PivotTables is now available for Excel for Mac Insiders.

As always, Microsoft welcomes feedback from Excel users regarding existing features and suggestions for new ones. The feedback portal is readily available for users to submit their input and contribute to the software's ongoing development.

Follow HT Tech for the latest tech news and reviews , also keep up with us on Whatsapp channel,Twitter, Facebook, Google News, and Instagram. For our latest videos, subscribe to our YouTube channel.

First Published Date: 02 Jul, 09:41 IST