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


Microsoft Excel 2010 Advanced Training Course

Microsoft Excel 2010 Advanced Training Course


Course Description: The Microsoft Excel 2010 advanced course helps the students gain a high level of productivity with the software. This course covers advanced level topics, and is recommended this course for students who have extensive experience using Excel 2010.

Upon completion of the course, student will be able to complete the following tasks in Excel 2010:

  • Working with the Web and External Data
  • Working with Macros
  • Working with Objects
  • Other Advanced Topics

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

Microsoft Excel 2010 Advanced
Locations: Available Nationwide and Online
Class Date(s): 7/20/2020 - 7/20/2020
Course Fee : $299


Course Syllabus

Course Content

Work with Advanced Functions
Work with Functions
Use the IF Function
Nesting Functions
Use Multiple Conditions with the IF Function
Use Table Lookup Functions
Use Text Functions

Analyzing Data
Use Automatic Outlining
Consolidating Information by Position or Category
Insert Subtotals
Create an Advanced Filter
Use Database Functions

Work with Data
Import Data from a Text File
Export Data
Convert Text to Columns
Connect to Data in an Access Database
Create a Web Query
Import Web Data using a Saved Query
Work with Hypertext Links

Create and Work with PivotTables
Understanding PivotTables
Create a PivotTable using Worksheet Data
Create a PivotTable using an External Data Connections
Lay out a PivotTable on a Worksheet
Modify PivotTable Fields
Use a Report Filter
Refreshing a PivotTable
Formatting a PivotTable

Enhancing PivotTables
Work with Summary Functions
Sort Items in a PivotTable
Create a Slicer
Grouping Data
Apply Label and Value Filters
Create a Calculated Field
Create a Calculated Item
Create Charts from PivotTables

Work with Data Analysis Tools
Create Scenarios
Work with Scenarios
Use Goal Seek
Use One-Input Data Tables
Use Two-Input Data Tables
Using Solver
Define a Problem
Solve a Problem
Generate a Report of Results and Alternate Solutions

Work with Macros
Record a Macro
Save a Macro-Enabled Workbook
Execute a Macro
Create a Macro Button
Work with Macro Buttons

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

Business Computer Skills BBB Profile