Excel 2011 Windows5/5/2021
During the life of the product the two versions moved very far apart from each other.These days most users today will have Excel 2016, 2019 or 365.
Excel 2011 Windows Mac And WindowsEach version of Excel has been significantly different to the last, and the Mac and Windows versions are still very different today.If you need to learn Excel we strongly recommend that you learn using Excel 365 rather than one of the legacy versions. Instead of the old 3-year update cycle, 365 is a constantly evolving product with new features arriving as each new version is released. Because business users dont want constant change (and need rock-solid reliable releases) Microsoft introduced the concept of update channels for Office 365. The Smart Method supports the ever-changing nature of Office 365 by publishing a new version of our books every six months to support each new release. At the time of writing this article (in September 2020) wed recently published the fourth edition covering the July 2020 semi-annual update. The Smart Method is the only publisher that does this to keep our books up to date. There have been some amazing features added to Excel 365 since 2019 but absolutely nothing compares to the introduction of Dynamic Arrays and Dynamic Array functions in the July 2020 release. The Excel engine had to be re-engineered to recognize the new dynamic array concept. In Excel 365 a huge number of older Excel functions can now work in an entirely new way and some old favourites have been replaced by modern array-aware functions. For example VLOOKUP has been replaced by XLOOKUP (a modern array function that is more versatile, easier to use and more powerful). The new dynamic array capability has evolved Excel 365 into a different league to Excel 2019. Dynamic arrays are fundamentally incompatible with Excel 2019 and will result in modern workbooks (created with Excel 365) not working as expected in legacy versions (in this context Excel 2019 is a legacy version even though you can still purchase it). Excel 365 is the latest, greatest and most powerful Excel version you can use and it is available for a very modest monthly subscription. Excel 2011 Windows Software As AIt is clear that Microsoft have completely embraced the SaaS (software as a service) model where software is rented and not sold. They seem to have also acknowledged that there are some purchasers that still prefer the buy once use forever model. Many commentators are now speculating that Excel 2019 really is the last in the line of perpetual licensed versions. The current Excel 2019 version is already hugely behind Excel 365 with the killer feature of dynamic arrays only available to Excel 365 users as no new features will every be added to Excel 2019. The huge upgrade for Excel 2019 was the inclusion of the power tools: Power Pivot, Power Query (Get Transform) and Power Maps (3-D Maps) in all versions. These are very high-level OLAP tools that allow Excel to analyse big data and add the ability to perform modern data analysis with any Excel version. Having said this the power tools have further evolved since Excel 2019 was released making extra power features available only to Excel 365 users.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |