Microsoft
Excel 2000 Basic
CEXC2KB
Microsoft Excel 2000 Basic
Class Type
Basic Operation
System PC Hardware/Software
Duration
2.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
$1172 per person at site, $1015 per person St Paul
Pre-requisites
None
Brief Microsoft Excel 2000 is a spreadsheet program. The class jump starts with an
Excel spreadsheet and works through the concepts of managing workbooks,
windows and sheets. Entering, editing, formatting and printing worksheets is
discussed next.
Students learn to use Excel functions, Excel Add-ins, Excel customization and
Excel solution templates. This is followed by creating charts and graphics. The class also discusses the creation and use of Excel databases. This includes the
advanced topics of Query Wizard and using Microsoft Query. The class is
then led into data analysis. This includes items such as building scenarios,
auditing and validating worksheets, pivoting tables, mastering Excel’s solver
and Goal Seek and mastering the Analysis ToolPak
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