Microsoft
Excel 2000 Advanced
Class
Type
Basic Operation
System PC Hardware/Software
Duration 4.5 days
Class Audience Office Assistants, Managers at all levels, Technicians, Service Representatives, Engineers,
Desk and Non-Desk Workers at all levels, Salespersons at all levels and PUBLIC
AT LARGE
Offered At Customer site or St Paul
# Of Students Minimum 5 Maximum 12
Cost $2110 per person at site, $1827 per person St Paul
Pre-requisites None
Brief Microsoft Excel 2000 is a spreadsheet program. This class is about programming Excel using
the Visual Basic macros. To this end a detailed overview of Visual Basic is presented. This
is followed by an introduction to Excel functions reference. Program segments are used to
illustrate the working of the programming language. It is then shown how VB is used to gain
control of Excel. This is followed by advanced VBA programming and building solutions
with VBA.
Throughout the class the instructor presents a motivation, discussion and online
demonstration for each topic/function
available in Excel
2000.
The students then practice the topic/function on the provided systems using provided
detailed lab exercises.
Objectives Upon completion of the course the student will be able to:
· Use Excel to perform all operator functions for a spreadsheet
· Use Excel functions, and add-inns
· Customize Excel
· Create charts, and use advanced charting functions
· Create, use and manage Excel databases
· Use Microsoft Query
· Analyze Excel data using Analysis ToolPak
Topics
· Excel spreadsheets and workbooks
· Advanced Excel worksheet features
· Charts and graphics
· Excel Databases
· Data analysis
Back to Bulletin Table of Contents