|
Provided by: Serebra Learning Corporation Microsoft Excel 97 AdvancedExcel |
 |
Training
Provided by Serebra Learning Corporation
This highly interactive CBT contains five units that cover advanced Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to perform "what-if" analysis, create PivotTables, exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long after course completion. This course is designed for individuals who have basic proficiency in Microsoft Excel 97.
|
|
||||||||||
Microsoft Excel 97 Advanced
Audience
This course is designed for individuals who have basic proficiency in Microsoft Excel 97.
Topics
Unit 1: Using What-If Analysis
- Defining a What-If Analysis
- Tracking a What-If Analysis with Scenario Manager
- Generating a scenario summary
- Projecting Figures Using a Data Table
- Creating a Two-Input Data Table
- Using Goal Seek
- Setting Up a Complex What-If Analysis with Solver
- Running Solver and Generating an Answer Report
Unit 2: Summarizing Data with PivotTables
- Planning and Designing a PivotTable
- Creating a PivotTable
- Changi
Objectives
Upon completion of this course, the student will be able to:Define and track a what-if analysis, generate a scenario summary Create and manipulate data tables, and use Goal Seek and Solver Create and manipulate a PivotTable, create a chart from a PivotTable and use tthe GETPIVOTDATA function Import text files, database tables, and graphic files into a worksheet, embed and link a worksheet Paste an Excel chart into a PowerPoint slide, and convert a list to an Access table Find files, audit and outline a worksheet, control worksheet calculations Create custom AutoFill lists, customize Excel, and save a workbook as a template View, analyze, and write VBA code, add a conditional statement, and prompt for data Debug a macro and create and run a main procedure
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...
