Microsoft Excel is a spreadsheet-based software application designed to organize numbers and data using formulae and functions. In the Excel software programme, you can make use of formulas, shortcuts, and many other features to enhance the functionality of this application. Budgeting, forecasting, and accounting are often handled solely by Excel spreadsheets in many businesses. As a result, companies heavily rely on Excel. Its resilience and accessibility are its strongest features, which make it a perfect data management tool. Excel comprises some magnificent statistical instruments, like a macro programming language known as Visual Basic for Applications, pivot tables, calculating, graphing and computation.
The following are some of Excel’s most common applications:
- Data entry and management
- Graphing and charting
- Financial evaluation and simulations
- Time and task management
- Management of customer relationships (CRM)
- Almost everything that requires organization!
Microsoft Excel has been the most widely used spreadsheet programme on the planet for more than three decades, and it has gone through a number of changes over the years to become the most versatile spreadsheet programme. Microsoft discontinued publishing separate versions of Excel in 2016 and instead began upgrading the software via Windows Update. It is included in the Microsoft 365 subscription model. The current version is 16.0, which has had numerous features updated since 2016. Let’s have a review of the latest updates to Excel in 2021.
New Features of 2021 Update of Excel:
The same Excel workbook may be opened and worked on by you and your coworkers. This is referred to as co-authoring. When you co-author, you may view each other’s edits in a couple of seconds. And, in some Excel versions, you may view other people’s choices in various colors. Select Share in the upper-right corner, input email addresses, and then choose a cloud location if you’re running an Excel version that enables co-authoring.
Modern comments and notes
The way comments operate in Excel for Microsoft 365 has changed. Threaded comments allow you to conduct discussions with other users regarding the data and are now called “modern comments.” Notes are used to make notes or annotations on the data and now notes act identically to the way comments used to be in previous versions of Excel.
Use the XLOOKUP function to find items in a table or range by row. For instance, use the component number to check on the pricing of a retail item, or use the identification number to look up an employee’s name. You can look for a search phrase in one column and return a result from the same row in another column using XLOOKUP, regardless of which side the return column is on.
XMATCH and LET function
The XMATCH function is used to search for an array or range of cells for a given item and return its precise location. The LET function gives names to the results of calculations. This enables you to save interim computations, values, or names within a formula. These names are solely applicable to the LET function. LET is performed using Excel’s native formula syntax, similar to variables in programming. The perks are enhanced performance and efficiency in readiness and training.
Excel formulas that return a series of values, often known as an array, send the results to adjacent cells. Spilling is the term for this type of conduct. Dynamic array formulae are formulas that can return variable-sized arrays.
Sheet views are a novel technique for creating custom views in an Excel worksheet without being interrupted by other users. You may use a filter to see only the entries that are relevant to you, without being influenced by other people’s sorting and filtering of the document.
Accessibility ribbon and checker
On the Accessibility ribbon, you’ll find all of the tools you need to build accessible Excel workbooks in one spot. The Accessibility Checker monitors your papers and alerts you in the status bar if it discovers anything you should investigate.
Some additional useful updates
As you make modifications, it automatically saves them if you are on the cloud. It can now also unhide a large number of sheets at once. The new Microsoft Search box feature assists you in easily locating information such as text, instructions, assistance, and more. Support for the OpenDocument format (ODF) 1.3 has been added. All of your inking tools can now be accessed and changed from one location. In response to user feedback, Microsoft has added a new input area for Hex color values to the color dialogue. The sketched style outline feature allows you to give shapes in your workbook a casual, hand-drawn look.