Excel 2003 Advanced Skills
Excel
Training
Provided by MaxIT Corporation
This self-paced training courseware will develop advanced user skills in effectively using Microsoft Excel 2003. The training methodology in this courseware is "learn by doing" where the user performs common tasks and develops skills in a rich, interactive simulation of the application. This training also includes a true performance based skill assessment, printable job aids, a searchable index, optional audio and a complete glossary of terms.
This training will run under Internet Explorer and requires no plug-ins. If using audio, you will need a sound card.
With an additional license, this training includes an authoring tool that allows you to customize the existing content and add additional topics unique to your needs.
This training will run under Internet Explorer and requires no plug-ins. If using audio, you will need a sound card.
With an additional license, this training includes an authoring tool that allows you to customize the existing content and add additional topics unique to your needs.
|
|
||||||||||||||||||
Excel 2003 Advanced Skills
Macros and Custom Toolbars
1. Working with Macros
2. Custom Toolbars
Named Ranges and Lookup Functions
1. Working with Named Ranges
2. Lookup Functions
Working with Data
1. Importing Data
2. Conditional Formatting
3. Data Validation
4. Outlining
Consolidation and Linking
1. Creating a Workspace
2. Consolidating Data
3. Linking Workbooks
Group Editing
1. Sharing and Protecting
2. Working with Comments
3. Tracking Changes
Audit, Scenarios, Views and Reports
1. Auditing Tools
2. The Scenario Manager
3. Custom Views
4. The Report Manager
Data Filters, Goals and Pivot Tables
1. Data Forms
2. Filtering Data
3. Sorting and Sub-totals
4. Goal Seeker and Goal Solver
5. Pivot Tables
6. Pivot Tables on the Web
1. Working with Macros
2. Custom Toolbars
Named Ranges and Lookup Functions
1. Working with Named Ranges
2. Lookup Functions
Working with Data
1. Importing Data
2. Conditional Formatting
3. Data Validation
4. Outlining
Consolidation and Linking
1. Creating a Workspace
2. Consolidating Data
3. Linking Workbooks
Group Editing
1. Sharing and Protecting
2. Working with Comments
3. Tracking Changes
Audit, Scenarios, Views and Reports
1. Auditing Tools
2. The Scenario Manager
3. Custom Views
4. The Report Manager
Data Filters, Goals and Pivot Tables
1. Data Forms
2. Filtering Data
3. Sorting and Sub-totals
4. Goal Seeker and Goal Solver
5. Pivot Tables
6. Pivot Tables on the Web
About The Training Provider: MaxIT Corporation
MaxIT Corporation - MaxIT is an established developer of self-paced, on-line learning for Microsoft Office and general business skill development.
MaxIT's curriculums for Office 2003/XP/2000 courses are over 80% interactive simulation with introductory, intermediate and advanced topics. Our training features interactive learn-by-doing simulations, printable job aids, searchable help indexes, optional audio and...
