Excel 2000 Training

Excel 2000 Training Videos on CD

Excel 2000 Training Course

Hosted by Dennis P. Taylor
Approx. 20 hours of Excel training on CD

This Excel 2000 training course will help you maximize your understanding of the world's top spreadsheet program while also helping you prepare for Microsoft’s Office User Specialist (MOUS) Certification. Quickly learn formulas, formatting, layout, commands, functions, charts, database shortcuts, pivot tables, files and reports and much more, as you see simple step-by-step, easy to understand hands-on demonstrations of the concepts being taught for Excel 2000.

Our Excel 2000 training CD-ROMs include a pretest to assess
your current skill level and a posttest to test your newly
acquired knowledge.

Excel 2000 Training Series

Clearance item, All Sales are Final. WORKS ON WINDOW XP ONLY: SEE SYSTEM REQ BELOW

Part#: sk-exc00x | Contents: Set of 3 CDs or Set of 10 CDs

Format

Reg: $149.00
Sale: $49.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, or Windows XP.
NOT COMPATIBLE with Windows XP 64-Bit Edition, Windows Vista, Windows 7, or Windows 8.

TrainerExcel 2000 Trainer: Dennis P. Taylor
Dennis currently trains employees at Amgen, IBM, and other companies in his specialized area of spreadsheet software. Dennis has over 15 years experience presenting PC software to individuals and seminar groups. He has also co-authored a number of books on spreadsheet topics.

Course Outline - Excel 2000 Training:

Approx. 20 hrs. of training

EXCEL 2000 BEGINNING (2 Hrs 16 Mins)

1.0 The Excel Screen (32 Mins)
1.1 The Excel Workbook & Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Mins)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Mins)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition & Subtraction
4.0 Basic Functions (21 Mins)
4.1 Summation
4.2 Recalculating Effects 
4.3 Averages
5.0 Formatting (13 Mins)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width & Row-height 
5.3 Numeric Formatting
6.0 Saving (17 mins)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook

EXCEL 2000 INTERMEDIATE (2 Hrs 5 Mins)

1.0 Changing Worksheet Layout (26 Mins)
1.1 Inserting Columns
1.2 Deleting Columns
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting (6 Mins)
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text across Columns
2.5 Hiding & Unhiding Columns & Rows
3.0 Printing (25 Mins)
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Mins)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Mins)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings

EXCEL 2000 ADVANCED (2 Hrs 2 Mins)

1.0 Adjusting Worksheet Views (13 Mins)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Mins)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Mins)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Mins)
4.1 IF Functions & Relational Operators (> < >= <= = <> )
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic Operators (* / + -) 
4.4 Using Logical Operators (AND & OR) with the IF Function 
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
5.0 Date & Time Functions (21 Mins)
5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time entry Techniques
6.0 Multi-Sheet Workbooks (22 Mins)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting & Deleting Sheets
6.3 Moving
6.4 Formulas across multiple sheets

EXCEL 2000 CHARTS (2 Hrs 12 Mins)

1.0 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.0 The Charting Toolbar (16 min)
2.1 Features of the Charting Toolbar
3.0 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.0 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.0 Chart Types (45 min)
5.1 Line Charts
5.2 Column Charts
5.3 Cone
5.4 Pie Charts
5.5 Other Chart Types
6.0 Formatting the X & Y Axes (6 min)
6.1 Adjusting the Scale on Column Charts
6.2 Adjusting the Scale on Line Charts
7.0 Annotation Features (7 min)
7.1 Adding Text & Arrows

EXCEL 2000 SPECIAL TOPICS (1 Hrs 58 Mins)

1.0 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.0 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.0 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.0 Annotating a Worksheet with Comments & Drawing Tools (12 min)
4.1 Inserting
4.2 Options for Printing Comments
4.3 Show/Hide Comments with the Tools Options Command
4.4 Using Drawing Toolbar
5.0 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.0 Customizing Toolbars (17 min)
6.1 Adding & Removing Buttons 
6.2 Economizing Buttons & Resetting Toolbars
6.3 Creating New Toolbars 
7.0 Find & Replace (8 min)
7.1 Matching Entire Cells
8.0 Using Goal Seek (11 min)
8.1 Features of Goal Seek
9.0 Numeric Formatting (16 min)
9.1 The Custom Category
9.2 The Special Category
9.3 Formatting with IMPLIED-IF

EXCEL 2000 DATABASES (2 Hrs 10 Mins)

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

EXCEL 2000 TIPS, TRICKS, AND SHORTCUTS (1 Hrs 41 Mins)

