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

Top

Training Service

Back to Bulletin Table of Contents

classes available