| |
|
| |
Advanced Data Manipulation and Analysis in Excel 2002 Training Class |
|
| |
|
|
| |
|
|
| |
Advanced Data Manipulation and Analysis in Excel 2002 Training Seminar
To provide an overview of the advanced data manipulation and analysis features in Excel 2002
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
Using macros in Excel 2002
- use macros in Excel 2002.
Recording and running a macro in Excel 2002
- record and run a macro in Excel 2002.
Editing and deleting macros in Excel 2002
- edit and delete macros in Excel 2002.
Editing a macro in Excel 2002
- edit a macro in Excel 2002.
Using macros with command buttons in Excel 2002
- assign a macro to a command button in Excel 2002.
Creating and modifying macros in Excel 2002
- create and modify a macro in Excel 2002.
Importing data in Excel 2002
- import data from other applications into an Excel 2002 workbook.
Importing data from the Web into Excel 2002
- import data from the Web into Excel 2002.
Importing an HTML table into Excel 2002
- import an HTML table into Excel 2002.
Exporting Excel 2002 data to other applications
- export data from Excel 2002 to other applications.
Exporting Excel 2002 data to the Web
- export data from Excel 2002 to a web page.
PivotTable reports in Excel 2002
- create and modify PivotTable reports in Excel 2002.
Creating a PivotTable report in Excel 2002
- create and modify a PivotTable report in Excel 2002.
PivotTable calculations in Excel 2002
- perform calculations on PivotTable reports in Excel 2002.
Performing PivotTable calculations in Excel 2002
- perform PivotTable calculations in Excel 2002.
Publishing Excel 2002 PivotTable reports to the Web
- save and manipulate Excel 2002 PivotTable reports on the Web.
PivotChart reports in Excel 2002
- create and modify PivotChart reports in Excel 2002.
Working with Goal Seek and Solver in Excel 2002
- use the Goal Seek and Solver tools in Excel 2002.
Using Solver in Excel 2002
- use Solver to find a target value in Excel 2002.
Working with scenarios in Excel 2002
- use scenarios to analyze data in Excel 2002.
Creating a scenario in Excel 2002
- create a scenario in Excel 2002.
Working with data tables in Excel 2002
- create data tables and discuss their uses 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
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
The Microsoft Office XP: Beginning Excel 2002 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 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
|
|
| |
|
|
|
| |
| |
|
|
|
|