Excel XP Essentials
Computer Based Training (CBT) and Videos

Excel XP Essentials:  Order |  Meet the Trainer |  Course Description

After completing this course you will be prepared to acquire your MOUS certification and to maximize your data use. Topics include formulas, formating, worksheet layout, auditing, charting, databases and pivot tables.

 Order with absolute confidence, all Order pages...

Detailed Course Outline

Beginning
1.0 The Excel Screen 1.1 Overview 1.2 Screen Elements 2.0 Entering Data 2.1 Data Entry Techniques 2.2 AutoFill Entry Techniques 2.3 Erasing Data 2.4 AutoComplete 2.5 Undo & Re-do 3.0 Entering Formulas 3.1 Three Methods of Entering Formulas 3.2 Repeating a Formula in Adjacent Cells 3.3 Formulas Beyond Addition & Subtraction 4.0 Basic Excel Functions 4.1 Summation 4.2 Recalculating Effects & Hierarchy of Operations 4.3 Other Functions	5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Widths & Row Heights 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files 6.1 File Save & File Save As 6.2 Opening a File 6.3 Creating a New Workbook 7.0 The Help System 7.1 Using the Help System
Intermediate
	back to top
1.0 Changing Worksheet Layout 1.1 Inserting Columns, Rows, & Cells 1.2 Deleting Columns, Rows, & Cells 1.3 Moving Cells 1.4 Copying Cells 2.0 Additional Formatting 2.1 Formatting Cell Attributes & Alignment 2.2 Borders 2.3 Numeric Formatting 2.4 Centering Text Across Columns 2.5 Hiding & Unhiding Columns & Rows 3.0 Printing 3.1 Using Print Preview & Page Setup 3.2 Printing Controls 3.3 Using Page Break & Preview	4.0 Using Cell References 4.1 Absolute References 4.2 Mixed References 5.0 The Tools Options Command 5.1 Show/Hide Gridlines & Formulas 5.2 Recently Used File List 5.3 Sheets in New Workbook 5.4 Default Settings
Advanced
	back to top
1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split Screens 2.0 Auditing Techniques 2.1 Using the Formula Auditing Toolbar 2.2 Tracing Dependent Cells 2.3 Tracing Precedent Cells 3.0 The IF & VLOOKUP Functions 3.1 The IF Functions & Relational Operators 3.2 Using Words in IF Functions 3.3 Using Logical Operators 3.4 Nested IF Functions 3.5 Getting Data from the Table with a VLOOKUP Function 4.0 Date & Time Functions 4.1 Using Dates as Values 4.2 Entering a Series of Dates 4.3 Date/Time Entry Techniques	5.0 Multi-Sheet Workbooks 5.1 Renaming & Reordering Sheets 5.2 Inserting & Deleting Sheets 5.3 Moving, Copying, & Grouping Sheets 5.4 Formulas Across Multiple Sheets
	back to top

Meet the Trainer
Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Five years ago he turned his attention to Excel spreadsheets and has become an Excel training specialist. Dennis brings a combination of in-depth knowledge and training experience to this course. Watch and learn in minutes with Dennis.

Order with complete confidence, all Order pages... 

Aaron's Computer Training is your online source for MCSE and A+ Certification computer training courses. We also offer a complete suite of computer training certification beyond A+ and MCSE Certification. Some of our most popular classes are: Microsoft Office, MOUS, Linux, and Oracle.

Other popular computer certification training: MCSE Security+ Linux+ Oracle8iR2 A+ Certification Network+ i-Net+ MCSA Core CDIA Microsoft Office MOUS

Call for Orders or Questions:  1-800-617-5586 Toll Free !
Customer Service Hours: 9:00am-5:00pm, eastern time, Monday - Friday
aarons@aarons-computer-training.com

A+ Certification Training l MCSE Certification Training l Complete Computer Training Course Listing

Aarons Computer Training Specializes in MCSE and A+ Certification Training