CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX203 - Microsoft Excel 2000 Level 2 Advanced

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students will learn various advanced techniques for analyzing and manipulating data in Excel.

Prerequisites

Excel Level 1 or equivalent knowledge

Detailed Class Syllabus

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 doc Worksheets Using Advanced Data Ana

Saving Excel worksheets as Web documents

Spreadsheet Web Components