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.

Where to find March’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Get Clients Ready for Tax Season

This comprehensive report looks at the changes to the child tax credit, earned income tax credit, and child and dependent care credit caused by the expiration of provisions in the American Rescue Plan Act; the ability e-file more returns in the Form 1040 series; automobile mileage deductions; the alternative minimum tax; gift tax exemptions; strategies for accelerating or postponing income and deductions; and retirement and estate planning.