In this course, students will learn Functions, Lists, Analyze Data, Visualize Data with Charts,Create Advanced Formulas,Analyze Data with PivotTables, and Pivot Charts


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion of this course, students will be able to use functions, analyze data, create formulas, understand Pivot Tables and charts

  • Working with Ranges and Conditional Formatting

  • Naming cell ranges
    Calculating functions on multiple ranges
    Calculating data with multiple sheets
    Calculating date functions
    Advanced formats and functions

  • Advanced Functions

  • Using the IF function
    Using conditional aggregate functions
    Using the VLOOKUP function
    Using database functions

  • Tables

  • Inserting an Excel table and creating a table style
    Practice- Creating tables
    Creating table calculations
    Filtering tables
    Creating subtotals

  • Charts

  • Creating a chart and moving charts
    Recommended charts
    Adding chart elements
    Formatting a chart
    Adjusting data ranges
    Building sparklines
    Customizing sparklines

  • Pivot Tables and Charts

  • Creating a pivot table
    Pivoting data in a pivot table
    Changing pivot table layout
    Formatting pivot tables
    Updating pivot table information
    Adding calculated fields to pivot tables
    Using slicers


This course builds upon the knowledge presented in the Microsoft Office Excel Part 1 course and leads to creating advanced workbooks & worksheets that can help deepen their understanding.




There are no stated prerequisites for this course. Please check with your representative for details.


Length: 1.0 day (8 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.