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

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
CorelDRAW X3 Unleashed Boot Camp Phone Consultation On Site Training EZ Metrics: Create EZ Technical Illustrations Unleashed FX X3 Buttons Unleashed CorelDRAW Click 'N Learn CD-ROMs CorelDRAW & Corel Photo-Paint X4 CorelDRAW & Corel Photo-Paint X3 CorelDRAW & Corel Photo-Paint 12 CorelDRAW & Corel Photo-Paint 11 CorelDRAW & Corel Photo-Paint 10 Corel Ventura 10 Corel Painter X Corel Painter Essentials Corel Paint Shop Pro Corel Bryce 5 Corel Designer 12 3D Studio Max Adobe Flash Pro CS3 Adobe Dreamweaver CS3 Macromedia Dreamweaver MX 2004 Macromedia Fireworks MX 2004 Macromedia Director MX 2004 Macromedia Freehand MX 2004	Adobe Creative Suite CS3 Adobe Photoshop CS3 Adobe Photoshop CS2 Adobe Photoshop CS Adobe Photoshop Elements 6 Adobe InDesign CS3 Adobe InDesign CS2 Adobe InDesign CS Adobe PageMaker 7 Adobe Illustrator CS3 Adobe Illustrator CS2 Adobe Illustrator CS Adobe Premiere Pro CS3 Adobe Premiere Pro Adobe Premiere 6.5 Adobe GoLive CS2 Adobe Acrobat 9 ACD Systems Graphics Utilities QuarkXpress 7 QuarkXpress 6.x QuarkXpress 5.x AutoCAD 2002 Corel WordPerfect X4 Corel WordPerfect X3 Corel WordPerfect 12 Corel WordPerfect 11 Microsoft Office 2003 Microsoft Word XP Microsoft Excel XP Microsoft PowerPoint XP Microsoft Access XP	Windows Vista Windows 2003 Server Windows XP Windows 2000 Macintosh OS Linux and UNIX Microsoft Visio Microsoft Word 2000 Microsoft Excel 2000 Microsoft PowerPoint 2000 Microsoft Access 2000 Microsoft FrontPage 2002 Microsoft FrontPage 2000 Intuit QuickBooks 2006 Intuit QuickBooks 2005 Intuit QuickBooks 2004 Intuit QuickBooks 2003 Intuit Quicken Microsoft Visual Basic.NET Microsoft C# Digital Art Solutions Utilities and Clipart