'Working with Zilcom was a pleasure. Angela, our Sage Trainer was both easy to work with and helpful, throughout the installation 
of our software.' 
Wakely Engineering 

 

Accounting and
Internet Solutions
for Growing Businesses

Home
Up
About us
Training Courses
Sage
Web Services
Links
Contact us

Search for:

 

Microsoft Excel 97: Introduction

 Introduction            This course will benefit users who are new to MS Excel 97 and wish to gain a basic understanding of the product.

 Aims                       The delegate will gain a broad but basic working knowledge of the MS Excel 97 spreadsheet package.

 Designed for           Knowledge and experience in using a Windows 95 or NT environment is required. Participants should have either attended the "Microsoft Windows - Introduction" or attained a similar level of proficiency.

 Duration                  1 day

 Topics                     Excel 97

 Introduction

Menu and dialog boxes
Screen Layout
Office Assist interactive help

Worksheet

Creating & saving spreadsheets
Entering data, selecting cells, Cut, copy & paste
Constructing simple formula
Introduction to the AutoSum function
Changing cell colours, fonts, borders and shading

  Charts

The Chart Wizard
Enhancing charts - legends and titles

  Printing

Previewing options
Page Setup options
Printing options

Follow Up:

Excel for Windows Intermediate - 1 day
Excel for Windows Advanced - 1 day

  Microsoft Excel 97: Intermediate 

Introduction             The course will benefit delegates who want to advance their knowledge of the product in a broad but substantial way.

 Aims                        Delegates will achieve the relevant knowledge to allow them to create professional documents using the more advanced features of excel.

 Designed for           Participants should have attended the "Microsoft Excel - Introduction" or have a working knowledge of MS Excel. 

Duration                  1 day

Topics:                     

Review of basic skills

Review of topics covered in Excel for Windows - Introduction

Worksheet

Absolute cell references
Range names
Customs lists
Using the function wizard
Statistical functions
IF functions, LOOKUP functions
Goal Seeker

 Charts

Creating bar and line charts from a worksheet
Chart options
Chart enhancements with text, colour and shapes

  Databases

Creating a database
Sorting information
Filtering information

 Printing

Basic skills: ranges, headers, footers, page breaks
Printing charts separately and with data
Printing titles

Follow Up:    Excel for Windows Advanced - 1 day


                       Microsoft Excel 97: Advanced

 Introduction            Delegates who are experienced in using the MS Excel application package will benefit form learning the more specialist features.

 Aims                        Delegates will acquire the skills to enable them to use the more advanced features of Excel.

 Designed for           Participants should have attended the "Microsoft Excel - Intermediate" or have a thorough working knowledge of MS Excel. 

Duration                  1 day

Topics:                    

Review of basic skills

Review of topics covered in Excel for Windows - Intermediate

File Linking

Referencing different sheets in the same spreadsheet file
Referencing external spreadsheet files

Data Consolidation

Scenario Manager

Auditing Toolbar

Functions

Lookup functions
Logical functions
Nested IF functions

  Database

Working with data tables
Pivot tables

  Security

Protecting cells and worksheets
Hiding cells and sheets

  OLE

Copying objects
Embedding objects
Linking objects

 

Zilcom Systems Limited, Charlestown, Tallanstown, Dundalk, Co.Louth
Tel: +353 41 68 55 016  Fax: +353 41 68 55 366
E-Mail: info@zilcom.com