Microsoft Excel XP Advance Training Video

We Make it Easy to Learn Microsoft Word, Excel, Outlook and More - No Matter What Your Skill Level ...

Microsoft Excel XP Advance Training Video

Course Outline

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 and databases.

About Trainer
Richard Clements is one of our most dynamic instructors who brings 16 years of experience and an upbeat training style in creating and sustaining technical adult education modules. From Microsoft Office to SQL, Oracle and Macromedia, he is a content expert with thousands of satisfied clients. Throughout his career Richard has edited, authored and published numerous textbooks and articles for the computer industry. Richard’s definition of good technical training is presenting complex concepts in ways that user’s can understand and implement. Microsoft Excel XP Advance Training Video can be purchased individually or as a whole with Microsoft Office Suite.

Course Sets - Single User License *

(*) Please Email sales@computrainsolutions.com if you have question regarding to our multi-user licensing for this course or check our FAQ on the left menu.

Detailed Course Outlines for Excel XP Advance Training Video can be found below:

Excel XP Beginning

1.0

Introduction to Excel

1.1	Orientation
1.2	Tools
1.3	The Worksheet
1.4	Using the Keyboard to Navigate

2.0

Data Entry

2.1	Text
2.2	Selecting Cells
2.3	Values
2.4	Entering Formulas
2.5	Auto-Sum for Totals
2.6	The Average Function

3.0

Changing Worksheet Appearance

3.1	Simple Formatting
3.2	Fill & Font Colors
3.3	Undo
3.4	Borders

4.0

File Management

4.1	Saving Your Work
4.2	Opening a File
4.3	Creating a New Workbook
4.4	Closing a File

5.0

Additional Formulas

5.1	Cumulative Totals
5.2	% Change
5.3	Formula Symbols
5.4	Editing Formulas
5.5	Auto Calculate Feature

6.0

Formatting Features

6.1	Changing the Font Type & Size
6.2	Inserting Rows & Columns
6.3	Copying & Moving Data in a Worksheet

7.0

Printing Worksheets

7.1	Print Review
7.2	Printing Selections
7.3	The Print Button & Exiting Out of Excel

Excel XP Intermediate

1.0

Build In Functions

1.1	PMT Financial Function
1.2	Paste Function Tool

2.0

Dates & Times

2.1	Date Functions
2.2	Changing Date Displays
2.3	Time Functions

3.0

Setting Defaults

3.1	Tools Options

4.0

Multi-Sheet Workbooks

4.1	Inserting & Re-naming Sheets
4.2	Copying Worksheets
4.3	Formulas that Work Across Worksheets
4.4	Grouping Worksheets

5.0

Cell Reference

5.1	Absolute Reference
5.2	Mixed Reference

6.0

Format Cells Command

6.1	Changing Text Appearance
6.2	Adding Borders
6.3	Adding Color

7.0

Charts

7.1	Creating a Chart
7.2	Placing & Modifying Your Chart
7.3	Formatting a Chart
7.4	Shortcuts & Tricks
7.5	Pie Charts

Excel XP Advanced

1.0

Logical Function

1.1	If Statement
1.2	Modifying the If Statement
1.3	Vertical Lookup
1.4	Horizontal Lookup

2.0

Split Screen Techniques

2.1	Horizontal Split
2.2	Freeze Panes
2.3	Vertical Slit
2.4	Creating a Double Freeze

3.0

AutoFill Techniques

3.1	AutoFill
3.2	Dates Using AutoFill
3.3	Series Extension

4.0

Data Validation Techniques

4.1	Validating Data
4.2	The Auditing Toolbar & Keyboard Shortcuts

5.0

Excel Databases

5.1	Sorting Data
5.2	Sorting From the Toolbar
5.3	Data Sort Command
5.4	Creating Subtotals
5.5	Filtering

6.0

Range Names

6.1	Naming Cells

7.0

Additional Charting Capabilities

7.1	Formatting the X & Y Axis
7.2	Changing the Chart Style
7.3	FChanging Line Attributes
7.4	Utilizing Drawing Tools