Become a member

Online Access to 1000+ Courses!

Microsoft Excel 97 Course

Author : Damienne FitzPatrick

11hrs (96 Lessons) 1996-01-01

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

Course: Microsoft Excel 97
Author: Damienne FitzPatrick
SKU: 33033
ISBN: 1889347310
Work Files: Yes
Captions: No
Subject: Business Applications
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Microsoft Excel 2013
Author : Helen Bradley

7.5 / 116 2013-03-28

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Introduction to Excel

Play Me First (01:19)

Getting Started (12:22)

Interface (09:42)

Save (06:43)

Simple Printing (03:28)

Close & Exit (03:40)

Get Help (11:29)

Office Assistant (03:47)

The Basics

Selection Techniques (06:53)

Enter Data (08:56)

Edit & Delete Data (04:29)

Cut, Copy & Paste (10:58)

Drag & Drop (06:03)

Undo & Redo (06:04)

The Fill Handle (11:13)

AutoCorrect (05:06)

Spelling (02:58)

Find & Replace (09:23)

Worksheet Controls

Navigate A Document (05:30)

Zoom Control (02:23)

Insert Cells (06:28)

Delete Cells (02:38)

Resize Rows & Columns (05:56)

Hide & Unhide (03:13)

Insert & Delete Worksheets (05:39)

Move & Copy Worksheets (05:18)

Views (05:08)

Splits & Panes (05:35)

Text & Number Formats

Text Formats (07:03)

Align & Text Wrap (09:35)

Special Alignment Effects (07:30)

Borders & Shading (09:41)

Number Formats (09:33)

Date & Time Formats (02:53)

Custom Formats (09:42)

Format Painter (02:24)

AutoFormat (02:32)

Conditional Formats (03:29)

Styles (03:57)

Simple Calculations & Functions

Basic Formulae (10:46)

Operators (03:41)

Relative References (02:52)

Absolute References (10:20)

Sum Function (06:30)

The Function Wizard (09:59)

If, And, Or (11:51)

Nested Ifs (13:38)

Lookup (04:38)

V & H Lookup (07:02)

Trends (04:28)

Analyses & Databases

Goal Seek (04:28)

One-Input Tables (07:06)

Two-Input Tables (04:09)

Scenarios (10:01)

Scenario Summaries (01:52)

Pivot Tables (10:09)

Create A Database (09:09)

Sort Data (06:53)

Filter Data (09:02)

Advanced Filtering (07:04)

Set Criteria (08:18)

Database Functions (07:53)

Optimizing Techniques

Custom Lists (04:14)

Paste Special (03:17)

Name Cells & Ranges (10:27)

Linking (11:37)

Consolidation (04:21)

Automatic Subtotals (02:58)

Validation (04:41)

Outlining (12:03)

Protect Cells (04:06)

Print Preview (10:44)

Headers & Footers (08:36)

Print Areas (08:38)

Customizing Toolbars (09:23)

Create A VBA Macro (09:16)

Edit A Macro (02:42)

Charts

Chart Data (03:32)

Create a Chart (08:45)

Chart Palette (05:54)

Text & Data Labels (08:23)

Axes & Gridlines (07:18)

Chart & Plot Area (05:27)

The Legend (03:55)

Edit The Series (07:59)

Custom Charts (04:18)

Graphics

Insert A Picture (07:20)

Resize & Reposition (01:53)

Create A Graphic (10:36)

Shapes , Fills, Borders & Effects (07:15)

Lines - Colors, Sizes & Arrows (13:37)

Select, Layer & Group (07:45)

Snap To & Flip (05:46)

Text In Drawings (04:59)

WordArt (06:37)

Organization Chart (09:48)