Class Details

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

MS Excel Level 1, 2 & 3 (2016) Price: $600

Price Match Guarantee Phoenix TS

5-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

Course Outline

Preparing workbooks for internationalization and accessibility

Chapter 1: Fundamentals

Module A: Getting around

Module B: Workbook basics

Chapter 2: Creating worksheets

Module A: Entering data

Module B: Formulas

Module C: Functions

Module D: Moving and copying data

Module E: Reference types

Chapter 3: Formatting

Module A: Text formatting

Module B: Number formatting

Module C: Alignment

Module D: Borders and highlighting

Module E: Styles and themes

Chapter 4: Manipulating data

Module A: Data entry shortcuts

Module B: Paste options

Module C: Inserting, deleting, and hiding

Chapter 5: Charts

Module A: Creating charts

Module B: Chart types and elements

Chapter 6: Output

Module A: Managing worksheet windows

Module B: Printing worksheets

Module C: Sharing workbooks

Chapter 7: Settings and templates

Module A: Workbook options and properties

Module B: Templates

Chapter 8: Managing workbooks

Module A: Managing worksheets

Module B: Customizing Excel

Chapter 9: Named ranges

Module A: Using names in formulas

Chapter 10: Tables

Module A: Sorting

Module B: Filtering tables

Module C: Structured references

Module D: Validation

Module E: Transposing data

Chapter 11: Summarizing data

Module A: Consolidation

Module B: Subtotals

Chapter 12: PivotTables

Module A: Creating and formatting PivotTables

Module B: Manipulating PivotTables

Module C: PivotCharts

Chapter 13: Presentation features

Module A: Conditional formats

Module B: Custom Formats

Module C: Graphics

Chapter 14: Advanced charts

Module A: Special chart types

Module B: Sparklines

Module C: Quick Analysis

Chapter 15: Collaboration

Module A: Permissions

Module B: Shared workbooks

Chapter 16: Logical and Lookup Functions

Module A: Decision-making functions

Module B: Lookup and reference functions

Chapter 17: Advanced Formulas

Module A: Auditing and error-trapping

Module B: Formula options

Module C: Arrays

Chapter 18: Special functions

Module A: Date and time functions

Module B: Text functions

Module C: Other functions

Chapter 19: Importing and Exporting

Module A: The Power Pivot Data Model

Module B: Exporting data

Chapter 20: Analysis

Module A: What-if analysis

Module B: The Analysis Toolpak

Chapter 21: Macros and Forms

Module A: Recording macros

Module B: Running macros

Module C: Forms

Appendix A: Internationalization and Accessibility

Register for Class

Date Location
06/04/19 - 06/06/19, 3 days, 8:30AM – 4:30PM Oak Island, WA Sold Out!