|
Provided by: Serebra Learning Corporation Advanced Data Manipulation and Analysis in Excel 2002 |
 |
Training
Provided by Serebra Learning Corporation
To provide an overview of the advanced data manipulation and analysis features in Excel 2002 End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
|
|
||||||||
Advanced Data Manipulation and Analysis in Excel 2002
Audience
End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
Topics
Objectives
- Advanced Data Manipulation and Analysis in Excel 2002
- use macros in Excel 2002.
- record and run a macro in Excel 2002.
- edit and delete macros in Excel 2002.
- edit a macro in Excel 2002.
- assign a macro to a command button in Excel 2002.
- create and modify a macro in Excel 2002.
- import data from other applications into an Excel 2002 workbook.
- import data from the Web into Excel 2002.
- import an HTML table into Excel 2002.
- export data from Excel 2002 to other applications.
- export data from Excel 2002 to a web page.
- create and modify PivotTable reports in Excel 2002.
- create and modify a PivotTable report in Excel 2002.
- perform calculations on PivotTable reports in Excel 2002.
- perform PivotTable calculations in Excel 2002.
- save and manipulate Excel 2002 PivotTable reports on the Web.
- create and modify PivotChart reports in Excel 2002.
- use the Goal Seek and Solver tools in Excel 2002. <
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