1.0 Navigation Shortcuts (15 Mins) 
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.0 Selection Shortcuts (10 Mins) 
2.1 Selecting a Range 
2.2 Selecting an Entire Worksheet 
2.3 Selecting Non-contiguous Ranges & Go to Special 
3.0 Data Entry Shortcuts (10 Mins) 
3.1 Entering System Date & Time 
3.2 Copying Formulas & Results 
3.3 Entering Data in a Range of Cells Data Validation 
3.4 Multi-line Entries 
4.0 Formula Shortcuts (8 Mins) 
4.1 Displaying Formulas 
4.2 Dependent & Precedent Cells 
4.3 VLookup 
5.0 Formatting Shortcuts (14 Mins) 
5.1 Numerical Formatting 
5.2 Numerical Keyboard Shortcuts 
5.3 Dealing with Large Numbers 
6.0 Operational Shortcuts (12 Mins) 
6.1 Undoing & Repeating 
6.2 File Management Shortcuts 
6.3 Inserting
7.0 Data Expansion Shortcuts (7 Mins) 
7.1 Numerical Series
7.2 Dates
8.0 Drag & Drop (8 Mins) 
8.1 Moving, Copying & Inserting
8.2 Moving, Copying & Inserting to a Different Sheet
8.3 Moving, Copying & Inserting using a Mouse
9.0 Display Shortcuts (4 Mins)
9.1 Split Screens
10.0 Listing Unique Entries (10 Mins)
10.1 Data Filter Advanced 
10.2 Capturing a Picture

EXCEL 2000 PIVOT TABLES (1 Hrs 48 Mins)

1.0 Background (10 Mins)
1.1 An Example 
2.0 Creating a Pivot Table (18 Mins) 
2.1 Using the Pivot Table & Pivot Chart Wizard 
2.2 Viewing Pivot Tables & Pivot Charts 
3.0 Manipulating the Layout (15 Mins) 
3.1 Interchanging Fields 
3.2 Adding & Removing Fields 
3.3 Page Axis 
4.0 Content & Formatting (7 Mins) 
4.1 Numeric Formatting 
4.2 Selecting Specific Information & AutoFormat 
5.0 The Refresh Button (7 Mins) 
5.1 Changing Original Data 
5.2 Changing Field Names 
6.0 Pivot Table Chart Sources (14 Mins) 
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.0 Sorting Items (9 Mins) 
7.1 Sorting by Field Order & Numeric Information 
8.0 Hiding & Revealing Data (13 Mins) 
8.1 Drop Arrows 
8.2 Hiding Inner Fields 
9.0 Grouping & Ungrouping (5 Mins) 
9.1 Grouping Data 
9.2 Grouping by Date 
10.0 Totals (8 Mins) 
10.1 Displaying Totals 
10.2 Adding & Removing Totals

EXCEL 2000 FUNCTIONS (1 Hrs 49 Mins)

1.0 Statistical Functions (24 Mins) 
1.1 Median & Rank 
1.2 Small & Large 
1.3 Count
1.4 Using Functions in a Range 
1.5 Average
2.0 Analysis ToolPak (6 Mins) 
2.1 Accessing more Functions 
3.0 Financial Functions (10 Mins) 
3.1 PMT & FV
3.2 PV & Rate 
4.0 Math Functions (33 Mins) 
4.1 Round
4.2 Ceiling & Floor 
4.3 Odd & Even 
4.4 Fact
4.5 Mod 
4.6 Rand & Randbetween 
4.7 Roman 
5.0 Text Functions (27 Mins) 
5.1 Find & Mid 
5.2 Left & Concatenation 
5.3 Len & Right 
5.4 An Example
5.5 Upper
5.6 Trim 
6.0 The Indirect Function (6 Mins) 
6.1 The Indirect Function

EXCEL 2000 FILES & REPORTS (2 Hrs 26 Mins)

1.0 Workbook Management (10 Mins)
1.1 Workspaces
1.2 Assigning Passwords
1.3 Hiding Workbooks
2.0 Formatting Workbooks (12 Mins)
2.1 AutoFormat
2.2 Styles
3.0 Outlining (9 Mins)
3.1 Group & Outlining Capabilities
4.0 Templates (10 Mins)
4.1 Creating a Default Workbook Template
4.2 Creating a Custom Template
5.0 Report Manager (9 Mins)
5.1 Printing & Views 6.0 Scenario Manager (18 Mins) 
6.1 Creating Scenarios
6.2 Solver
7.0 The Drawing Toolbar (45 Mins)
7.1 WordArt
7.2 Shapes
7.3 Coloring Objects & Adding Text
7.4 ClipArt
8.0 Using Excel with Other Applications (15 Mins) 
8.1 Text Files
8.2 Access
8.3 Word
9.0 Hyperlinks (16 Mins)
9.1 Types of Links

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $149.00
Sale price: $49.00

Format

Product Details
  • Part#: sk-exc00x
  • Contents: Set of 3 CDs or Set of 10 CDs
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player