Search results
- There have been 30 different versions of Excel, stretching from 1985 to the present day. These days most users today will have Excel 2016, 2019, 2021 or 365.
thesmartmethod.com › excel-versions-explained
People also ask
How many versions of Excel are there?
What is the difference between Excel 4 & 5?
Is there a Windows version of Excel?
What's new in Excel 2013?
The table below revisits all the different versions that Excel has evolved through – starting from the first version back in 1985 and finishing with the latest one from 2019. So all the way to the present time, with the latest release of the various versions of Excel for Windows that you may encounter.
Feb 12, 2022 · There have been 30 different versions of Excel, stretching from 1985 to the present day. These days most users today will have Excel 2016, 2019, 2021 or 365. Each version of Excel has been significantly different to the last, and the Mac and Windows versions are still very different today.
- Overview
- Co-authoring
- Better collaboration with modern comments
- Know who's in your workbook
- Visual refresh
- Look left, look right… XLOOKUP is here!
- LET function
- Dynamic arrays
- XMATCH function
- Sheet views
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly — in a matter of seconds.
LEARN MORE
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
LEARN MORE
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
The XMATCH function searches for a specified item in an array or range of cells, and then returns the item's relative position.
You can also use XMATCH to return a value in an array.
Create customized views in an Excel worksheet without disrupting others.
LEARN MORE
Mar 22, 2024 · There are too many versions of Excel in daily use to expect a single book to be completely accurate with items such as screen shots and still be practical. The various versions, however, are close enough to each other to allow a student to pick up the necessary skills while accommodating to whichever version of Excel is available.
Feb 8, 2024 · In this forum, we are Microsoft consumers just like yourself. I can provide a concise summary of the key differences between Excel 2016 and the latest version of Excel available with Microsoft 365 (formerly Office 365): 1. **Collaboration**: The latest Excel has enhanced collaboration features, including co-authoring, which allows multiple ...
Dec 22, 2023 · You can retrieve 25 previous versions of your file with a personal Microsoft account. You can retrieve the number of previous versions according to your library configuration with a Microsoft work or school account. You must have version history turned on in SharePoint to retrieve previous versions using that platform.
There are numerous versions of Excel available, including the popular Excel 2019, Excel 365, and Excel Online. Each version offers unique features and capabilities, so it's important to choose the right version based on your specific needs.
