What’s New in Excel? How the New Features Will Improve Your Data Management | More4apps

What’s New in Excel?

How the New Features Will Improve Your Data Management

Share

Share on facebook
Share on twitter
Share on linkedin
Share on email
What's new in Excel

Excel is a mainstay for data entry teams; even the More4apps EBS wizards use the popular spreadsheet software. To improve the speed and quality of your data entry, you must know exactly what features are available to you.

Now, in Excel 2021, Microsoft has added a swathe of new features to the software, helping data admin professionals to get more out of their spreadsheets. From the ability to see changes to pivot table improvements, these new features will undoubtedly save you time with your data management.

So, here are some of the biggest new updates to Excel, and why they matter to data management teams.

Pivot Tables

For data processing teams, pivot tables are one of the most important features of Excel. They allow you to analyse a large amount of data efficiently, with customisable features so you can choose exactly the data you want to look at.

Now, in Microsoft 365 and Excel 2021, there are even more ways to personalise the way you see your data. For example, you can set the pivot table to automatically appear in tabular form – no more manually setting this view for every pivot table that you create.

Additionally, if you format any cells in the pivot table – for example, highlighting them – that cell and the corresponding information will remain formatted even if you make subsequent changes to the table.

For data admin professionals who want to keep an eye on a crucial piece of data while adding new information to the table, this makes it easy.

Dynamic Array Formulas

Data management teams will experience less stress with formulas in Excel now, as one formula can now spill to multiple cells. When data is added to the original table referenced in the formula, the data will also be amended anywhere you’ve used the formula. A new error type SPILL will alert users if there is anything in the spreadsheet that will obstruct the new table when the formula spills.

Microsoft has also added some new formulas to Excel 2021, solving problems that data admin professionals have had for years. The sort formula can place data in ascending or descending order without the use of the A-Z or Z-A. Any changes made to the original data will also amend the new table, so you never have to worry again about making comprehensive changes to your spreadsheet. 

XLOOKUP

Finally, one of the most anticipated changes to Excel 2021 is the brand-new XLOOKUP function. Users could already use the VLOOKUP function to find items in a table or range by row; now the XLOOKUP adds more versatility.

With XLOOKUP, the third argument has been replaced by a reference – simply point to the column in the table you want to use in the function. Consequently, any additional columns to the original table will not result in an error in your formula.  

Data admin teams will also welcome the ability to return multiple cells of information with one formula. For example, you can extract 12 months of data by using XLOOKUP in just one cell. 

This just scratches the surface of the changes to Excel 2021. Other new additions include:

  • The ability to see any change that has been made to a spreadsheet in the last 60 days.
  • Using CTRL+click to unselect cells.
  • The UNIQUE formula can now return data that only appears once. 
  • Generate a sequence of numbers with SEQUENCE.

If you want to learn more about the capabilities of these new features in Excel, join the More4apps on-demand webinar. Over one hour, Bill “Mr Excel” Jelen will demonstrate all the new features, giving examples of how you can utilise it in your data management work. Watch the on-demand webinar here

 

What’s New in Excel? ​

Watch our on-demand webinar with Bill “MrExcel” Jelen as he reveals the awesome new features added to Excel. See what is new in Excel, from the amazing new formula functions to pivot table improvements.