Excel Expert (Advanced Level 2) Course Details

Excel Expert

• Review Exercise

Auditing a Worksheet

• Using Worksheet Auditing Tools
• Data Entry Validation
• Validating the Whole Worksheet
• Auditing Data Dependency
• Finding and Replacing Data

Working with Data Lists

• Setting Up Lists
• Sorting Lists
• Filtering Lists
• Using Forms

Data Management

• Searching for Data with Advanced Filters
• Compiling Consolidations
• Summarising Data with Outlines
• Querying a Database
• Data Sources
• Controlling Formatting and Layout
• Refreshing External Data

PivotTables

• Creating a PivotTable
• Modifying a PivotTable
• Creating a PivotTable Chart
• Creating Interactive PivotTables for the Web

Using Analysis Tools

• Goal Seeking
• Using Solver
• The Scenario Manager
• Scenario Summaries
• Merging Scenarios

Collaborating with Workgroups

• Applying Worksheet Protection
• Password Protecting a File
• Changing Workbook Properties
• Adding Comments to the Worksheet
• Shared Workbooks
• Tracking Changes
• Resolving Conflicts
• Merging Workbooks
• E-mailing Workbooks for Review