Excel – Level 2

Description

Overview:

The course builds on the basic concepts and skills of the Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel. Lessons including how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

Prerequisite(s):

Excel Level 1

Audience:

Outline:

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 Format
• Graphics

Lesson 7: Advanced charts

• Special chart types
• Sparklines
• Quick Analysis

Lesson 8: Collaboration

• Permissions
• Comments