Microsoft Excel 2000
Author:Arthur Griffith
Language:english
Category:Programming,
Lessons:0 | 0 hrs
Buy Now or get more information about 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.
Microsoft Excel 2000Microsoft Excel 2000: Microsoft ASP.NET has taken many of the best active server technologies and combined them into one powerful set of coding instructions which allow interaction between the user and the server. Today's companies and their customers rely on a back-and-forth flow of data that can be specific and more importantly, updated based on individual requests for information. Why is this important? A customer shopping at an e-store can have specific pages generated and delivered based on their shopping habits. As they continue to shop or change their habits, the information can be updated, or even updated at their request. In this seven hour tutorial, Certified Instructor Mark Long will introduce and then expand on Microsoft's ASP.NET. Simply click one of the topics below to start learning today! Listed below are all of the chapter and lesson contents for the Microsoft Excel 2000 Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Microsoft Excel 2000 freely available. Click on any of the linked lesson listings below to preview Free! Microsoft Excel 2000
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Excel 2000

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

01 Introduction
0101 Getting Started
0102 The Interface
0103 Menus
0104 Toolbars
0105 Formula Bar
0106 Columns & Rows
0107 Scroll Bars
0108 Sheet Tabs
0109 Status Bar
0110 Interface Review
0111 Workbooks & Worksheets
0112 Open and Close Workbooks
0113 Save Workbooks
0114 Getting Help

02 The Basics
0201 Select and Navigate Cells
0202 Enter Data
0203 Edit and Delete Data
0204 Cut / Copy and Paste
0205 Undo and Redo
0206 Drag and Drop
0207 Auto Fill
0208 AutoCorrect

03 Working With Worksheets
0301 Zoom Control
0302 Views
0303 Resize Rows and Columns
0304 Insert Cells
0305 Delete Cells
0306 Insert and Delete Rows and Columns
0307 Rename Worksheets
0308 Insert and Delete Worksheets
0309 Move and Copy Worksheets
0310 Hide and Unhide

04 Formatting Cells
0401 Text Formats
0402 Align and Text Wrap
0403 Alignment Effects
0404 Format Painter
0405 Borders and Shading
0406 Numbers Formats
0407 Date and Time Formats
0408 Custom Formats
0409 Autoformat
0410 Conditional Formating
0411 Styles

05 Basic Formulas
0501 Formula Structure
0502 Operators
0503 Creating Formulas
0504 Autofill Formulas
0505 Autosum
0506 Relative Reference
0507 Absolute Reference
0508 Function Wizard

06 Ready for Printing?
0601 Headers and Footers
0602 Print Preview
0603 Scaling the Print Area
0604 Set Print Area
0605 Margins
0606 Printing

07 Charts and Maps
0701 Creating a Chart
0702 Chart Wizard
0703 Chart Options
0704 The Legend
0705 The Series
0706 Chart Toolbar
0707 3D Charts
0708 Creating Maps
0709 Customizing Maps
0710 Labeling Maps

08 Advanced Formulas
0801 If Functions
0802 And / Or
0803 Nested If Functions

09 Using Excel as a Databse
0901 Create a Database
0902 Sort Data
0903 Filter Data
0904 Advance Filter
0905 Data Forms
0906 Database Functions

10 Linking and Protecting
1001 Formula Links
1002 Range Names
1003 Paste Special
1004 Protect Cells
1005 Protect Worksheets and Workbooks
1006 Passwords

11 Analysis
1101 Goal Seek and Solver
1102 Scenarios
1103 Pivot Tables
1104 Validation
1105 Auditing
1106 Outlining

12 Toolbars and Macros
1201 Customizing Toolbars
1202 Create a Macro
1203 Edit a Macro
1204 Create a Macro Button

13 Graphics and The Drawing Toolbar
1301 Insert a Picture
1302 Move / Resize and Crop
1303 Creating Shapes and Lines
1304 Arranging and Grouping
1305 Fills and Line Color
1306 Arrows
1307 AutoShapes
1308 Flip and Rotate
1309 Text boxes
1310 WordArt
1311 Shadow and 3D Effects

Sponsors