Microsoft Excel: Upgrade to the latest Excel features

By J. Carlton Collins, CPA

Q. I am an Office 365 subscriber using Excel 2016. Is it possible for me to install and use the latest beta version of Excel 2019?

A. I received your question before Office 2019 was made generally available, but I think the answer is still of use moving forward. The days of downloading and installing the prerelease beta version of Microsoft Excel are gone, but you can still install the latest prerelease beta features for free, as follows. First, you must be an Office 365 subscriber of Microsoft Excel. If you are, then you can install the latest available features from the Excel menu by selecting File, Account, Office Insider, Change Level, then selecting Insider from the Choose your Office Insider level dropdown menu, as pictured below, and clicking OK.

techqa11


Thereafter, Excel will update your product approximately weekly with the latest prerelease beta features. (Be aware that by making this change, you will be accepting the higher risk involved in using unsupported builds of the Excel product — which in my experience means Excel may occasionally restart, freeze, or crash, but data loss or computer damage has not been an issue. Also, be aware that by becoming an Office Insider in this manner, you are agreeing to allow Microsoft to collect various diagnostic and error reporting data from your computer.) Once this process is complete, you can select File, Account, Update Options, Update Now to make sure the latest prerelease beta updates are installed immediately. Once this update is completed, you will be effectively using Excel's latest beta version.


About the author

J. Carlton Collins, CPA, (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.

SPONSORED REPORT

Solving the lease accounting challenge

The challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.