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 probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. 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, or
- Windows 98: Introduction, or
- Windows NT 4.0: Introduction
- Excel 2000: Worksheets
Target Student
Students enrolling in this course should understand the basic concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.
Performance-Based Objectives
- Customize toolbars and create styles and templates.
- Create decision-making functions.
- Analyze worksheet data by creating PivotTables.
- Compare and contrast workbook files and file links.
- Outline and consolidate worksheets and analyze worksheet data
by using the Scenario Manager.
- Display and protect worksheet data by locking cells.
- Record and modify macros by using the Visual Basic Editor.
- Create and work with interactive Web documents.
What's next
Excel 2000: Advanced is the last course in this series.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Certification
Excel 2000: Advanced is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Benefits
Students will learn how to work with advanced features of Excel 2000
Course duration
1 Day(s)
Course outline
Lesson 1: Customizing the Work Area
- Topic 1A: Working with Built-in Toolbars
- Topic 1B: Using Custom Toolbars
- Topic 1C: Creating and Using Styles
- Topic 1D: Using Templates
Lesson 2: Advanced Formula Construction
- Topic 2A: Using Names
- Topic 2B: Using the IF Function
- Topic 2C: Using the VLOOKUP Function
- Topic 2D: Using IS Functions and the Auditing Features
Lesson 3: Using Pivot Tables
- Topic 3A: Creating Pivot Tables
- Topic 3B: Modifying Pivot Tables
- Topic 3C: Grouping and Summarizing Data in a Pivot Table
- Topic 3D: Creating Interactive PivotTables for the Web
Lesson 4: Working with Multiple Worksheets
- Topic 4A: Working with Workbooks
- Topic 4B: Linking Cells in Different Workbooks
- Topic 4C: Workbook versus Links and Workspaces
- Topic 4D: Sharing and Merging Workbooks
Lesson 5: Consolidating and Analyzing Data
- Topic 5A: Consolidating Data from More than One Worksheet
- Topic 5B: Using the Goal Seek and Solver Utilities
- Topic 5C: Using Scenario Manager to View a Worksheet
with Different Input Values
Lesson 6: Using Protection and Display Options
- Topic 6A: Using Comments
- Topic 6B: Protecting Workbooks
- Topic 6C: Using Custom Views
Lesson 7: Introduction to Macros
- Topic 7A: Running Macros
- Topic 7B: Recording a Macro
- Topic 7C: Viewing and Editing VBA Code
Lesson 8: Working with Interactive Excel Web Documents
- Topic 8A: Saving Excel Worksheets as Web Documents
- Topic 8B: Spreadsheet Web Components
Hardware/software Requirements
You will need:
- A 486-compatible PC that meets minimum hardware requirements
for Windows 95 or later or Windows NT 4.0 or later. (A Pentium 90 with 32
megabytes (MB) of Random Access Memory (RAM) or better is recommended.)
- 500 MB of free hard-disk space. (Windows NT only: At least
4 MB of available space in the Registry.)
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for installation purposes.
- A 3.5"-disk drive.
- A two-button mouse or IntelliMouse.
- A VGA or higher display adapter (the EGA display adapter is
not supported).
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- Microsoft Windows 95 or later, or Microsoft Windows NT 4.0
with Service Pack 3 installed.
- Microsoft Office 2000, including a custom installation for
Excel 2000 (see the following section for additional instructions).
