Excel 2000 Training: Charts (2 hrs 12 min)

1. Excel 2000 Training: Creating a Chart (32 min)
   1.1 Data Selection
   1.2 Single-click Chart Creation
   1.3 Chart Wizard
   1.4 Copying a Chart
   
2. Excel 2000 Training: The Charting Toolbar (16 min)
   2.1 Features of the Charting Toolbar
   
3. Excel 2000 Training: Printing a Chart (13 min)
   3.1 Printing a Chart Located on a Separate Sheet
   3.2 Printing a Chart Located on a Worksheet
   
4. Excel 2000 Training: Shortcuts (10 min)
   4.1 Creating a Shortcut on the Worksheet with Two Clicks
   4.2 Add & Remove Data from an Embedded Chart
   4.3 Change Row/Column Orientation
   
5. Excel 2000 Training: Chart Types (45 min)
   5.1 Line Charts
   5.2 Column Charts
   5.3 Cone, Pyramid, & Cylinder
   5.4 Pie Charts
   5.5 Other Chart Types
   
6. Excel 2000 Training: Formatting the X & Y Axes (6 min)
   6.1 Adjusting the Scale on Column Charts
   6.2 Adjusting the Scale on Line Charts
   
7. Excel 2000 Training: Annotation Features (7 min)
   7.1 Adding Text & Arrows
   

Excel 2000 Training: Special Topics (1 hr 58 min)

1. Excel 2000 Training: Naming Ranges (21 min)
   1.1 Naming a Single Cell
   1.2 Naming Multiple Cells
   1.3 Using Existing Names
   1.4 Paste a List of Range Names in a Worksheet
   1.5 Deleting Range Names
   
2. Excel 2000 Training: Conditional Formatting (10 min)
   2.1 Formatting Based on Values & Multiple Conditions
   2.2 Avoiding Overlapping Conditions
   2.3 Using a Formula to Control Formatting
   
3. Excel 2000 Training: Cell Protection Techniques (6 min)
   3.1 Unlocking Selected Cells Changes
   3.2 Protecting the Worksheet to Restrict Entry to Unlocked Cells
   3.3 Unprotecting the Worksheet
   
4. Excel 2000 Training: Annotating a Worksheet with Comments & Drawing Tools (12 min)
   4.1 Inserting, Displaying, Hiding, & Editing Comments
   4.2 Options for Printing Comments
   4.3 Show/Hide Comments with the Tools Options Command
   4.4 Using Drawing Toolbar
   
5. Excel 2000 Training: Multiple Workbooks (14 min)
   5.1 Opening & Displaying Multiple Workbooks
   5.2 Moving & Copying Sheets Across Workbooks
   5.3 Linking Formulas Across Workbooks
   5.4 Locating & Maintaining Links
   
6. Excel 2000 Training: Customizing Toolbars (17 min)
   6.1 Adding & Removing Buttons
   6.2 Economizing Buttons & Resetting Toolbars
   6.3 Creating New Toolbars
   
7. Excel 2000 Training: Find & Replace (8 min)
   7.1 Matching Entire Cells, Case, & Wildcard Characters
   
8. Excel 2000 Training: Using Goal Seek (11 min)
   8.1 Features of Goal Seek
   
9. Excel 2000 Training: Numeric Formatting (16 min)
   9.1 The Custom Category
   9.2 The Special Category
   9.3 Formatting with IMPLIED-IF
   

Excel 2000 Training: Databases (2 hrs 10 min)

1. Excel 2000 Training: Data Form (13 min)
   1.1 Setting up a Single Record with Formulas
   1.2 Adding Records to a Database
   1.3 Finding Records & Avoiding Cells Below
   
2. Excel 2000 Training: Data Validation (21 min)
   2.1 Establishing Data Entry Criteria
   2.2 Using Data Validation on Existing Data
   
3. Excel 2000 Training: Data Sort (24 min)
   3.1 Sorting from the Menu
   3.2 Sorting from the Toolbar
   3.3 Multiple-Key Sorting
   3.4 Sorting with Custom Lists
   
