Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Excel 2013 Advanced Training Course

Microsoft Excel 2013 Advanced Training Course


Course Description: : The Microsoft Excel 2013 Advanced course will expand upon skills taught in the Intermediate course, including using multiple worksheets, named ranges, and functions.

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

  • Use advanced functions
  • Analyze Data
  • Work with data
  • Create and work with PivotTables
  • Enhance PivotTables
  • Work with Macros
  • Work with data analysis tools

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

Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 1/30/20 - 1/30/20
Course Fee : $299


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


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 2/12/20 - 2/12/20
Course Fee : $299


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


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 2/28/20 - 2/28/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/4/20 - 3/4/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/12/20 - 3/12/20
Course Fee : $299


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


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/25/20 - 3/25/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/2/20 - 4/2/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/10/20 - 4/10/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/15/20 - 4/15/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/23/20 - 4/23/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 5/1/20 - 5/1/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 5/6/20 - 5/6/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 5/14/20 - 5/14/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 5/22/20 - 5/22/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 5/28/20 - 5/28/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 6/3/20 - 6/3/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 6/12/20 - 6/12/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 6/17/20 - 6/17/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 6/25/20 - 6/25/20
Course Fee : $299


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


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


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


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


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


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 8/5/20 - 8/5/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 8/13/20 - 8/13/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 8/21/20 - 8/21/20
Course Fee : $299


Microsoft Excel 2013 Advanced
Locations: Available Nationwide and Online
Class Date(s): 8/26/20 - 8/26/20
Course Fee : $299


Course Syllabus

Using Advanced Functions
Working with Functions
Working with the IF Function
Nesting Functions
Working with Multiple Conditions with the IF Function
Working with Table Lookup Functions
Working with Text Functions

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

Working with Data
Importing Data from a Text File
Exporting Data
Converting Text to Columns
Working with Flash Fill
Connecting to Data in an Access Database
Create a Web Query
Importing Web Data Working with a Saved Query
Working with Hypertext Links

Create and Working with PivotTables
Understanding PivotTables
Working with Recommended PivotTables
Create a PivotTable Working with Worksheet Data
Create a PivotTable Working with an External Data Connections
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Working with a Report Filter
Refreshing a PivotTable
Formatting a PivotTable

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

Working with Macros
Recording a Macro
Saving a Macro-Enabled Workbook
Executing a Macro
Create a Macro Button
Working with Macro Buttons

Working with Data Analysis Tools
Create Scenarios
Working with Scenarios
Working with Goal Seek
Working with One-Input Data Tables
Working with Two-Input Data Tables
Understanding Solver
Defining a Problem
Solving a Problem
Generating a Report of Results and Alternate Solutions

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 BBB Profile