Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel Power User Training Course

Excel Power User Training Course


Course Description:  The Excel Power User course will train experienced Excel students in a two-day crash course on core topics form the Excel 2016 class catalog. The class will cover topics from the following courses: Excel 2016 Introduction, Excel Charts and formatting, database features and pivot tables, Excel Workbooks, Formulas and Functions and Excel Macros.

Please note: this is a fast-paced class for experienced Excel users. Students that are new to Excel should consider the Excel introduction class or the Excel Tips, Tricks & Timesavers class.

Upon completion of the course, users will be able to:

  • Getting Started with Excel
  • Entering Data
  • Using Formulas
  • Creating and Working with Charts
  • Formatting, Styles, Themes and Templates
  • Using Excel with other applications
  • Working with Worksheets and Workbooks
  • Working with Functions
  • Using Lists and Tables
  • Working With Data
  • Creating and Enhancing Pivot Tables
  • Analyzing Data
  • Excel Macro Basics

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 9/23/2020 - 9/24/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 10/5/2020 - 10/6/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 10/20/2020 - 10/21/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 11/4/2020 - 11/5/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 11/16/2020 - 11/17/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 12/2/2020 - 12/3/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 12/15/2020 - 12/16/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 12/30/2020 - 12/31/2020
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 1/11/2021 - 1/12/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 1/25/2021 - 1/26/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 2/10/2021 - 2/11/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 2/23/2021 - 2/24/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 3/8/2021 - 3/9/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 3/23/2021 - 3/24/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 4/7/2021 - 4/8/2021
Course Fee : $795


Excel Power User
Locations: Available Nationwide and Online
Class Date(s): 4/19/2021 - 4/20/2021
Course Fee : $795


Course Syllabus

Selected Topics from “Excel Introduction”

Getting Started with Excel
Working with the Ribbon
Exploring the File Tab
Working with the Quick Access Toolbar
Use Excel Help – Tell Me

Entering Data
Selecting a Range of Cells
Use Auto Fill to Enter Data

Use Formulas
Entering Formulas
Use Auto Fill with Formulas
Use AutoSum

Printing Worksheets
Use Page Setup Tools
Working in Page Layout View
Use Page Break Preview

Select Topics from “Excel Charts, Formatting & Reporting”

Create Charts
Create a Chart
Change the Chart Location and Size
Change the Chart Type
Modify Chart Elements
Formatting Chart Elements
Adding and Removing a Data Series
Applying a Chart Filter

Working with Charts
Create a Hierarchy Chart
Create a Histogram
Create a Pareto Chart
Create a Box and Whisker Chart
Create a Waterfall Chart
Create a Combo Chart
Create a Sparkline
Create and Use a Chart Template
Create a Dashboard

Use Styles, Themes, and Templates
Working with Cell Styles
Merging Styles
Use Themes
Use Templates
Create a Template

Working with Formatting
Create and Use Custom Formats
Applying Conditional Formatting
Create a New Conditional Formatting Rule
Use the Quick Analysis Tool

Use Excel Data in Other Office Applications
Understanding Pasting, Linking and Embedding
Pasting an Excel Range into a Word Document
Pasting an Excel Chart into a Word Document
Pasting an Excel Range into PowerPoint
Pasting an Excel Chart into PowerPoint
Create a Chart in Word or PowerPoint

Select Topics from “Excel Workbooks, Formulas & Functions”

Working with Workbooks
Editing a Group

Working with Multiple Worksheets and Workbooks
Create Linked Formulas
Viewing Multiple Worksheets
Use Absolute Cell References
Create Linked Formulas between Workbooks

Working with Financial and Date Functions
Use Financial Functions
Use Date Functions

Working with Logical Functions
Use the IF Function
Nesting Functions
Use Multiple Conditions with the IF Function
Nesting IF Functions

Working with Lookup and Reference Functions
Use HLOOKUP and VLOOKUP Functions
Use the MATCH Function
Use the INDEX Function
Nesting the INDEX and MATCH Functions
Use INDEX MATCH MATCH
Use INDEX MATCH & MATCH

Select Topics from “Excel Database Features and Pivot Tables”

Use Lists
Create and Use Absolute Named Ranges
Freeze and Unfreeze Panes
Use Functions with Lists

Use Table Features
Create a Table
Filter a Table
Create a Slicer
Working with the Total Row
Create a Calculated Column

Working with Data
Import Data from a Text File
Use Flash Fill
Connect to Data in an Access Database

Create and Working with PivotTables
Create a PivotTable Use Worksheet Data
Create a PivotTable Use an External Data Connection
Use a Report Filter
Use VLOOKUP to Add a Column to a List

Enhancing PivotTables
Working with Summary Functions
Create a Slicer
Grouping Data
Create a Calculated Field
Create a PivotChart

Analyzing Data
Use Automatic Outlining
Inserting Subtotals
Create an Advanced Filter
Use the Quick Analysis Tool

Select Topics from "Excel Macros"
Working with Macros
Record a Macro
Create a Macro Button

Onsite excel Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile