Microsoft Excel 2016 Advanced Onsite Group Training Course

PivotTables

Create PivotTables

Add Multiple PivotTable Fields

Change a PivotTable's Calculation

Add Calculated Fields

The GETPIVOTDATA Function

Filter PivotTables

Timelines

PivotTable Layout

Group Values

Refresh a PivotTable

Format a PivotTable

PivotCharts

Create PivotCharts

PivotChart Options

PivotChart Styles

Drill-Down Data

Troubleshoot Formulas

Formula Errors

The Watch Window

Evaluate Formulas

Advanced Formatting

Customize Conditional Formatting

Conditional Formatting with Formulas

Manage Conditional Formatting

International Currency and Formats

Body and Heading Options

Color Formats

Custom Themes

Form Controls

Save Form Templates

Advanced Formulas

IF Function

Nested Functions

AND, OR, and NOT Functions

SUMIF, AVERAGEIF, and COUNTIF Functions

VLOOKUP

HLOOKUP

INDEX and MATCH

UPPER, LOWER, and PROPER

RIGHT, LEFT, and MID

Formula Calculation Options

Analyze Data

Goal Seek

Scenario Manager

Consolidate Data

Macros

Enable Macros

Create Macros

Modify Macros

Copy Macros

• 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 2013Introduction
• Microsoft Excel 2013 Intermediate
• Microsoft Excel 2013 Advanced
• Microsoft Excel 2010 Introduction
• Microsoft Excel 2010 Intermediate
• Microsoft Excel 2010 Advanced

Microsoft Value Pack (Best Deal)