|
Advanced Data Manipulation and Analysis in Excel 2002
(Duration: 4:05:00)
Price: $38.00
Course Code:
114635_eng
Course Catalog(s):
Course Provider:
SkillSoft
12 months
Description:
To provide an overview of the advanced data manipulation and analysis features in Excel 2002
Sections:
- • 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.
|