Toll Free - 877-442-3915

Account | Self-Paced Login

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

Excel Workbooks, Formulas and Functions (365/2019/2016) Training Course

Excel Workbooks, Formulas and Functions (365/2019/2016) Training Course


Course Description:  The Excel 2019 Large Workbooks, Formulas and Functions course is perfect for those who are responsible for managing and creating large worksheets and models in Excel and have Excel 2019 or 2016 Introduction skills mastered. The following topics will be covered in this course: Viewing, Renaming, and Color-coding Worksheets, Using 3-D References, Creating and Using an Absolute Named Range, Using Financial Functions, Creating a Forecast Sheet, Protecting Workbooks and Worksheets, Creating Scenarios, and Using Table Lookup Functions (VLookup & HLookup).

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

Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/4/20 - 2/4/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/6/20 - 2/6/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/12/20 - 2/12/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/14/20 - 2/14/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/17/20 - 2/17/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/20/20 - 2/20/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/25/20 - 2/25/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/28/20 - 2/28/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/2/20 - 3/2/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/4/20 - 3/4/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/10/20 - 3/10/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/12/20 - 3/12/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/18/20 - 3/18/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/20/20 - 3/20/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/23/20 - 3/23/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/26/20 - 3/26/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/31/20 - 3/31/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/3/20 - 4/3/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/6/20 - 4/6/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/8/20 - 4/8/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/14/20 - 4/14/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/16/20 - 4/16/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/22/20 - 4/22/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/24/20 - 4/24/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/27/20 - 4/27/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/30/20 - 4/30/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/5/20 - 5/5/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/8/20 - 5/8/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/11/20 - 5/11/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/13/20 - 5/13/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/19/20 - 5/19/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/21/20 - 5/21/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/27/20 - 5/27/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/29/20 - 5/29/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/1/20 - 6/1/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/4/20 - 6/4/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/9/20 - 6/9/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/12/20 - 6/12/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/15/20 - 6/15/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/17/20 - 6/17/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/23/20 - 6/23/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/25/20 - 6/25/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/1/20 - 7/1/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/6/20 - 7/6/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/9/20 - 7/9/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/14/20 - 7/14/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/17/20 - 7/17/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/20/20 - 7/20/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/22/20 - 7/22/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/28/20 - 7/28/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/30/20 - 7/30/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/5/20 - 8/5/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/7/20 - 8/7/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/10/20 - 8/10/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/13/20 - 8/13/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/18/20 - 8/18/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/21/20 - 8/21/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/24/20 - 8/24/20
Course Fee : $299


Excel Workbooks, Formulas and Functions (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/26/20 - 8/26/20
Course Fee : $299


Course Syllabus

Course Outline

Using Large Workbooks
Viewing, Renaming, and Color-coding Worksheets
Working in Group Mode
Manipulating Worksheets

Using Multiple Worksheets
Create Linked Formulas
Using 3-D References
Consolidation by Position and Category
Viewing Worksheets from Different Workbooks Side by Side
Create Linked Formulas Between Workbooks

Background Concepts with Functions
Working with Functions/Using Functions
Using Absolute Cell Reference
Create & Use an Absolute Named Range
Create a Relative Named Range
Create a Custom Zoom
Using Insert Function

Using Financial and Date Functions
Using Financial Functions
Using Date Functions
Using Auditing & Error Checking Tools

Using Logical Functions
Using the IF Function
Nesting Functions
Using Multiple Conditions with the IF Function
Using Multiple If Functions
Using Table Lookup Functions (VLookup & HLookup)
Using Match and Index

Bonus Material
The following 3 sections will be included in your manual through March 31, 2016.
These topics will not be covered with the instructor.

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

Using Protection and Shared Workbook Features
Protecting Workbooks and Worksheets
Protecting a Workbook
Protecting a Worksheet
Allowing Users to Edit Ranges
Using Shared Workbooks
Configuring a Workbook for Shared Use
Highlighting Tracked Changes
Create the History Report
Reviewing Shared Workbook Changes

Create a Forecast
Create a Forecast Sheet
Setting Dates
Returning a Confidence Interval
Using Seasonality Patterns
Filling Missing Points

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