4. Excel 2000 Training: Data Subtotals (19 min)
   4.1 Single Level Subtotals
   4.2 Multiple Level Subtotals
   
5. Excel 2000 Training: Data Filter (29 min)
   5.1 Criteria
   5.2 Top-ten
   5.3 Advanced Filter
   
6. Excel 2000 Training: Data Functions (22 min)
   6.1 Sumif, Countif
   6.2 Array Functions & Formulas
   

Excel 2000 Training: Tips, Tricks and Shortcuts (1 Hour 41 Minutes)

1. Excel 2000 Training: Navigation Shortcuts (15 Minutes)
   1.1 Navigating Around a Worksheet
   1.2 Navigating Multiple Workbooks
   1.3 Some Useful Keyboard Shortcuts
   1.4 Navigating to the Bottom of a Column
   
2. Excel 2000 Training: Selection Shortcuts (10 Minutes)
   2.1 Selecting a Range
   2.2 Selecting an Entire Worksheet
   2.3 Selecting Non-contiguous Ranges & Go to Special
   
3. Excel 2000 Training: Data Entry Shortcuts (10 Minutes)
   3.1 Entering System Date & Time
   3.2 Copying Formulas & Results
   3.3 Entering Data in a Range of Cells, Auto Complete & Data Validation
   3.4 Multi-line Entries
   
4. Excel 2000 Training: Formula Shortcuts (8 Minutes)
   4.1 Displaying Formulas
   4.2 Dependent & Precedent Cells
   4.3 VLookup
   
5. Excel 2000 Training: Formatting Shortcuts (14 Minutes)
   5.1 Numerical Formatting
   5.2 Numerical Keyboard Shortcuts
   5.3 Dealing with Large Numbers
   
6. Operational Shortcuts (12 Minutes)
   6.1 Undoing and Repeating
   6.2 File Management Shortcuts
   6.3 Inserting, Deleting, & Hiding Shortcuts
   
7. Excel 2000 Training: Data Expansion Shortcuts (7 Minutes)
   7.1 Numerical Series 7.2 Dates
   
8. Excel 2000 Training: Drag & Drop (8 Minutes)
   8.1 Moving, Copying & Inserting
   8.2 Moving, Copying & Inserting to a Different Sheet
   8.3 Moving, Copying & Inserting Using the Mouse
   
9. Display Shortcuts (4 Minutes)
   9.1 Split Screens
   
10. Excel 2000 Training: Listing Unique Entries (10 Minutes)
    10.1 Data Filter Advanced 10.2 Capturing a Picture
    

Excel 2000 Training: Pivot Tables (1 Hour 48 Minutes)

1. Excel 2000 Training: Background (10 Minutes)
   1.1 An Example
2. Excel 2000 Training: Creating a Pivot Table (18 Minutes)
   2.1 Using the Pivot Table and Pivot Chart Wizard
   2.2 Viewing Pivot Tables and Pivot Charts
   
3. Excel 2000 Training: Manipulating the Layout (15 Minutes)
   3.1 Interchanging Fields
   3.2 Adding and Removing Fields
   3.3 Page Axis
   
4. Excel 2000 Training: Content & Formatting (7 Minutes)
   4.1 Numeric Formatting
   4.2 Selecting Specific Information & AutoFormat
   
5. Excel 2000 Training: The Refresh Button (7 Minutes)
   5.1 Changing Original Data
   5.2 Changing Field Names
   
6. Excel 2000 Training: Pivot Table Chart Sources (14 Minutes)
   6.1 Selecting & Manipulating Chart Data
   6.2 The Pivot Chart & Pivot Table Relationship
   6.3 Pivot Chart Formatting
   6.4 Creating a Pivot Chart & Table Together from the Original Data
   
7. Excel 2000 Training: Sorting Items (9 Minutes)
   7.1 Sorting by Field Order & Numeric Information
   
