This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
Students will learn the skills and concepts necessary to work with advanced features of Excel 97. Students should have a basic knowledge of the concepts involved in using Excel 97. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.
Prerequisites
To ensure students’ success with this course, we recommend that they first take the following Content courses or have equivalent knowledge:
- Windows 95: Introduction
- Excel 97: Worksheets (Windows 95)
Performance-Based Objectives
- Customize toolbars and create styles and templates.
- Create nested and decision making functions.
- Analyze worksheet data by creating pivot tables.
- Compare and contrast workbook files and file links.
- Outline and consolidate worksheets; analyze worksheet data by using the Solver
and Scenario Manager.
- Display and protect worksheet data by locking cells.
- Record and modify macros by using the Visual Basic Editor.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Customizing the work area
- Topic 1A: Working with existing toolbars
- Topic 1B: Creating a toolbar
- Topic 1C: Creating and using styles
- Topic 1D: Creating templates
Lesson 2: Advanced formula construction
- Topic 2A: Nested functions
- Topic 2B: The IF function
- Topic 2C: The VLOOKUP function
- Topic 2D: Error handling and the Auditing features
Lesson 3: Pivot tables
- Topic 3A: Creating pivot tables
- Topic 3B: Working with pivot tables
- Topic 3C: Viewing pivot tables at different levels
Lesson 4: Multiple file linking
- Topic 4A: Working with workbooks
- Topic 4B: Linking individual cells
- Topic 4C: Workbooks versus links and workspaces
Lesson 5: Consolidating data and using analysis tools
- Topic 5A: Consolidating worksheets
- Topic 5B: Using the Goal Seek and Solver utilities
- Topic 5C: Creating a scenario by using Scenario Manager
Lesson 6: Protect and display options
- Topic 6A: Using comments
- Topic 6B: Protecting the worksheet
- Topic 6C: Hiding information
- Topic 6D: Custom views
Lesson 7: Introduction to macros
- Topic 7A: Running a macro
- Topic 7B: Recording a macro
- Topic 7C: Viewing and editing VBA code
Appendix A: Sharing data
- Excel 97 file formatsTopic
Appendix B: Using data maps
- Creating a map to chart dataTopic
Appendix C: Importing and exporting data
- Importing and exporting dataTopic
Hardware/Software Requirements
You will need:
- a minimum of 8 megabytes (MB) of Random Access Memory (RAM);
- a minimum of 41 MB of hard-disk space available for Excel, after Windows 95
is installed;
- a 386DX or higher processor (486 recommended);
- a mouse or compatible pointing device;
- a typical installation of Windows 95; and
- a custom installation of Excel 97 from Microsoft Office 97, including the
Solver Add-In.
