Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors $74.95
Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms $74.95
Microsoft Excel 2016 Advanced: Apps and What-if Analysis $74.95

Bundle Price: $139.00
Total Savings: $85.85


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

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.
  • 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

Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.
  • start the course
  • configure Power Pivot and import data into a Microsoft Excel 2016 Workbook
  • create a PivotTable using Power Pivot in Microsoft Excel 2016
  • create and populate a PivotTable using Power Pivot in Microsoft Excel 2016
  • create a custom number format in Microsoft Excel 2016
  • create a custom date and time format in Microsoft Excel 2016
  • create a custom accounting format in Microsoft Excel 2016
  • create a custom fill series in Microsoft Excel 2016
  • create custom conditional formatting rules in Microsoft Excel 2016
  • modify custom conditional formatting rules in Microsoft Excel 2016
  • apply complex filtering criteria to data in Microsoft Excel 2016
  • use custom formats, filters, and fill series when working with data in Microsoft Excel 2016

Microsoft Excel 2016 Advanced: Apps and What-if Analysis

Microsoft Excel 2016 is a very powerful data analysis tool, but its functionality can be enhanced even further using third-party applications. This course covers how to find, install, and manage apps. It also covers What-if analysis, where Excel offers a number of ways of exploring how altering inputs can affect the outcome of calculations.
  • start the course
  • add an add-in for Microsoft Excel 2016 to your Microsoft account
  • insert and manage an add-in in Microsoft Excel 2016
  • use Goal Seek to find required input values in Microsoft Excel 2016
  • determine a value based on a number of variables using Solver in Microsoft Excel 2016
  • create and compare scenarios using scenario manager in Microsoft Excel 2016
  • create a summary report of scenarios in a Microsoft Excel 2016 Worksheet
  • merge scenarios in Microsoft Excel 2016
  • create a single variable data table in Microsoft Excel 2016
  • create a two-variable data table in Microsoft Excel 2016
  • use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016
Register Now
Microsoft Office 2016: Advanced Excel e-learning bundle
  • Course ID:
    271425
  • Duration:
    n/a
  • Price:
    $139