Loading...

EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

Home / EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

This course teaches students how to analyze and report data frequently as well as work in collaboration with others to deliver actionable insights. Students will learn how to keep and maintain workbooks for all purposes, as well as automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the power of Excel at their fingertips. Students will also learn how to perform advanced data analysis, and automate workbook functionality.

Course Length: 1 day(s)

Course Price: $355 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

  • Working with Multiple Worksheets and Workbooks
    • Use Links and External References
    • Use 3-D References
    • Consolidate Data
  • Using Goal Seek, Solver and VLookup
    • Setting up the Worksheet
    • Using Goal Seek
    • Running Solver
    • Generating Reports and Scenarios with Solver
    • Modifying Constraints
    • Setting Solver Options
    • Use VLookup
  • Analyzing Data
    • Enabling the Analysis ToolPak
    • Using Data Analysis Tools
    • Using Data Tables
  • Managing Data
    • Consolidating Information
    • Removing Duplicates
    • Configuring Data Validation
    • Transposing Data
    • Converting Text to Columns
  • Using the Inquire Add-In
    • Installing Inquire
    • Generating a Workbook Analysis Report
    • Viewing Workbook and Worksheet Relationships
    • Viewing Cell Relationships
    • Comparing Two Workbooks
  • Working with Slicers
    • Inserting and Using a Slicer
    • Renaming the Slicer
    • Changing Slicer Settings
    • Formatting a Slicer
    • Clearing the Slicer
  • Forecasting Data
    • Determine Potential Outcomes Using Data Tables
    • Determine Potential Outcomes Using Scenarios
    • Creating Scenarios
    • Loading Scenarios
    • Merging Scenarios
    • Editing Scenarios
    • Creating a Scenario Summary Report
    • Deleting Scenarios
    • Use the Goal Seek Feature
    • Forecasting Data Trends
  • PivotTable Features
    • Creating a Basic PivotTable
    • Creating a Basic PivotChart
    • Using the PivotTable Fields Pane
    • Adding Calculated Fields
    • Sorting Pivoted Data
    • Filtering Pivoted Data
  • Automating Workbook Functionality
    • Apply Data Validation
    • Search for Invalid Data and Formulas with Errors
    • Work with Macros

Audience

This course is designed for students who are experienced with Excel 2016 and want to advance their skills in working with more advanced Excel features.

Prerequisites

EXCL1: Microsoft Excel - Level 1 / Intro (2010, 2013, 2016) or equivalent experience
EXCL2: Microsoft Excel - Level 2 / Med (2010, 2013, 2016) or equivalent experience

 

Instructor Led In Classroom

Newcomp can directly deliver courses through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.