This
course will prepare you to get the most out of this feature-rich
program, Excel 97. Learn how to manipulate formulas, transform
ordinary data into meaningful charts, utilize layout options
and much more. Every Excel 97 user will learn valuable information
to help them in their professional or personal life.
Excel
97 (Beg/Int/Adv):
3
Fully-Interactive CD-ROMs
Free
Shipping (in U.S.)
Online:
$119.00
Excel
97 (Beg/Int/Adv):
3
High-Quality Video Tapes
Free
Shipping (in U.S.)
Online:
$119.00
Order
with absolute confidence, all Order pages...
Detailed Course
Outline
Beginning
1.0
Introduction to Excel (22 min)
1.1 Orientation
1.2 Tools
1.3 The Worksheet
1.4 Using the Keyboard to Navigate 2.0 Data Entry (39 min)
2.1 Text
2.2 Selecting Cells
2.3 Values
2.4 Entering Formulas
2.5 Auto-Sum for Totals
2.6 The Average Function 3.0 Changing Worksheet Appearance (14 min)
3.1 Simple Formatting
3.2 Fill & Font Colors
3.3 Undo
3.4 Borders
4.0
File Management (14 min)
4.1 Saving Your Work
4.2 Opening a File
4.3 Creating a New Workbook
4.4 Closing a File 5.0 Additional Formulas (20 min)
5.1 Cumulative Totals
5.2 % Change
5.3 Formula Symbols
5.4 Editing Formulas
5.5 Auto Calculate Feature 6.0 Formatting Features (14 min)
6.1 Changing the Font Type & Size
6.2 Inserting Rows & Columns
6.3 Copying & Moving Data in a Worksheet 7.0 Printing Worksheets (13 min)
7.1 Print Review
7.2 Printing Selections
7.3 The Print Button & Exiting Out of Excel
1.0
Logical Function (34 min)
1.1 If Statement
1.2 Modifying the If Statement
1.3 Vertical Lookup
1.4 Horizontal Lookup 2.0 Split Screen Techniques (11 min)
2.1 Horizontal Split
2.2 Freeze Panes
2.3 Vertical Slit
2.4 Creating a Double Freeze 3.0 AutoFill Techniques (15 min)
3.1 AutoFill
3.2 Dates Using AutoFill
3.3 Series Extension 4.0 Data Validation Techniques (13 min)
4.1 Validating Data
4.2 The Auditing Toolbar & Keyboard Shortcuts
5.0
Excel Databases(35 min)
5.1 Sorting Data
5.2 Sorting From the Toolbar
5.3 Data Sort Command
5.4 Creating Subtotals
5.5 Filtering 6.0 Range Names (9 min)
6.1 Naming Cells 7.0 Additional Charting Capabilities (24 min)
7.1 Formatting the X & Y Axis
7.2 Changing the Chart Style
7.3 Changing Line Attributes
7.4 Utilizing Drawing Tools
Meet
the Trainer
Dennis P. Taylor has spent over 14 years presenting PC software
training to individuals in classrooms and seminars, including
employees at Amoco, IBM, and many other companies. He specializes
in spreadsheet software and has co-authored several books
for spreadsheets. Five years ago he turned his attention to
Excel spreadsheets and has become an Excel training specialist.
Dennis brings a combination of in-depth knowledge and training
experience to this course. Watch and learn in minutes with
Dennis.
Order
with complete confidence, all Order pages...
Aaron's Computer Training is your online source
for MCSE and A+ Certification computer training courses. We
also offer a complete suite of computer training certification
beyond A+ and MCSE Certification. Some of our most popular
classes are: Microsoft Office, MOUS, Linux, and Oracle.
Call
for Orders or Questions:1-800-617-5586
Toll Free ! Customer Service Hours: 9:00am-5:00pm, eastern
time, Monday - Friday aarons@aarons-computer-training.com
Excel
97 Computer Certification Training
This
course will prepare you to get the most out of this feature-rich
program, Excel 97. Learn how to manipulate formulas, transform
ordinary data into meaningful charts, utilize layout options
and much more. Every Excel 97 user will learn valuable information
to help them in their professional or personal life.
