Microsoft Excel 2000 Level 3
Customizing the work area
Working with built-in toolbars
Using custom toolbars
Creating and using styles
Using templates
Advanced formula construction
Using names
Using the IF function
Using the VLOOKUP function
Using IS functions and the Auditing features
Using pivot tables
Creating pivot tables
Modifying pivot tables
Grouping and summarizing data in a pivot table
Working with multiple worksheets
Working with workbooks
Linking cells in different workbooks
Workbook versus links and workspaces
Consolidating and analyzing data
Consolidating data from more than one worksheet
Using the Goal Seek and Solver utilities
Using Scenario Manager to view a worksheet with different input values
Using protection and display options
Using comments
Protecting workbooks
Using custom views
Introduction to macros
Running macros
Recording a macro
Viewing and editing VBA code
Working with interactive Excel Web documents
Saving Excel worksheets as Web documents
Spreadsheet Web Components
Class Information
Duration: 1 day
Prerequisite: Microsoft Excel 2000 Level 2 or equivalent experience.
Course Materials: Course manual (074202S3)
Description: Students will learn various advanced techniques for analyzing and manipulating data in Excel. Students will learn how to create templates, how to create decision-making functions, analyze worksheet data by creating pivot tables, display and protect worksheet data by locking cells, record and modify macros by using the Visual Basic Editor, and more.