Microsoft
Excel 2000 Advanced
CEXC2KA
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