Course Title: Microsoft Excel 97
With Microsoft Excel 97, you can take advantage of comprehensive tools to easily create spreadsheets. Excel 97 allows you to analyze data with charts and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by author Damienne Fitzpatrick. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert graphics. If you need to know Excel, why not start now? Simply click a topic below.
Course Author/Expert: Damienne FitzPatrick
Language: english
Full Online Training Available: Yes
Number of Course Movies: 96
Course Duration: 11 hours
Never has it been so easy to learn Microsoft Excel 97.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.
Course Outline:
Straight away, you can go through the first three chapters of this tutorial. If you need all the lessons, then join the Online University - complete access to over five hundred and fifty courses right now for as long as you need them and even get an online university certificate. See below for details.
Introduction to Excel
Play Me First
Getting Started
Interface
Save
Simple Printing
Close & Exit
Get Help
Office Assistant
The Basics
Selection Techniques
Enter Data
Edit & Delete Data
Cut, Copy & Paste
Drag & Drop
Undo & Redo
The Fill Handle
AutoCorrect
Spelling
Find & Replace
Worksheet Controls
Navigate A Document
Zoom Control
Insert Cells
Delete Cells
Resize Rows & Columns
Hide & Unhide
Insert & Delete Worksheets
Move & Copy Worksheets
Views
Splits & Panes
Text & Number Formats
Text Formats
Align & Text Wrap
Special Alignment Effects
Borders & Shading
Number Formats
Date & Time Formats
Custom Formats
Format Painter
AutoFormat
Conditional Formats
Styles
Simple Calculations & Functions
Basic Formulae
Operators
Relative References
Absolute References
Sum Function
The Function Wizard
If, And, Or
Nested Ifs
Lookup
V & H Lookup
Trends
Analyses & Databases
Goal Seek
One-Input Tables
Two-Input Tables
Scenarios
Scenario Summaries
Pivot Tables
Create A Database
Sort Data
Filter Data
Advanced Filtering
Set Criteria
Database Functions
Optimizing Techniques
Custom Lists
Paste Special
Name Cells & Ranges
Linking
Consolidation
Automatic Subtotals
Validation
Outlining
Protect Cells
Print Preview
Headers & Footers
Print Areas
Customizing Toolbars
Create A VBA Macro
Edit A Macro
Charts
Chart Data
Create a Chart
Chart Palette
Text & Data Labels
Axes & Gridlines
Chart & Plot Area
The Legend
Edit The Series
Custom Charts
Graphics
Insert A Picture
Resize & Reposition
Create A Graphic
Shapes , Fills, Borders & Effects
Lines - Colors, Sizes & Arrows
Select, Layer & Group
Snap To & Flip
Text In Drawings
WordArt
Organization Chart
To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.
or
Click Here and we'll send you the training CD itself for Microsoft Excel 97 at £79.95
|
|
Add latest courses to Google Toolbar