Instruction Business Software DVDs Computer Lessons Lessons Programming CDs Support Webmaster Instruction Software Business Lessons Training Word Guidance Guidance Notebook Help
Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Help Technology CDs CDs Workstation CDs Instruction Design Support Help Workstation Advice CDs Word Tutorials Support Computers Advice Online Design Learning

Microsoft Excel 2000 Training

More Microsoft Excel 2000 Categories Business Applications training - Microsoft training -
Microsoft Excel 2000 Tutorials Online
Product Microsoft Excel 2000 Details
Total Time : 8.00 hrs
Number of Movies : 103
Number of Discs : 1
Catalogue Number : 33101
Language : english
Author : Lorie Flenner/NMG
Sale Price : $99.95

Purchase Below




View simillar products Business Applications training - Microsoft training -
Description Microsoft Excel 2000
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.
Sample - Preview the First 3 chapters of Microsoft Excel 2000 video free. Free learning Microsoft Excel 2000 online.

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

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

Working With Worksheets
movie image Zoom Control
movie image Views
movie image Resize Rows and Columns
movie image Insert Cells
movie image Delete Cells
movie image Insert and Delete Rows and Columns
movie image Rename Worksheets
movie image Insert and Delete Worksheets
movie image Move and Copy Worksheets
movie image 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