Toll Free - 877-442-3915

Account | Self-Paced Login

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

Excel Database Features and PivotTables Course

Excel Database Features and PivotTables Onsite Group Training Course


Course Description:  The Excel 365 Database Functions and PivotTables course focuses on managing data and creating PivotTables in Excel. This class will cover the following topics: Using Lists, Formatting a Table, Creating a Slicer, Importing Data from a Text File, Using Database Functions, Creating and Working with PivotTables, Using a Timeline, and Creating a Calculated Field. This class is fitting for students who have a background in either Excel 2019 or 2016 Introduction skills.

Excel Database Features and PivotTables - Course Syllabus

Warning: include(oisyllabus/onlc-excel19-3.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49

Warning: include(oisyllabus/onlc-excel19-3.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49

Warning: include(): Failed opening 'oisyllabus/onlc-excel19-3.php.php' for inclusion (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
How On-Site Training Works
How On-Site Training Works

  • Discuss your team's educational needs with a BCS representative.
  • Schedule class date(s) that fit your team's availabilty.
  • Professional Trainer will conduct the class at your facility or online.
  • We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
  • You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
  • Usually a two-week lead time to schedule a class.
  • Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
  • 1 Hour Lunch Break, and Two 15-minute Break

On-Site excel Training Packages
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)

On-Site Training Request

Please complete the information request form below, and one of our representatives will contact you within one business day.







"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)


Business Computer Skills Microsoft Partner
Business Computer Skills BBB Profile