Excel Level 2

Audience:

Students will benefit most from this course if they want to use Excel to perform real-world tasks such as rearranging and presenting complex data.

Prerequisites:

The course assumes students know how to use a computer, that they are familiar with Microsoft Windows, and that they have taken the Level 1 course or have equivalent introductory experience with Excel.

Description:

Our Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Excel: 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.

Outline:

Chapter 1: Managing workbooks

• Module A: Managing worksheets
• Module B: Customizing Excel

Chapter 2: Named ranges

• Module A: Using names in formulas

Chapter 3: Tables

• Module A: Sorting
• Module B: Filtering tables
• Module C: Structured references
• Module D: Validation
• Module E: Transposing data

Chapter 4: Summarizing data

• Module A: Consolidation
• Module B: Subtotals

Chapter 5: PivotTables

• Module A: Creating and formatting PivotTables
• Module B: Manipulating PivotTables
• Module C: PivotCharts

Chapter 6: Presentation features

• Module A: Conditional formats
• Module B: Custom Formats
• Module C: Graphics

Chapter 7: Advanced charts

• Module A: Special chart types
• Module B: Sparklines
• Module C: Quick Analysis

Chapter 8: Collaboration

• Module A: Permissions
• Module B: Comments