How To Take This Class

Course Overview

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 Prerequisites

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

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.

What You'll Learn

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 Duration

1 Day

Course Outline

  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

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