Microsoft Excel 2000 Training Solutions -- Books, Videos and CD-ROMs

1200+ CorelDRAW Brushes · 1400+ Seamless Textures · CorelDRAW Clip Art
Vehicle Templates for Vehicle Wraps · CorelDRAW Training DVDs · QR Codes Docker

Microsoft Excel 2000 Course
Available in VHS Video and CD-ROM

About Your Instructor

Dennis P. Taylor has spent 14 years presenting PC software training to individuals in classrooms and seminars. Dennis currently trains employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books. Five years ago he turned his attention to Excel spreadsheets and has become a Excel training specialist. Dennis brings a combination of in-depth knowledge and training experience to this video course.

Description

When completed with this course you will be prepared to acquire your MOUS certification and to maximize your data use. Topics include formulas, formatting, worksheet layout, auditing, charting, databases and pivot tables.

Other Office 2000 Courses

Microsoft Word 2000

Microsoft Access 2000

Microsoft PhotoDraw 2000

Microsoft PowerPoint 2000

Microsoft Front Page 2000

Microsoft Excel 2000 Books

Mastering Excel 2000 Premium Edition

Special Edition Using Microsoft Excel 2000

Microsoft Excel 2000 Bible

Teach Yourself Microsoft Excel 2000 Visually

Excel 2000 for Dummies

NTSC? PAL? Secam?

Return Policy

Learning Microsoft Excel 2000 Beginning

by Dennis Taylor
The Excel Screen (32 Minutes): The Excel Workbook and Worksheets; Title Bar & Menu Bar; Toolbars; Formula Bar; Columns & Rows; Navigation; Sheet Names & the Status Bar; Mouse Pointers & Shortcut Menus
Entering Data into a Worksheet (27 Minutes): Data Entry Techniques; Auto-Fill Entry Techniques; Erasing Data; Auto Complete
Entering Formulas (26 Minutes): Three Methods of Entering Formulas; Repeating a Formula; Formulas Beyond Addition and Subtraction
Basic Functions (21 Minutes): Summation; Recalculating Effects (Change one cell and five others change); Averages
Formatting (13 Minutes): The Formatting Toolbar; Adjusting Column-width and Row-height; Numeric Formatting
Saving, Opening & Closing Files (16 Minutes): File Save or File Save as; Opening a File; Closing a File; Creating a new Workbook
Covers Microsoft Excel 2000
2 Hours, 16 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Intermediate

by Dennis Taylor
Changing Worksheet Layout (26 Minutes): Inserting Columns, Rows and Cells; Deleting Columns, Rows and Cells; Moving Cells; Copying Cells
Additional Formatting (6 Minutes): Formatting Cell Attributes and Alignment; Borders; Numeric Formatting; Center Text across Columns; Hiding & Unhiding Columns & Rows
Printing (25 Minutes): Using Print Preview and Page Setup; Printing Controls; Using Page Break Preview
Using Cell References (29 Minutes): Absolute References; Mixed References
Tools Options Command (18 Minutes): Show/Hide Gridlines; Show/Hide Formulas; Recently used Files List; Sheets in New Workbook; Default Settings
Covers Microsoft Excel 2000
2 Hours, 5 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Advanced

by Dennis Taylor
Adjusting Worksheet Views (13 Minutes): ; Freeze/Unfreeze Panes; Horizontal & Vertical Split screen
Auditing Techniques (12 Minutes): Using the Auditing Toolbar; Tracing Dependant Cells; Tracing Precedent Cells
Using Functions (18 Minutes): Paste Function; The PMT Function; Expanding the use of standard functions
Logical Functions (30 Minutes): IF Functions and Relational Operators (> < >= <= = <> ); Using Words in IF Functions; Using IF Functions with Arithmetic Operators (* / + -); Using Logical Operators (AND & OR) with the IF Function; Nested IF Functions; Using the VLOOKUP Function to overcome Limitations of the IF Functions
Date & Time Functions (21 Minutes): Using Dates as Values; Entering a Series of Dates; Date/Time entry Techniques
Multi-Sheet Workbooks (22 Minutes): Re-Naming & Re-Ordering Sheets; Inserting and Deleting Sheets; Moving, Copying and Grouping Sheets; Formulas across multiple sheets
Covers Microsoft Excel 2000
2 Hours, 2 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Video

by Dennis Taylor
You'll receive Learning Microsoft Excel 2000 Beginning, Intermediate and Advanced tapes for the special price of only $149.95!!!
Covers Microsoft Excel 2000
$149.95US

Return Policy

Learning Microsoft Excel 2000 Files and Reports

