| |
|
| |
Advanced Data Analysis in Excel 2003 Training Class |
|
| |
|
|
| |
|
|
| |
Advanced Data Analysis in Excel 2003 Training Seminar
To provide an overview of the advanced data manipulation and analysis features in Excel 2003
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
PivotTable reports in Excel 2003
- create and modify PivotTable reports in Excel 2003.
PivotTable calculations in Excel 2003
- perform calculations on PivotTable reports in Excel 2003.
Creating a PivotTable report in Excel 2003
- create and modify a PivotTable report in Excel 2003.
PivotChart reports in Excel 2003
- create and modify PivotChart reports in Excel 2003.
Creating a PivotChart report in Excel 2003
- create and edit a PivotChart report in Excel 2003.
Working with Goal Seek and Solver in Excel 2003
- use the Goal Seek and Solver tools in Excel 2003.
Working with scenarios in Excel 2003
- employ scenarios to analyze data in Excel 2003.
Working with data tables in Excel 2003
- create data tables and outline their uses in Excel 2003.
Applying advanced data analysis in Excel 2003
- use data-analysis tools in Excel 2003 to forecast values in a workbook.
|
|
|
|
| |
|
|
| |
Audience |
|
| |
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
Familiarity with the Windows 2000 or XP user environments
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|