Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Excel 2010 Intermediate Course

Microsoft Excel 2010 Intermediate Onsite Group Training Course


Course Description: The Microsoft Excel 2010 intermediate course helps the students build off of the topics learned in the introductory Excel 2010 course. We recommend this course for students are familiar with Excel 2010, and want to improve their skill level in the program.

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

  • Using Functions and Formulas
  • Working With Data Ranges
  • Working with Tables
  • Working with Pivot Tables
  • Analyzing and Organizing Data

Microsoft Excel 2010 Intermediate - Course Syllabus

Microsoft Excel 2010 Intermediate Syllabus

Managing Workbooks
Using Workbook Views
Selecting and Switching Between Worksheets
Inserting and Deleting Worksheets
Renaming, Moving, and Copying Worksheets
Splitting and Freezing a Window
Creating Headers and Footers
Hiding Rows, Columns, Worksheets, and Windows
Setting the Print Area
Adjusting Page Margins and Orientation
Adding Print Titles, Gridlines, and Row and Column Headings
Adjusting Paper Size and Print Scale
Printing a Selection, Multiple Worksheets, and Workbooks
Working with Multiple Workbook Windows
Creating a Template
Managing Workbooks Review

More Functions and Formulas
Formulas with Multiple Operators
Inserting and Editing a Function
AutoCalculate and Manual Calculation
Defining Names
Using and Managing Defined Names
Displaying and Tracing Formulas
Understanding Formula Errors
Using Logical Functions (IF)
Using Financial Functions (PMT)
Using Database Functions (DSUM)
Using Lookup Functions (VLOOKUP)
User Defined and Compatibility Functions
Financial Functions
Date & Time Functions
Math & Trig Functions
Statistical Functions
Lookup & Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering and Cube Functions
More Functions and Formulas Review

Working with Data Ranges
Sorting by One Column
Sorting by Colors or Icons
Sorting by Multiple Columns
Sorting by a Custom List
Filtering Data
Creating a Custom AutoFilter
Using an Advanced Filter
Working with Data Ranges Review

Working with Tables
Creating a Table
Adding and Removing Data
Working with the Total Row
Sorting a Table
Filtering a Table
Removing Duplicate Rows of Data
Formatting the Table
Using Data Validation
Summarizing a Table with a PivotTable
Converting to a Range
Working with Tables Review

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 computers 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