Course Overview
Schedule
Microsoft Excel 2016 Level 2 Training
date
location
3/30/21 - 3/30/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out5/04/21 - 5/04/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out5/06/21 - 5/06/21 (1 days)
8:30AM - 4:30PM EST
Online
Open5/06/21 - 5/06/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open5/06/21 - 5/06/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open5/26/21 - 5/26/21 (1 days)
8:30AM - 4:30PM GMT+1
Stuttgart, Germany
Sold Out7/08/21 - 7/08/21 (1 days)
8:30AM - 4:30PM EST
Online
Open7/08/21 - 7/08/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open7/08/21 - 7/08/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open8/17/21 - 8/17/21 (1 days)
8:30AM - 4:30PM EST
Online
Sold Out9/09/21 - 9/09/21 (1 days)
8:30AM - 4:30PM EST
Online
Open9/09/21 - 9/09/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open9/09/21 - 9/09/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open11/23/21 - 11/23/21 (1 days)
8:30AM - 4:30PM EST
Online
Open11/23/21 - 11/23/21 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open11/23/21 - 11/23/21 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open![[image]](https://phoenixts.com/wp-content/themes/phoenixts-com/assets/images/temp/image-9@2x.jpg)
Not seeing a good fit?
Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.
Learn more about custom training
Course Outline
Managing workbooks
- Managing worksheets
- Customizing Excel
Named ranges
- Using names in formulas
Tables
- Sorting
- Filtering tables
- Structured references
- Validation
- Transposing data
Summarizing data
- Consolidation
- Subtotals
PivotTables
- Creating and formatting PivotTables
- Manipulating PivotTables
- PivotCharts
Presentation features
- Conditional formats
- Custom Formats
- Graphics
Advanced charts
- Special chart types
- Sparklines
- Quick Analysis
Collaboration
- Permissions
- Shared workbooks