MS Excel 2016 Advanced Level – Accessibility, Data Transformation and Errors

Overview 

Microsoft Excel 2016 ensures that Workbooks are easily accessible to anyone who needs to use them. This course covers the use of the Accessibility Verification Tool to identify accessibility issues, change the order of windows, and ensure that a workbook is modified appropriately for use in other jurisdictions. The course also covers data transformation and error checking.

Objectives

• Checking accessibility issues in Microsoft Excel 2016
• Changing the order of windows between workbook items in Microsoft Excel 2016
• Preparing a workbook for internationalization in Microsoft Excel 2016
• Using the Get and Transform feature to gather data from various sources in Microsoft Excel 2016
• use the column pivot reversal function to turn data into Microsoft Excel 2016
• run the error checking function in Microsoft Excel 2016
• track errors in Microsoft Excel 2016
• fix formula errors by using the formula evaluation tool in Microsoft Excel 2016