Course 100004

Excel 2016 Intermediate

100004

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

Students will learn how to use range names in formulas and functions, Creating Advanced Formulas, Analyzing Data with Logical and Lookup Functions, Organizing and Analyzing Datasets and Tables, Visualizing Data with Charts, Analyzing Data with PivotTables, Slicers, Pivot Charts, Inserting Graphics, Enhancing Workbooks as well as how to use specialized functions.

Course Outline

Lesson 1: Creating Advanced Formulas

  • Topic A: Use Range Names in Formulas
  • Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • Topic A: Use Text Functions
  • Topic B: Use Logical Functions
  • Topic C: Use Lookup Functions
  • Topic D: Use Date Functions
  • Topic E: Use Financial Functions

Lesson 3: Organizing Worksheet Data with Tables

  • Topic A: Create and Modify Tables
  • Topic B: Sort and Filter Data
  • Topic C: Use Subtotal and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Basic Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Create a Trendline
  • Topic D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Filter Data by Using Slicers
  • Topic C: Analyze Data with PivotCharts

Lesson 6: Inserting Graphics

  • Topic A: Insert and Modify Graphic Objects
  • Topic B: Layer and Group Graphic Objects
  • Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks

  • Topic A: Customize Workbooks
  • Topic B: Manage Themes
  • Topic C: Create and Use Templates
  • Topic D: Protect Files
  • Topic E: Preparing a Workbook for Multiple Audiences

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


100004Excel 2016 Intermediate
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