Office Compatibility Issues

How to Use Microsoft 365 Excel with Excel 2016 Training Materials

John WilsonJohn Wilson Nov 3, 2026 871 views

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.

Using Microsoft 365 Excel for Excel 2016 Training Courses
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.
Before you start

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.

Solution 1Recommended

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.

1
Utilize the Search Function

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.

2
Enable Legacy Data Wizards

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.

3
Pin the Ribbon

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.

Adapt Microsoft 365 Excel for Excel 2016 Coursework
Avoid Newer Functions: Microsoft 365 includes new functions like XLOOKUP and FILTER which do not exist in Excel 2016. Stick strictly to the formulas taught in your coursework (like VLOOKUP) to ensure your submitted files are graded correctly.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and complete the lightweight setup process.
  2. 2. Open Your Course Files: Launch WPS Spreadsheets and open your .xlsx training materials directly. The application will render the data flawlessly.
  3. 3. Follow Your Coursework: Navigate the intuitive ribbon menu to complete your lessons using standard formulas and formatting tools that mirror classic spreadsheet software.
Features a classic, familiar ribbon interface that resembles traditional Excel versions.100% compatible with Microsoft Excel file formats, including .xls, .xlsx, and .xlsm.Lightweight installation with full offline capability.Free to use for basic spreadsheet creation, document editing, and presentation design.
microsoft office alternative - wps office

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.