Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors

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

adjust a workbook to ensure accessibility and optimal tab order

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

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

use Microsoft Excel 2016 transform features to work with data, and check it for errors

Course Number:
mo_adve_a03_dt_enus

Expertise Level
Expert