Courses > Course Outline

Excel 2016 Tables, PivotTables and Conditional Formatting

In this course, students will create, edit, and enhance Tables, PivotTables and Conditional Formatting using Microsoft Office Excel 2016.

Excel 2016 Tables, PivotTables and Conditional Formatting

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, students will be able to create a spreadsheet using Tables, PivotTables and Conditional Formatting by using Microsoft Office Excel 2016.

 

Course Details

Course Outline

1 - Organize Worksheet and Table Data
  • Create a Table
  • Sort and Filter a Table
  • Create Calculated Columns in a Table
  • Create a Total Row in a Table
  • Format a Table
    • 2 - Analyzing Data Using PivotTables, Slicers, and PivotTables
  • Create a PivotTable
  • Filter Data with Slicers
  • Analyze Data Using PivotCharts
    • 3 - Apply Conditional Formatting
  • Data Bars, Icon Sets, Color Scales, Top/Bottom Values, Duplicate Values

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

    Who is it For?

    Target Audience

    This course is intended for individuals who want to gain knowledge of working on Excel using Tables, PivotTables and Conditional Formatting.

    Excel 2016 Tables, PivotTables and Conditional Formatting

    Call
    Course Length : 0.5 Day

    There are currently no scheduled dates for this course. Please contact us for more information.

     PDF Outline With Dates     PDF Outline

    Need Help Picking the Right Course? Give us a call! 01 8898700