by Dennis Taylor
Workbook Management (10 Mins): Workspaces; Assigning Passwords; Hiding Workbooks
Formatting Workbooks (12 Mins): AutoFormat; Styles
Outlining (9 Mins): Group and Outlining Capabilities
Templates (10 Mins): Creating a Default Workbook Template; Creating a Custom Template
Report Manager (9 Mins): Printing and Views
Scenario Manager (18 Mins): Creating Scenarios; Solver
The Drawing Toolbar (45 Mins): WordArt; Shapes, Lines, & Arrows; Coloring Objects & Adding Text; ClipArt
Using Excel with Other Applications (15 Mins): Text Files; Access; Word
Hyperlinks (16 Mins): Types of Links
Covers Microsoft Excel 2000
2 Hours, 26 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Tips, Tricks and Shortcuts

by Dennis Taylor
Navigation Shortcuts (15 Minutes): Navigating Around a Worksheet; Navigating Multiple Workbooks; Some Useful Keyboard Shortcuts; Navigating to the Bottom of a Column
Selection Shortcuts (10 Minutes): Selecting a Range; Selecting an Entire Worksheet; Selecting Non-contiguous Ranges & Go to Special
Data Entry Shortcuts (10 Minutes): Entering System Date & Time; Copying Formulas & Results; Entering Data in a Range of Cells, Auto Complete & Data Validation; Multi-line Entries
Formula Shortcuts (8 Minutes): Displaying Formulas; Dependent & Precedent Cells; VLookup
Formatting Shortcuts (14 Minutes): Numerical Formatting; Numerical Keyboard Shortcuts; Dealing with Large Numbers
Operational Shortcuts (12 Minutes): Undoing and Repeating; File Management Shortcuts; Inserting, Deleting, & Hiding Shortcuts
Data Expansion Shortcuts (7 Minutes): Numerical Series; Dates
Drag & Drop (8 Minutes): Moving, Copying & Inserting; Moving, Copying & Inserting to a Different Sheet; Moving, Copying & Inserting Using the Mouse
Display Shortcuts (4 Minutes): Split Screens
Listing Unique Entries (10 Minutes): Data Filter Advanced; Capturing a Picture
Covers Microsoft Excel 2000
1 Hour, 41 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Pivot Tables

by Dennis Taylor
Background (10 Minutes): An Example
Creating a Pivot Table (18 Minutes): Using the Pivot Table and Pivot Chart Wizard; Viewing Pivot Tables and Pivot Charts
Manipulating the Layout (15 Minutes): Interchanging Fields; Adding and Removing Fields; Page Axis
Content & Formatting (7 Minutes): Numeric Formatting; Selecting Specific Information & AutoFormat
The Refresh Button (7 Minutes): Changing Original Data; Changing Field Names
Pivot Table Chart Sources (14 Minutes): Selecting & Manipulating Chart Data; The Pivot Chart & Pivot Table Relationship; Pivot Chart Formatting; Creating a Pivot Chart & Table Together from the Original Data
Sorting Items (9 Minutes): Sorting by Field Order & Numeric Information
Hiding & Revealing Data (13 Minutes): Drop Arrows; Hiding Inner Fields
Grouping & Ungrouping (5 Minutes): Grouping Data; Grouping by Date
Totals (8 Minutes): Displaying Totals; Adding & Removing Totals
Covers Microsoft Excel 2000
1 Hour, 48 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Functions

by Dennis Taylor
Statistical Functions (24 Minutes):Median & Rank; Small & Large; Count, Counta, & Mode; Using Functions in a Range; Average, Averagea, & True
Analysis ToolPak (6 Minutes): Accessing more Functions
Financial Functions (10 Minutes): PMT & FV; PV & Rate
Math Functions (33 Minutes): Round, Roundup, Rounddown; Ceiling & Floor; Odd & Even; Fact, Power, Product, & Int; Mod; Rand & Randbetween; Roman
Text Functions (27 Minutes): Find & Mid; Left & Concatenation; Len & Right; An Example, Replace, & Substitute; Upper, Lower, & Proper; Trim
The Indirect Function (6 Minutes): The Indirect Function
Covers Microsoft Excel 2000
1 Hour, 49 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Charts

