Microsoft Excel 2000 Charts (2 hrs 12 min)

1. 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. The Charting Toolbar (16 min)
   2.1 Features of the Charting Toolbar
   
3. 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. 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. 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. Formatting the X & Y Axes (6 min)
   6.1 Adjusting the Scale on Column Charts
   6.2 Adjusting the Scale on Line Charts
   
7. Annotation Features (7 min)
   7.1 Adding Text & Arrows
   

Microsoft Excel 2000 Special Topics (1 hr 58 min)

1. 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. 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. 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. 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. 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. Customizing Toolbars (17 min)
   6.1 Adding & Removing Buttons
   6.2 Economizing Buttons & Resetting Toolbars
   6.3 Creating New Toolbars
   
7. Find & Replace (8 min)
   7.1 Matching Entire Cells, Case, & Wildcard Characters
   
8. Using Goal Seek (11 min)
   8.1 Features of Goal Seek
   
9. Numeric Formatting (16 min)
   9.1 The Custom Category
   9.2 The Special Category
   9.3 Formatting with IMPLIED-IF
   

Microsoft Excel 2000 Databases (2 hrs 10 min)

1. 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. Data Validation (21 min)
   2.1 Establishing Data Entry Criteria
   2.2 Using Data Validation on Existing Data
   
3. 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. Data Subtotals (19 min)
   4.1 Single Level Subtotals
   4.2 Multiple Level Subtotals
   
5. Data Filter (29 min)
   5.1 Criteria
   5.2 Top-ten
   5.3 Advanced Filter
   
6. Data Functions (22 min)
   6.1 Sumif, Countif
   6.2 Array Functions & Formulas
   

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

1. 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. 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. 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. Formula Shortcuts (8 Minutes)
   4.1 Displaying Formulas
   4.2 Dependent & Precedent Cells
   4.3 VLookup
   
5. 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. Data Expansion Shortcuts (7 Minutes)
   7.1 Numerical Series 7.2 Dates
   
8. 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. Listing Unique Entries (10 Minutes)
    10.1 Data Filter Advanced 10.2 Capturing a Picture
    

Microsoft Excel 2000 Pivot Tables (1 Hour 48 Minutes)

1. Background (10 Minutes)
   1.1 An Example
2. 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. Manipulating the Layout (15 Minutes)
   3.1 Interchanging Fields
   3.2 Adding and Removing Fields
   3.3 Page Axis
   
4. Content & Formatting (7 Minutes)
   4.1 Numeric Formatting
   4.2 Selecting Specific Information & AutoFormat
   
5. The Refresh Button (7 Minutes)
   5.1 Changing Original Data
   5.2 Changing Field Names
   
6. 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. Sorting Items (9 Minutes)
   7.1 Sorting by Field Order & Numeric Information
   
8. Hiding & Revealing Data (13 Minutes)
   8.1 Drop Arrows
   8.2 Hiding Inner Fields
   
9. Grouping & Ungrouping (5 Minutes)
   9.1 Grouping Data
   9.2 Grouping by Date
   
10. Totals (8 Minutes)
    10.1 Displaying Totals
    10.2 Adding & Removing Totals
    

Microsoft Excel 2000 Functions (1 Hour 49 Minutes)

1. 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. Analysis ToolPak (6 Minutes)
   2.1 Accessing more Functions
   
3. Financial Functions (10 Minutes)
   3.1 PMT & FV 3.2 PV & Rate
   
4. 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. 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. The Indirect Function (6 Minutes)
   6.1 The Indirect Function
   

Detailed Video Outlines

Excel 2000 is part of the MicroSoft Office 2000 Premium Combo Sets
Check out the complete list of Keystone Training Videos

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.