- What Is The Newest Version Of Excel File
- Current Version Of Excel
- What Is The Latest Version Of Excel Called
Each time an updated version of Excel is launched, new features are introduced and subtle changes in the look and feel take place. The biggest change was way back when the big jump from Excel 2003 to 2007 occurred. The introduction of the Ribbon and change of file types caused all sort of difficulties for heavy-duty Excel users, financial modellers included. In the versions since then, the changes have been somewhat less traumatic for users and in recent years Microsoft has been moving towards a subscription-based model, making the changes incrementally rather than all at once.
Although Excel 2019 is technically not yet available, many of the new features are already accessible if you’re on the Office 365 subscription. Whilst preparing the third edition of my first book, Using Excel for Business Analysis, I’ve been on the latest, most up to date version of Excel through the Microsoft Insider Program and have been using the new tools a little earlier than I would normally have done.
Thanks for the A2A Mudit Sharma As on 24th July 2018, the latest version of MS Excel is version 16 and is part of the Office 365 package. Here are some screen shots of what it looks like. The 2016 version is the latest software for the program, with Excel having begun life three decades ago. What is new in Microsoft Excel 2016? The highlighted new feature of this version of Excel is one-click forecasting, which makes it easier for the user to perform complex calculations.
There’s not much difference between them right now in terms of functionality; it’s just a different licensing arrangement. Excel 2019 is the perpetual, bought-outright, stand-alone version of Excel and Excel 365 is the subscription-based version of the software.
Each time an updated version of Excel is launched, new features are introduced and subtle changes in the look and feel take place. The biggest change was way back when the big jump from Excel 2003 to 2007 occurred. Oct 29, 2018 The Latest Version is Office 2019. The latest version of Microsoft Office is Office 2019, which is available for both Windows PCs and Macs. Release 31.0.1. Microsoft released the Office 2019 for Windows and Mac on September 24, 2018. The Windows version runs only on Windows 10. If you’re still using Windows 7, Office 2016 is the latest version you can use.
Historically, Microsoft has always sold a “perpetual” licence that is purchased outright and owned forever – I can still remember purchasing my first laptop together with a hideously expensive CD containing Microsoft Office. With this type of licence, the user does not receive any updates to their software until the next version is released and installed. Large organisations with many users that have purchased perpetual licences often wait several years before upgrading due to the cost and are usually at least one or two versions behind. This means that at any one time there has always been a wide range of versions in use in the general community. It is not unusual for me to run a public training course and have three or four different versions of Excel being used by different participants in the class. As a consultant, I have always had to take care to find out the oldest version of Excel the client is likely to be using and make sure that I don’t use any features or functions in the model that won’t work in their version of Excel.
Users with perpetual licences understandably become impatient because they don’t have access to new features they have seen or heard about, or because they cannot view or use or view the new features those with later versions have included in a model. When the upgrade finally does happen, the updates so eagerly anticipated by some, can cause confusion and frustration for others, either because they dislike the sudden new look or can’t find what they are looking for.
With subscription-based Office 365, updates are regularly released and any changes are gradual, which makes it easier for users to become accustomed to the differences. Organisations on the subscription model can choose their “update channel” which will determine how often updates are made, either monthly or semi-annually. In theory, all versions should be the same, but these differences in the frequency of updates means that not all users receive the updates at the same time.
Whilst it is possible to purchase an Excel 2019 licence, Microsoft is strongly encouraging users and organisations to take up the subscription option, presumably because they prefer the recurring revenue and stable cash flow it generates. How to use switch pro controller on dolphin. As more organisations move to this model, the compatibility problem of users being on different versions will become less of an issue and should make my life as a trainer and consultant a lot easier! To seal the deal, Microsoft announced in 2017 than those running Office 2016 on a perpetual licence will be unable to connect to Microsoft’s cloud-based services after 2020, and I expect 2019 will have similar limitations. It seems likely that Office 2019 will be the last version that Microsoft offers as a perpetual licence.
The following features are being introduced in Excel 2019 or to those with an Office 365 subscription:
- Custom visuals, such as word clouds, bullet charts and speedometers which were previously only available in Power BI. (Note, as with many features of Excel, just because you can doesn’t necessarily mean that you should).
- Microsoft Office now has full SVG graphics support plus the Excel application has 500 built in icons. These are now supported which look great on dashboards and infographics.
- The Insights feature has been expanded upon. Click on a table of data and by selecting Insights from the Insert tab, several charts will appear on the right-hand side of the page to give you “insights” into your data. This is probably more of a data analysis tool than one for financial modelling, but still rather handy.
- 3D Models which are fun, but I struggle to find a use-case for them in financial modelling.
- You can create your own custom functions using JavaScript. It’s always been possible to create user-defined functions using VBA but JavaScript allows for greater interconnection. Again, this is probably not necessary for the garden-variety financial model.
- Excel connects to Flow which you can use to create automated workflows to automatically collect data or synchronise data sources. This is particularly useful for automating data refreshes for models that need to be constantly updating, such as stock prices or currency exchange rates.
- Excel also connects to Forms, so you can have a nice form user interface, with a very easy to use tool, that can be shared through a link.
- Lots of new functions; most notably IFS, SWITCH, TEXTJOIN, MAXIFS and MINIFS.
- Map & funnel charts; the latter is just a centred bar chart but map charts allow you to display data on a map using countries, states, provinces, and even zip codes / post codes. You can either display numbers as a heat map or colour coded.
- Lots of new features in Excel’s ground-breaking Power Query data cleansing feature, including parameters, conditional columns & new transformations. Note also the name Power Query was changed to Get & Transform for Excel 2016 but has now reverted to Power Query, presumably to fit with the rest of the “Power Suite”; Power Pivot, Power BI etc.
- Multiple users can edit at the same time with co-authoring if a file is stored on SharePoint or OneDrive
- If you regularly change your preferences for Pivot tables, you can now assign a default behaviour for PivotTables.
- Previously, cells only contained a single, flat piece of text upon which formatting can be applied. With new AI-powered online data types, a cell could have a region or country value from which more information such as the population, capital city, area and many more details that can be extracted. The first two data types supported are Geography and Stocks, with more promised.
Note that you must have either Excel 2019 or Excel 365 to use these tools listed above. If a model containing any of these new features is opened in a previous version of Excel, in most cases you’ll be able to view the feature, just not make any changes to it. With new functions, however, the formula will simply stop working if opened in a non-compatible version of Excel which will undermine the functionality of the model – unless viewed using Excel Online. So, if you are building models in Excel that other people with prior versions need to use, then you need to consider the version capabilities as you build.
![Version Version](https://plumsolutions.com.au/wp-content/uploads/2018/08/What’s-new-in-Excel-2019.jpg)
What Is The Newest Version Of Excel File
So, in conclusion, there’s no need to wait for Excel 2019 – it’s already here! When the perpetual version of 2019 does become available it’s highly unlikely to contain any ground-breaking new features, as it will be based on the features already available to those with a 365 subscription.
Current Version Of Excel
Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.
What Is The Latest Version Of Excel Called
VERSION | RELEASED | DESCRIPTION |
---|---|---|
1 | 1985 | Version 1, for the Macintosh was released. There never was an Excel 1.0 for DOS or Windows. |
2 | 1987 | Excel 2.0 is the first version of Excel for Intel platform. |
3 | 1990 | Included Toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features. |
4 | 1992 | The first “popular” version. Included lots of usability features. |
5 | 1993 | A major upgrade. Included multi-sheet workbooks. Visual Basic for Applications (VBA) was introduced in this version. |
7 | 1995 | Known as Excel 95. The first major 32-bit version of Excel. This is the first major version after Excel 5.0, as there is no Excel 6.0. Almost no external changes, but faster and more stable. |
8 | 1997 | Known as Excel 97. A new interface for VBA developers, UserForms, Data Validation, and lots more. This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels. |
9 | 2000 | Included in Microsoft Office 2000. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.Can use HTML as a native file format, “self-repair” capability, pivot charts, modeless user forms. |
10 | 2002 | Known as Excel 2002. Included in Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes. This version features product activation technology. Please consider the ramifications of this before deciding whether to upgrade. |
11 | 2003 | Known as Microsoft Office Excel 2003. The new features in this version are:
Most users will not find the upgrade worthwhile. |
12 | 2007 | Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being “somewhat more negative” than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are: Diamond laser 1000s model dl-1000 manual.
|
14 | 2010 | Included in Microsoft Office 2010, this is the next major version after version 12, as version number 13 was skipped. Minor enhancements and 64-bit support, including the following features:
|
15 | 2013 | Included in Microsoft Office 2013, along with a lot of new tools included in this release:
|