by Dennis Taylor
Creating a Chart (32 min): Data Selection; Single-click Chart Creation; Chart Wizard; Copying a Chart
The Charting Toolbar (16 min): Features of the Charting Toolbar
Printing a Chart (13 min): Printing a Chart Located on a Separate Sheet; Printing a Chart Located on a Worksheet
Shortcuts (10 min): Creating a Shortcut on the Worksheet with Two Clicks; Add & Remove Data from an Embedded Chart; Change Row/Column Orientation
Chart Types (45 min): Line Charts; Column Charts; Cone, Pyramid, & Cylinder; Pie Charts; Other Chart Types
Formatting the X & Y Axes (6 min): Adjusting the Scale on Column Charts; Adjusting the Scale on Line Charts
Annotation Features (7 min): Adding Text & Arrows
Covers Microsoft Excel 2000
2 Hours, 12 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Special Topics

by Dennis Taylor
Naming Ranges (21 min): Naming a Single Cell; Naming Multiple Cells; Using Existing Names; Paste a List of Range Names in a Worksheet; Deleting Range Names
Conditional Formatting (10 min): Formatting Based on Values & Multiple Conditions; Avoiding Overlapping Conditions; Using a Formula to Control Formatting
Cell Protection Techniques (6 min): Unlocking Selected Cells Changes; Protecting the Worksheet to Restrict Entry to Unlocked Cells; Unprotecting the Worksheet
Annotating a Worksheet with Comments & Drawing Tools (12 min): Inserting, Displaying, Hiding, & Editing Comments; Options for Printing Comments; Show/Hide Comments with the Tools Options Command; Using Drawing Toolbar
Multiple Workbooks (14 min): Opening & Displaying Multiple Workbooks; Moving & Copying Sheets Across Workbooks; Linking Formulas Across Workbooks; Locating & Maintaining Links
Customizing Toolbars (17 min): Adding & Removing Buttons; Economizing Buttons & Resetting Toolbars; Creating New Toolbars
Find & Replace (8 min): Matching Entire Cells, Case, & Wildcard Characters
Using Goal Seek (11 min): Features of Goal Seek
Numeric Formatting (16 min): The Custom Category; The Special Category; Formatting with IMPLIED-IF
Covers Microsoft Excel 2000
1 Hour, 58 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Databases

by Dennis Taylor
Data Form (13 min): Setting up a Single Record with Formulas; Adding Records to a Database; Finding Records & Avoiding Cells Below
Data Validation (21 min): Establishing Data Entry Criteria; Using Data Validation on Existing Data
Data Sort (24 min): Sorting from the Menu; Sorting from the Toolbar; Multiple-Key Sorting; Sorting with Custom Lists
Data Subtotals (19 min): Single Level Subtotals; Multiple Level Subtotals
Data Filter (29 min): Criteria; Top-ten; Advanced Filter
Data Functions (22 min): Sumif, Countif; Array Functions & Formulas
Covers Microsoft Excel 2000
2 Hours, 10 Minutes
$59.95US

Return Policy

Learning Microsoft Excel 2000 Complete Series

by Dennis Taylor
You'll receive all 10 Learning Microsoft Excel 2000 courses for the special price of only $499.95!!!
Covers Microsoft Excel 2000
$499.95US

Discover More Training Solutions at Graphics Unleashed

_{Last Updated Wednesday March 21 2007.}

Clipart, Fonts & Other Artwork			Training	Add-ons	Textures
Bonus Content Packs Spring Unleashed V1 Summer Unleashed V1 Sports Unleashed V1 Fall Unleashed V1 Halloween Unleashed V1 Thanksgiving Unleashed V1 Winter Unleashed V1 Symbols Unleashed V1 Fruit Unleashed V1 Signs Unleashed V1	US Flags Unleashed V1 Music Unleashed V1 Icons Unleashed V1 Buttons Unleashed V1 Stick People Unleashed V1 Computer Unleashed V1 Sports Unleashed V2 Weather Unleashed V1 People Icons Unleashed V1 World Flags Unleashed V1 Clipart Unleashed	1200+ CorelDRAW Brushes Vehicle Templates for Vehicle Wraps Free Fonts 1000 Seamless Stripes Stick Figure Volume 1 Ult. Flames Mega Pack Ult. Flames Mega Pack 2 Ult. Ornaments Mega Pack 1400 Seamless Textures	CorelDRAW X6 Training DVD CorelDRAW X5 Training DVDs CorelDRAW X4 Training DVDs Click 'n Learn Tutorials CorelDRAW 0-60 Training Jeff Harrison's FUNdaMENTALs CorelDRAW Training Session On-Site Training Session Phone Consultation CorelDRAW Unleashed Magazine	Design Base Automation Tool for CorelDRAW X3-X6 ROMCat Resources Docker QR Codes Docker EZ Metrics Smart Designer CoCut Pro	Wood Metal Stone Terrain Fire & Ice Ground & Plants Floor, Wall & Bricks Fiber Tile & Path Marble Crystals