How to Use Microsoft 365 Excel with Excel 2016 Training Materials
Question details
The user wants to know how to effectively use Microsoft 365 Excel to follow along with training materials or coursework originally designed for Excel 2016.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to complete older Excel 2016 tutorials using the newer Microsoft 365 Excel application.
- Observed behavior
- The user encounters interface changes, updated menus, and relocated features in Microsoft 365 that differ slightly from the instructions in the Excel 2016 training materials.
Review your course syllabus to confirm if the instructor strictly prohibits using newer versions of Excel, and ensure your Microsoft 365 subscription is actively signed in and updated.
Adapt Microsoft 365 Excel for Excel 2016 Coursework
Use your current Microsoft 365 subscription to complete the course, as it fully supports all Excel 2016 features despite minor interface updates.
Microsoft 365 Excel is completely backward compatible with Excel 2016. Every standard formula, pivot table feature, and chart type taught in a 2016 course will work perfectly in Microsoft 365.
The primary challenge is adapting to visual user interface updates and relocated menu items. Rather than trying to purchase an outdated software version, you can adapt your current application.
If a training step references a button you cannot find, click the 'Search' bar at the top of the Microsoft 365 window (or press Alt + Q), type the name of the feature, and click the relevant result.
If your coursework requires old import tools, navigate to File > Options > Data. Under the 'Show legacy data import wizards' section, check the boxes for the wizards you need (e.g., From Text, From Web) and click OK.
Excel 2016 relies heavily on a visible Ribbon. If your Microsoft 365 Ribbon is hidden, click on any tab (like Home) and click the 'Pin' icon in the lower right corner of the ribbon (or press Ctrl + F1) to keep it permanently visible during your training.

Source Excel 2016 from Authorized Educational Providers
If your class strictly requires the exact 2016 version, seek legitimate avenues to obtain it through your institution.
Try WPS Office for a Classic Spreadsheet Experience
If you are struggling with version differences in Microsoft 365 or need a classic spreadsheet interface that closely resembles older Excel layouts, WPS Office is an excellent free alternative. It features high compatibility with legacy Office documents and provides a familiar user experience without the high subscription costs.
- 1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and complete the lightweight setup process.
- 2. Open Your Course Files: Launch WPS Spreadsheets and open your .xlsx training materials directly. The application will render the data flawlessly.
- 3. Follow Your Coursework: Navigate the intuitive ribbon menu to complete your lessons using standard formulas and formatting tools that mirror classic spreadsheet software.

Frequently Asked Questions
Can I use Microsoft 365 to open .xlsx files created in Excel 2016?
Yes, Microsoft 365 Excel is fully backward compatible. It will easily open, edit, and save .xlsx files created in Excel 2016 without any loss of data or formatting.
Will formulas taught in Excel 2016 still work in Microsoft 365?
Absolutely. All standard formulas and functions available in Excel 2016, such as VLOOKUP, INDEX, MATCH, and standard arithmetic, function identically in Microsoft 365.
Where can I safely buy a copy of Excel 2016?
Microsoft no longer sells Excel 2016 officially. Your safest options are to check if your school or employer provides educational licenses or volume licensing downgrades. You should avoid unofficial online key sellers due to the high risk of purchasing invalid or fraudulent licenses.
How do I find features in Microsoft 365 that have moved since Excel 2016?
You can use the universal search bar located at the very top of the Microsoft 365 application window. Simply type the name of the tool or feature you are looking for, and Excel will provide a direct shortcut to that action.




