Excel XP
Interactive Instructor Based Video Training Courses

Trainer

Outline

Specials

Buy Options

Excel is a powerful, yet easy-to-use spreadsheet software package that is part of the Microsoft Office XP suite of products. This course will help familiarize you with the fundamentals of Excel XP, such as cell referencing, auditing techniques, VLOOKUP functions, and much more.

3 titles - including the following topics: • Importing Data • Formulas and Functions • Worksheet and workbook formatting • Everyday Tasks • Language-specific features • Web Documents and Web Sites • Error prevention and recovery • Security (see below for complete outline) + KeyNotes

Course Description: After completing 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.

About this software: Microsoft Excel is a member of the spreadsheet family of software. Spreadsheet software is used to store information in columns and rows, which can then be organized and/or processed. Spreadsheets are designed to work well with numbers but often include text. Sometimes text in a spreadsheet is called a label, because it is labeling columns and rows of numbers. Numbers are called values sometimes, and can include numbers for counts or measurements, dates, times, and calculations from numbers. Spreadsheets can help organize information, like alphabetizing a list of names or other text or reordering records according to a numeric field. Spreadsheets are more often used for calculating, such as totaling a column of numbers or generating a more sophisticated formula to calculate some statistical measure on a list of numbers.

Competitive Advantages: 1. Our training is media-rich, interactive and engaging. Unlike many of our competitors, we incorporate talking heads, screen shots, PowerPoint presentations, and white board simulations to give our customers an engaging learning experience rather than a boring one. 2. The trainer. Dennis Taylor brings a combination of in-depth knowledge and training experience to this course. Watch and Learn in minutes with Dennis.

Trainer Information: Dennis Taylor 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.

	Excel XP: Beginner Level
	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 and 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 and Row Heights 5.3 Numeric Formatting 6.0 Saving, Opening and Closing Files 6.1 File Save and 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

	Excel XP: Intermediate Level
	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

	Excel XP: Advanced Level
	1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal and 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 and VLOOKUP Functions 3.1 The IF Functions & Relational Operators 3.2 Using Words in IF Functions 3.3 Using Logical Operators (AND & OR) with the IF Function 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

Note: Course outlines are subject to change.