Facebook Pixel
Microsoft Certification Training
Search classes by keyword:
Search classes by category:
Microsoft Certification and Microsoft Training, Cisco Certification and MCSE Certification
Excel 2016 Level 2 space



Microsoft Office Excel 2016 Intermediate Training Course

Excel 2016 - Level 2

Course Number: #CED-1499
Course Length: 1 day

Grants (discounts) are available for multiple students for the same or different courses.

Upcoming Dates Class Times Class Format Quote
Call (800) 611-1840 for Class Schedule


In this course, you will become familiar with intermediate features and functionality of Microsoft Excel 2016.

Course Content

Lesson 1: Managing workbooks
  • Managing worksheets
  • Customizing Excel
Lesson 2: Named ranges
  • Using names in formulas
Lesson 3: Tables
  • Sorting
  • Filtering tables
  • Structured references
  • Validation
  • Transposing data
Lesson 4: Summarizing data
  • Consolidation
  • Subtotals
Lesson 5: PivotTables
  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts
Lesson 6: Presentation features
  • Conditional formats
  • Custom Formats
  • Graphics
Lesson 7: Advanced charts
  • Special chart types
  • Sparklines
  • Quick Analysis
Lesson 8: Collaboration
  • Permissions
  • Shared workbooks

CED Solutions is your best choice for Excel 2016 Level 2, Excel 2016 Level 2 training, Excel 2016 Level 2 certification, Excel 2016 Level 2 boot camp, Excel 2016 Level 2 certification training, Excel 2016 Level 2 certification course, Excel 2016 Level 2 course, Excel 2016 Level 2 class.



Excel 2016 Level 2 space
Search classes by keyword:
Search classes by category:


Copyright © 2018 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.