Tutorials and Online Training Videos

Microsoft Excel 2000 Tutorial


With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, 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 Lorie Flenner. 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.

Introduction

Getting Started
The Interface
Menus
Toolbars
Formula Bar
Columns & Rows
Scroll Bars
Sheet Tabs
Status Bar
Interface Review
Workbooks & Worksheets
Open and Close Workbooks
Save Workbooks
Getting Help

The Basics

Select and Navigate Cells
Enter Data
Edit and Delete Data
Cut / Copy and Paste
Undo and Redo
Drag and Drop
Auto Fill
AutoCorrect

Working With Worksheets

Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide

Formatting Cells

Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
Autoformat
Conditional Formating
Styles

Basic Formulas

Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard

Ready for Printing?

Headers and Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts and Maps

Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps

Advanced Formulas

If Functions
And / Or
Nested If Functions

Using Excel as a Databse

Create a Database
Sort Data
Filter Data
Advance Filter
Data Forms
Database Functions

Linking and Protecting

Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords

Analysis

Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros

Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button

Graphics and The Drawing Toolbar

Insert a Picture
Move / Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects


Related Books on Microsoft Excel 2000







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts