Class Details

MS Excel Level 3 (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: Logical and Lookup Functions

   Module A: Decision-making functions

   Module B: Lookup and reference functions

Chapter 2: Advanced Formulas

   Module A: Auditing and error-trapping

   Module B: Formula options

   Module C: Arrays

Chapter 3: Special functions

   Module A: Date and time functions

   Module B: Text functions

   Module C: Other functions

Chapter 4: Importing and Exporting

   Module A: The Power Pivot Data Model

   Module B: Exporting data

Chapter 5: Analysis

   Module A: What-if analysis

   Module B: The Analysis Toolpak

Chapter 6: Macros and Forms

   Module A: Recording macros

   Module B: Running macros

   Module C: Forms

Appendix A: Internationalization and Accessibility

   Preparing workbooks for internationalization and accessibility