|
Provided by: 123-CBT Computer Based Training Excel 2000 Expert User |
 |
Course Overview
This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools.
Learn To:
- Create and use templates.
- Retrieve, sort and manipulate data from a list.
- Create and modify shared workbooks.
- Analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools.
Content Emphasis
Skills-Based
Audience
This course is intended for end users that are looking to use the fundamental features of Microsoft Excel 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge, Microsoft Excel 2000 Fundamentals (Course 72030) and Microsoft Excel 2000 Proficient User (Course 72031).
Total Learning Time
6 - 9 Hour(s)
Course Contents
Unit 1: Template and Database Integration
Duration: 2 - 3 Hour(s)- Create a template based on a workbook.
- Create a workbook based on an existing template.
- Modify a template.
- Open a workbook based on a Spreadsheet Solutions template.
- Customize a Spreadsheet Solutions template.
- Enter a record in a list.
- Retrieve specific data in a list by using a criteria.
- Apply filters to a list.
- Summarize the data in a list.
- Query a database.
- Open a table within a database.
- Extract field data from an open database query.
- Define a criteria for retrieving specific data from the selected fields in a database query.
- Run a Web query.
Unit 2: Workbook Capabilities
Duration: 2 - 3 Hour(s)- Create a shared workbook.
- Highlight changes within a shared workbook.
- Accept or reject changes in a shared workbook.
- Display the history of changes made in a shared workbook.
- Merge the changes from one workbook into another workbook.
- Move and copy data from one workbook to another.
- Paste attributes from one workbook to another.
- Link cells in separate workbooks.
- Open two linked workbooks.
Unit 3: Data Analysis and Summary
Duration: 2 - 3 Hour(s)- Create a data map.
- Match the Data Map toolbar buttons with their functions.
- Add a text label to a data map.
- Add a pop-up label to a data map.
- Modify the colors, symbols, functions and sizing of the map data.
- Modify a legend text value or numeric value in a data map.
- Add the map features in a data map.
- Add pushpins to a data map.
- Create a pivot table.
- Match the buttons on the Pivot Table toolbar with their functions.
- Modify the pivot table data.
- Autoformat the pivot table data.
- Consolidate data in a pivot table.
- Create an interactive pivot table for the Web.
- Add a field to an interactive pivot table.
- Show grand totals in a pivot table report.
- Insert subtotals in a list.
- Change the summary function in a pivot table.
- Change the calculation type in a pivot table.
- Create a chart in a new sheet.
- Hide and display the detailed data of a cell.
- Add a record in a list.
- Sort a list in the data table.
- Apply filters to a data list by hiding rows/columns that do not match your criteria with columns/rows labels.
- Validate data to stop incorrect entries by displaying a message for the incorrect data entry in a data table.
- Create a scenario in the data table.
- Modify an existing scenario in the data table.
- Merge scenarios in the data table from one workbook to anoth
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
