Microsoft Excel 2016 Intermediate Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $225.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

1 Day

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2016 Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2016 Training course
  • Six months of post-class email support from a Microsoft Excel Instructor

Course Description

In this Microsoft Excel 2016 Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students will also learn about using Lists in Excel and sorting and filtering data in lists. Students will be exposed to Database functions such as DSUM and how to work with and format tables in Excel. Modifying and formatting Charts in Excel will also be explored in this course. And, finally, students will learn how to analyze date using PivotTables, PivotCharts, Timelines and Slicers

Course Objectives

Upon successful completion of this course, students will be able to:
  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and PivotCharts.

Course Audience

This course is designed for students who already have already familiar with completing basic tasks in Excel 2016 and who want to explore using Excel to analyze and present data in greater depth.

Course Prerequisites

Students should have familiarity with the topics covered in (or have already attended) the Microsoft Excel 2016 Introduction Training course.

Course Syllabus

  1. Working with Functions
    • Work with Ranges
    • Use Specialized Functions
    • Logical Functions: IF(), SUMIF(), COUNTIF(), AVERAGEIF(), AND, OR, NOT
    • Date & Time Functions: TODAY(), NOW(), DATE(), WEEKDAY()
    • Text Functions: LEFT(), RIGHT(), MID(), FIND()
  2. Working with Lists
    • Sort Data
    • Filter Data
    • Query Data with Database Functions
    • Outline and Subtotal Data
  3. Analyzing Data
    • Create and Modify Tables
    • Apply Intermediate Conditional Formatting
    • Apply Advanced Conditional Formatting
  4. Visualizing Data with Charts
    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features
  5. Using PivotTables and PivotCharts
    • Create a PivotTable
    • Analyze PivotTable Data
    • Present Data with PivotCharts
    • Filter Data by Using Timelines and Slicers