8. Excel 2000 Training: Hiding & Revealing Data (13 Minutes)
   8.1 Drop Arrows
   8.2 Hiding Inner Fields
   
9. Excel 2000 Training: Grouping & Ungrouping (5 Minutes)
   9.1 Grouping Data
   9.2 Grouping by Date
   
10. Excel 2000 Training: Totals (8 Minutes)
    10.1 Displaying Totals
    10.2 Adding & Removing Totals
    

Excel 2000 Training: Functions (1 Hour 49 Minutes)

1. Excel 2000 Training: Statistical Functions (24 Minutes)
   1.1 Median & Rank
   1.2 Small & Large
   1.3 Count, Counta, & Mode
   1.4 Using Functions in a Range
   1.5 Average, Averagea, & True
   
2. Excel 2000 Training: Analysis ToolPak (6 Minutes)
   2.1 Accessing more Functions
   
3. Excel 2000 Training: Financial Functions (10 Minutes)
   3.1 PMT & FV 3.2 PV & Rate
   
4. Excel 2000 Training: Math Functions (33 Minutes)
   4.1 Round, Roundup, Rounddown
   4.2 Ceiling & Floor
   4.3 Odd & Even
   4.4 Fact, Power, Product, & Int
   4.5 Mod
   4.6 Rand & Randbetween
   4.7 Roman
   
5. Excel 2000 Training: Text Functions (27 Minutes)
   5.1 Find & Mid
   5.2 Left & Concatenation
   5.3 Len & Right
   5.4 An Example, Replace, & Substitute
   5.5 Upper, Lower, & Proper
   5.6 Trim
   
6. Excel 2000 Training: The Indirect Function (6 Minutes)
   6.1 The Indirect Function
   

Excel 2000 Training: Files & Reports (2 Hrs 26 Mins)

1. Excel 2000 Training: Workbook Management (10 Mins)
   1.1 Workspaces
   1.2 Assigning Passwords
   1.3 Hiding Workbooks
   
2. Excel 2000 Training: Formatting Workbooks (12 Mins)
   2.1 AutoFormat
   2.2 Styles
   
3. Excel 2000 Training: Outlining (9 Mins)
   3.1 Group & Outlining Capabilities
   
4. Excel 2000 Training: Templates (10 Mins)
   4.1 Creating a Default Workbook Template
   4.2 Creating a Custom Template
   
5. Excel 2000 Training: Report Manager (9 Mins)
   5.1 Printing & Views
   
6. Excel 2000 Training: Scenario Manager (18 Mins)
   6.1 Creating Scenarios
   6.2 Solver
   
7. Excel 2000 Training: The Drawing Toolbar (45 Mins)
   7.1 WordArt
   7.2 Shapes
   7.3 Coloring Objects & Adding Text
   7.4 ClipArt
   
8. Excel 2000 Training: Using Excel with Other Applications (15 Mins)
   8.1 Text Files
   8.2 Access
   8.3 Word
   
9. Excel 2000 Training: Hyperlinks (16 Mins)
   9.1 Types of Links
   

Return to the Excel 2000/XP Training Main Page Detailed Video Outlines Excel XP Beginning, Intermediate and Advanced Excel 2000 Beginning, Intermediate and Advanced Excel 2000 Trainingis part of the MicroSoft Office 2000 Premium Combo Sets Check out the complete list of Keystone Training Videos Frequently Asked Questions

A-Z Software Products

Excel 2000 3 Levels: Includes Beginning, Intermediate and Advanced
Excel 2000 10 Levels: Includes Beginning, Intermediate, Advanced, Charting, Special Topics, Databases, Tips Tricks and Shortcuts, Pivot Tables, Functions and Files and Reports

Excel 2000/XP Training Return Policy: You may open and view 1 DVD for "demo" purposes and still be able return the product within 15 days. Any Keystone Training Products that have more than 1 DVD opened or unsealed, are no longer covered under the 15 Day Money Back Guarantee Policy.