Microsoft Excel 2010 Intermediate Onsite Group Training Course

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

• 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

• 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

• 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

• 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

• Microsoft Excel 2016 Introduction
• Microsoft Excel 2016 Advanced
• Microsoft Excel 2013Introduction
• Microsoft Excel 2013 Intermediate
• Microsoft Excel 2013 Advanced
• Microsoft Excel 2010 Introduction
• Microsoft Excel 2010 Advanced

Microsoft Value Pack (Best Deal)