Course 100005

Excel 2016 Advanced

Microsoft Office Excel 2016 is the newest version of Microsoft's popular spreadsheet program. This, the third level of Velsoft’s training program, explores the advanced features in in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data.

Course Outline

Lesson 1: Automating Worksheet Functionality

  • Topic A: Update Workbook Properties
  • Topic B: Create and Edit a Macro
  • Topic C: Apply Conditional Formatting
  • Topic D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets

  • Topic A: Trace Cells
  • Topic B: Troubleshoot Invalid Data and Formula Errors
  • Topic C: Watch and Evaluate Formulas
  • Topic D: Create a Data List Outline

Lesson 3: Analyzing and Presenting Data

  • Topic A: Create Sparklines
  • Topic B: Create Scenarios
  • Topic C: Perform a What-If Analysis
  • Topic D: Perform a Statistical Analysis with ToolPak
  • Topic E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks

  • Topic A: Consolidate Data
  • Topic B: Link Cells in Different Workbooks
  • Topic C: Merge Workbooks

Lesson 5: Exporting Excel Data

  • Topic A: Export Excel Data
  • Topic B: Import a Delimited Text File
  • Topic C: Integrate Excel Data with the Web
  • Topic D: Create a Web Query

Lesson 6: Importing and Exporting XML Data

  • Topic A: Import and Export XML Data

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


100005Excel 2016 Advanced
Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge4.67 out of 50 stars, based on 80 reviews*

Register

Price: $275
Duration: 1 day
Select Date: Show More Dates
Selected Date:
Selected Location:
Class Time: - EST