Internationally accredited computer education and computer training. Business and franchise opportunity.
ICE COURSE 
EXCEL 97

CERTIFIED, INTEGRATED, MULTIMEDIA
TRAINING SPECIALISTS
1000's of Windows Certified Courses
BACK TO ICE COURSE LIST
Tel: 021 988-6402
Fax: 021 988 9417
COURSES PAGE

 
HERE'S WHAT YOU GET FROM ICE
Over 1000 courses to choose from!
Get your Internationaly accredited computer courses & qualification!
Microsoft Aproved Multimedia CD ROM or Video courses
Backed by City & Guilds of London / Pastel Accounting 
In house, online and / or distance training & support.

BC SALES 
& SERVICES

Specialists in:
Computers
Software
Hardware
Training
Networking
Installations
Internet support
On site support

You set your limits:
MCSE, C++, A+
PASTEL ACCOUNTING, & more, more, more..
ORDER FORM
Please fill in this form if you want to know more about this course, or if you want to purchase this course.
First Name / Last Name

Address

Telephone

Fax 

Email

Any comments? 


Please note that all material, pricing and information is subject to change at the sole discretion of Bc Sale& Services
ORDER / CONTACT FORM

EXCEL 97

INTRODUCTION

    • Screen components
    • Using the Undo command
    • Standard and Formatting toolbars
    • Closing the workbook
    • The Formula bar
    • Moving around the workbook
    • The workbook
    • Naming the workbook
    • Using the keyboard
    • Using a template
    • Selecting a range
    • Using AutoFill
    • Aligning numbers
    • Entering formulas
    • Formatting cells
    • Using the AutoSum Function
    • Using the Toolbar buttons
    • Copying formulas
    • Widening a column
    • Changing the font, point size
    • Changing the column width
    • Copying formats
    • Changing the row height
    • Printing the worksheet
    • Changing cell alignment
    • The Print Dialog box, Print Preview
    • Clearing, deleting data
    • Discussing Page Setup

    EXCEL INTERMEDIATE
    • Adding worksheet panes
    • Using the VLOOKUP function
    • Removing the worksheet
    • Describing Arrays
    • Freezing worksheet panes
    • Using the Trend function
    • Hiding columns
    • Creating/using names
    • Hiding rows
    • Linking workbooks
    • Using the Insert options
    • Using Reference formulas
    • Viewing the Delete options
    • Linking worksheets
    • Using an outline
    • Changing the workbook appearance
    • Explaining Formula options
    • Showing Spell check options
    • Using an Absolute cell reference
    • Arranging windows
    • Using the IF statement
    • Copying between worksheets
    • Describing the Function wizard
    • Using the Chart wizard
    • Using the Payment function
    • Rotating text
EXCEL ADVANCED
    • Creating a Custom toolbar
    • Using Wildcard characters
    • Moving toolbars
    • Using the Sort command
    • Using Explanatory remarks
    • Sorting by option
    • Using a custom AutoFill list
    • Filtering
    • Creating custom formats
    • Using the AutoFilter
    • Using the AutoSum button
    • Using Automatic subtotals
    • Outlining the worksheets
    • Creating a template
    • Working in multiple worksheets
    • Protecting cells
    • Changing cell styles
    • Using the Pivot table
    • Redefining a style
    • Using the Scenarios option
    • Merging styles
    • Demonstrating the Text Import wizard
    • Viewing with a Data form
    • Sharing the workbook


I.C.E. Email

BC SALES & SERVICES
OFFERS YOU THE VERY BEST TRAINING AVAILABLE.
 Our training is Microsoft Certified 

and Internationaly accredited. 

You set your limits:
MCSE, C++, A+
PASTEL ACCOUNTING, & more, more, more...
All material on this domain is subject to copyright
& may not be reproduced in any way without written
permission from BC Sales
copyright20/11/99. All rights reserved.
This site was developed and designed by

Try us for best value.
Tel: +27 (0)21 965086 / Fax: +27 (0)21 975 4707
Mobile: 082 82 11 999