Menu
Pay Now Become a Partner

Microsoft Office 2016 - Advanced Excel

More Courses in Office Productivity
Course Fee : USD 100
Offer Fee : USD 75

Buy Now

Microsoft Excel 2016 Advanced: Apps and What-if Analysis

Learn how the functionality can be enhanced even further using third-party applications and how to find, install, and manage apps
Overview/Description

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.

 

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

 

Expected Duration

47 minutes

Prerequisites

None

Expertise Level

Expert

 

Objectives

Excel 2016 Apps

  • 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

What-if Analysis

  • 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

Practice: What-if Analysis

  • use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016

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

Learn how to pull together huge amounts of data from different sources and analyze it and creation of custom and conditional formatting and filters
Overview/Description

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.

 

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

 

Expected Duration

1 Hours, 11 minutes

Prerequisites

None

Expertise Level

Expert

 

Objectives

Power Pivot

  • 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

Practice: Using Power Pivot

  • create and populate a PivotTable using Power Pivot in Microsoft Excel 2016

Custom Formats and Fills

  • 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

Conditional Formatting and Filters

  • 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

Practice: Format, Fills, and Filtering

  • use custom formats, filters, and fill series when working with data in Microsoft Excel 2016

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

Learn to make workbooks accessible to all who need to use them very easy and transforming data and checking your work for errors
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

 

Expected Duration

1 Hours, 3 minutes

Prerequisites

None

Expertise Level

Expert

 

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