Class Details

MS Excel Level 2 (2016) Price: $299

Price Match Guarantee Phoenix TS

1-Day Course Includes:

  • Class exercises in addition to training instruction
  • Courseware books, notepads, pens, highlighters and other materials
  • Course retake option 
  • Full breakfast with variety of bagels, fruits, yogurt, doughnuts and juice
  • Tea, coffee, and soda available throughout the day
  • Freshly baked cookies every afternoon - *only at participating locations

Redeem Training for FREE with Microsoft SATVs

For group training options please contact our Training and Certification Consultants at (240) 667-7757 or email sales@phoenixts.com.

Course Outline

Chapter 1: Managing workbooks

   Module A: Managing worksheets

   Module B: Customizing Excel

Chapter 2: Named ranges

   Module A: Using names in formulas

Chapter 3: Tables

   Module A: Sorting

   Module B: Filtering tables

   Module C: Structured references

   Module D: Validation

   Module E: Transposing data

Chapter 4: Summarizing data

   Module A: Consolidation

   Module B: Subtotals

Chapter 5: PivotTables

   Module A: Creating and formatting PivotTables

   Module B: Manipulating PivotTables

   Module C: PivotCharts

Chapter 6: Presentation features

   Module A: Conditional formats

   Module B: Custom Formats

   Module C: Graphics

Chapter 7: Advanced charts

   Module A: Special chart types

   Module B: Sparklines

   Module C: Quick Analysis

Chapter 8: Collaboration

   Module A: Permissions

   Module B: Shared workbooks

Register for Class

Date Location
01/09/19 - 01/09/19, 1 days, 8:30AM – 4:30PM Hunt Valley, MD Register