|
MICROSOFT EXCEL XP – Specialists
Course Aims:
Participants will learn to use advanced Formulae and Function techniques, including understanding arguments, using Arrays and controlling with Iteration and Circular References. They will also learn about various ways to analyse data using What If tables, Scenario Manager, Solver and Goal Seek. Finally participants will learn advanced database features of Excel including Pivot Tables and linking to external data through MS-Query.
Contents:
Formulas
The Function Wizard
Conventions and SYNTAX of Functions
Understanding Arguments
Working with Arrays
Enter and Edit Arrays
Circular References and Iteration
The Consolidation Command
Conditional Formatting
Monitoring cell values
Applying Conditions Formats
MS-Query
Linking to External Data
Link Management
Adding, Moving and Deleting Fields
Creating and Saving Queries
Changing the Look of Data in the Data Pane
Sorting Data
Specifying Criteria
AND and OR Logic
Specifying Criteria using Expressions
Create OLAP Cubes
Pivot Tables
What are Pivot Tables
The Pivot Table Wizard
Updating Pivot Tables
Consolidating from Multiple Ranges
Modifying the Appearance
Applying Number Formats
Calculation Types and Field Settings
Calculated Fields
Grouping Data
Extracting Detail
Hiding and Showing Detail
Pivot Charts
Statistical Analysis
Goal Seek
1 Variable WhatIf Tables
2 Variable WhatIf Tables
Creating and Deleting Scenarios
Summary Reports
Solver Reports
Target Audience:
Individuals who need to perform “What-If” analysis on their data, and individuals who need to use the advanced database features in Excel to analyse their data.
Duration: 1 Day
Assumed Knowledge:
Prior attendance of the Excel XP Specifics course
printer friendly version
|
