Excel 2016 and 2019 cheat sheet

[Karlston]

Get to know the key features in Microsoft Excel 2016 and Excel 2019 for Windows.

Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it. And if you use spreadsheets, that generally means Excel.

 

Excel is, of course, part of Microsoft’s Office suite of productivity tools. Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever (what the company calls the “perpetual” version of the suite), or they can purchase an Office 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee.

 

When you purchase a perpetual version of the suite — say, Office 2016 or Office 2019 — its applications will never get new features, whereas Office 365 apps are continually updated with new features. (For more details, see “What are the differences between Microsoft Office 2019 and Office 365?”)

 

This cheat sheet gets you up to speed on the features that were introduced in Excel 2016 and Excel 2019, the perpetual-license versions of Excel included with Office 2016 and Office 2019, respectively. In Office 365, Excel has all those features, plus several more. Coming soon, we’ll have a separate cheat sheet that covers the latest features in Excel for Office 365.

 

Most of the tips in this article apply to both Excel 2016 and 2019 for Windows. Near the end is a section for Excel 2019 only.

 

<snip>

 

Poster's Note: This is a lengthy two page article, so for the complete article please follow the link below...

 

Source: Excel 2016 and 2019 cheat sheet (Computerworld - Preston Gralla)