Microsoft Excel 2013 Advanced Onsite Group Training Course

Working with PivotTables
Creating a PivotTable
Specifying PivotTable Data
Changing a PivotTable’s Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart
Using Slicers
Sharing Slicers Between PivotTables
Working with PivotTables Review

Analyzing Data
Creating Scenarios
Creating a Scenario Report
Working with Data Tables
Using Goal Seek
Using Solver
Using Text to Columns
Grouping and Outlining Data
Using Subtotals
Consolidating Data by Position or Category
Consolidating Data Using Formulas
Analyzing Data Review

Working with the Web and External Data
Inserting a Hyperlink
Importing Data from an Access Database or Text File
Importing Data from the Web and Other Sources
Working with Existing Data Connections
Working with the Web and External Data Review

Working with Macros
Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the Quick Access Toolbar
Editing a Macro’s Visual Basic Code
Inserting Copied Code in a Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If…Then…Else Statement
Working with Macros Review

Customizing Excel
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format
Customizing Excel 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 2010 Introduction
• Microsoft Excel 2010 Intermediate
• Microsoft Excel 2010 Advanced

Microsoft Value Pack (Best Deal)