Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and 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

Prerequisite
None

Expected Duration
63 minutes

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.

Objective

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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.