Search classes by keyword:	Search classes by category:

(800) 611-1840
(770) 937-0140

Training Classes Available throughout the USA and Canada

Microsoft Partner, Microsoft Office Specialist, Cisco Partner, CompTIA Gold Partner, SCP Partner, EC-Council Training, Novell Gold Training Partner, CIW Partner, Prometric Training Center, Pearson Vue Test Center, Measure Up Training

Microsoft Office Excel 2016 Intermediate Training Course

Microsoft 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*

Instructor-Led

Certified Instructor
Includes all course materials

CED Solutions Rewards Points Program

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.

(800) 611-1840
(770) 937-0140

Follow CED