×
Microsoft

Microsoft Excel 2016 Level 2 Training

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 Out
5/04/21 - 5/04/21 (1 days)

8:30AM - 4:30PM EST

Online
Sold Out
5/06/21 - 5/06/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
5/06/21 - 5/06/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
5/06/21 - 5/06/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
5/26/21 - 5/26/21 (1 days)

8:30AM - 4:30PM GMT+1

Stuttgart, Germany
Sold Out
7/08/21 - 7/08/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
7/08/21 - 7/08/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
7/08/21 - 7/08/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
8/17/21 - 8/17/21 (1 days)

8:30AM - 4:30PM EST

Online
Sold Out
9/09/21 - 9/09/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
9/09/21 - 9/09/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
9/09/21 - 9/09/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
11/23/21 - 11/23/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
11/23/21 - 11/23/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
11/23/21 - 11/23/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
[image]

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.

Contact Us

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
Subscribe now

Get new class alerts, promotions, and blog posts