Microsoft Excel 2000

Training Provided by The Virtual Training Company 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 2000

Introduction

1. Getting Started
2. The Interface
3. Menus
4. Toolbars
5. Formula Bar
6. Columns & Rows
7. Scroll Bars
8. Sheet Tabs
9. Status Bar
10. Interface Review
11. Workbooks & Worksheets
12. Open and Close Workbooks
13. Save Workbooks
14. Getting Help

The Basics

1. Select and Navigate Cells
2. Enter Data
3. Edit and Delete Data
4. Cut / Copy and Paste
5. Undo and Redo
6. Drag and Drop
7. Auto Fill
8. AutoCorrect

Working With Worksheets

1. Zoom Control
2. Views
3. Resize Rows and Columns
4. Insert Cells
5. Delete Cells
6. Insert and Delete Rows and Columns
7. Rename Worksheets
8. Insert and Delete Worksheets
9. Move and Copy Worksheets
10. Hide and Unhide

Formatting Cells

1. Text Formats
2. Align and Text Wrap
3. Alignment Effects
4. Format Painter
5. Borders and Shading
6. Numbers Formats
7. Date and Time Formats
8. Custom Formats
9. Autoformat
10. Conditional Formating
11. Styles

Basic Formulas

1. Formula Structure
2. Operators
3. Creating Formulas
4. Autofill Formulas
5. Autosum
6. Relative Reference
7. Absolute Reference
8. Function Wizard

Ready for Printing?

1. Headers and Footers
2. Print Preview
3. Scaling the Print Area
4. Set Print Area
5. Margins
6. Printing

Charts and Maps

1. Creating a Chart
2. Chart Wizard
3. Chart Options
4. The Legend
5. The Series
6. Chart Toolbar
7. 3D Charts
8. Creating Maps
9. Customizing Maps
10. Labeling Maps

Advanced Formulas

1. If Functions
2. And / Or
3. Nested If Functions

Using Excel as a Databse

1. Create a Database
2. Sort Data
3. Filter Data
4. Advance Filter
5. Data Forms
6. Database Functions

Linking and Protecting

1. Formula Links
2. Range Names
3. Paste Special
4. Protect Cells
5. Protect Worksheets and Workbooks
6. Passwords

Analysis

1. Goal Seek and Solver
2. Scenarios
3. Pivot Tables
4. Validation
5. Auditing
6. Outlining

Toolbars and Macros

1. Customizing Toolbars
2. Create a Macro
3. Edit a Macro
4. Create a Macro Button

Graphics and The Drawing Toolbar

1. Insert a Picture
2. Move / Resize and Crop
3. Creating Shapes and Lines
4. Arranging and Grouping
5. Fills and Line Color
6. Arrows
7. AutoShapes
8. Flip and Rotate
9. Text boxes
10. WordArt
11. Shadow and 3D Effects

About The Training Provider: The Virtual Training Company

More Microsoft Training from The Virtual Training Company

• Microsoft Access 2000
• Microsoft Access 2002
• Microsoft Access 2003
• Microsoft ASP NET
• Microsoft Entourage 2004
• Microsoft Excel 2002
• Microsoft Excel 2003
• Microsoft Exchange 2000 Enterprise
• Microsoft Exchange 2003
• Microsoft FrontPage 2000
• Microsoft FrontPage 2002
• Microsoft FrontPage 2003
• Microsoft Internet Explorer 5 5
• Microsoft Managing Windows 2000 Security
• Microsoft Office 2001 for Macintosh
• Microsoft Office XP Upgrade
• Microsoft Outlook 2000
• Microsoft Outlook 2002
• Microsoft PowerPoint 2000
• Microsoft PowerPoint 2002
• Microsoft PowerPoint 2003
• Microsoft Project 2003
• Microsoft Publisher 2002
• Microsoft Publisher 2003
• Microsoft SQL Server 2005 Administration
• Microsoft Visio 2002
• Microsoft Visio 2003
• Microsoft Visual Basic 6
• Microsoft Visual Basic 6 Advanced
• Microsoft Visual Basic for Access
• Microsoft Visual Basic for Access 2002
• Microsoft Visual Basic for Excel
• Microsoft Visual Basic NET
• Microsoft Visual Studio NET
• Microsoft Windows 2000 Directory Services
• Microsoft Windows 2000 Network Infrastructure
• Microsoft Windows 2000 Professional
• Microsoft Windows 2000 Server
• Microsoft Windows 95 Basics
• Microsoft Windows 98
• Microsoft Windows IIS 4
• Microsoft Windows NT 4 Server Admin
• Microsoft Windows NT 4 Server Installation
• Microsoft Windows NT 4 Workstation
• Microsoft Windows XP Administration 70-270
• Microsoft Windows XP Fundamentals
• Microsoft Word 2000
• Microsoft Word 2003