Certification     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

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.

---

---

Objectives

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