Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Excel 2016 Advanced Course

Microsoft Excel 2016 Advanced Onsite Group Training Course


Course Description: The Microsoft Excel 2016 advanced course helps the students gain a high level of productivity with the software. This course covers advanced level topics, and is recommended this course for students who have extensive experience using Excel 2016.

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

  • Working with the Web and External Data
  • Working with Macros
  • Working with Objects
  • Other Advanced Topics

Microsoft Excel 2016 Advanced - Course Syllabus
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
  • 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