Microsoft Excel 2016 makes ensuring Workbooks are accessible to all who need to use them very easy. This course covers using the accessibility checker to identify accessibility issues, altering the tab order, and making sure a workbook is modified appropriately for use in other jurisdictions. The course also covers transforming data and checking your work for errors.
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
1 Hours, 3 minutes
None
Expert
Accessibility and Internationalization
- start the course
- check for accessibility issues in Microsoft Excel 2016
- modify the tab order between workbook elements in Microsoft Excel 2016
- prepare a workbook for internationalization in Microsoft Excel 2016
Practice: Making a Workbook Accessible
- adjust a workbook to ensure accessibility and optimal tab order
Transform Data and Share Queries
- use Get & Transform to pull together data from different sources in Microsoft Excel 2016
- use the unpivot columns feature to transform data in Microsoft Excel 2016
Handle Errors
- run the error checker in Microsoft Excel 2016
- trace errors in Microsoft Excel 2016
- troubleshoot formulas using the evaluate formula tool in Microsoft Excel 2016
Practice: Working with Data
- use Microsoft Excel 2016 transform features to work with data, and check it for errors