Intermediate Excel

This workshop is for employees who wish to gain intermediate skill sets utilizing Excel.  Employees must have a working knowledge of Excel before taking this workshop.

Customizing the Excel Environment 

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Organizing and Analyzing Data sets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts 

  • Create Charts
  • Modify and Format Charts

Analyzing Data with Pivot Tables, Slicers and Pivot Charts

  • Create a Pivot Chart
  • Analyze PivotTable Data
  • Present Data with Pivot Charts

Filter Data by Using Slicers


Contact Us

  • This field is for validation purposes and should be left unchanged.

Course Details

Title: Intermediate Excel

Training Mode: In Person

Skip to toolbar