Microsoft Excel 2002 Training Video - Tutorial CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'One of the MOST EFFECTIVE training tools out on the market today, BAR NONE!!!!!!'
  Robert McClain
  Kansas City, KS ;

Just Released Training

Just Released this week.
• 
Sony Vegas 10 Training Video

Select your PlayBack Preference
QuickTime Flash

Topics covered on this Tutorial Video
are Listed Below:-

• About Excel
• Open/ Save/Close Workbooks
• What’s Inside the Workbook
• Menus and Toolbars
• What’s on a Worksheet
• Getting Assistance from Excel

• Select and Navigate Cells
• Enter Data
• Edit and Delete Data
• Undo and Redo
• Cut/Copy/Paste
• About the Office Clipboard
• Drag and Drop
• AutoFill
• More Ways to Enter Repetitive Data
• AutoCorrect
• Use a Data Entry Form
• Validate Data During Entry

• Resize Rows and Columns
• Insert and Delete Rows/Columns/Cells
• Rename Worksheets
• Move and Copy Worksheets
• Insert and Delete Worksheets
• Freeze and Split a Worksheet
• Open Multiple Windows

The purchased version of this Training contains all the movies listed below as well as all the featured Movies above. US$ 99.95

• Calculate Without a Formula
• Use AutoSum to Write Formulas
• Formula Structure
• Create Formulas
• Edit Formulas
• AutoFill Formulas
• Relative and Absolute References
• Functions
• Use the Function Wizard
• Name Cells and Ranges
• Use Names in Formulas

• AVERAGE/MAX/MIN
• SUMIF and COUNTIF
• VLOOKUP
• PMT
• NOW/ TODAY/CONCATENATE
• IF and Nested Functions

• Sort Data
• Filter Data with AutoFilter
• AND and OR Filters
• Calculate Filtered Records
• PivotTables
• Consolidate Data
• Subtotal a Worksheet

• Text Formatting
• Align and Wrap Text
• Number Formats
• Date and Time Formats
• Custom Formats
• Borders and Shading
• Conditional Formatting
• Format Painter
• Styles
• AutoFormat a Table
• Transpose Tables and Merge Cells
• Format Several Worksheets Identically
• Save a File as a Template

• About Charts
• Create a Chart
• Resize and Relocate a Chart
• The Chart Toolbar
• Chart Options
• Legends/Titles/Axes
• Series Orientation and Order
• Create 3-D Charts
• Explode a Pie Chart
• Add Data Labels and a Data Table
• Trendlines
• Secondary Axes
• Format Chart Elements

• Create Page Headers and Footers
• See a Print Preview
• Set the Print Area
• Print a Selection
• Centering/ Margins/Gridlines
• Print on a Specific Number of Pages
• Print Multiple Worksheets/Copy/Collate Pages
• Print Row and Column Labels on Every Page
• Print Charts

• Share Data Between Workbooks
• Copying/Linking/Embedding Data
• Share Data with Other Programs
• Share a Workbook with Other Users
• Hide Worksheets
• Protect Cells
• Protect Worksheets and Workbooks

• Use Goal Seek to Find Answers
• Use Scenarios to Compare Alternatives
• Locate Worksheet Errors and Invalid Data

• Customize Your Toolbars
• Create a Custom Toolbar
• Automate with Macros
• Record a Macro
• Edit a Macro
• Assign a Macro to a Toolbar Button
• Create a Hyperlink to Open Another File

• Insert a Picture
• Move/Resize/Crop
• Draw Shapes and Lines
• Draw AutoShapes and Assign Macros
• Arrange and Group Drawing Objects
• Use Drawn Objects in Charts
• Create Text Boxes
• Create Worksheet Comments

An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft Excel 2002 Training - VIDEO INFO

TitleMicrosoft Excel 2002

TutorJulia Kelly

Duration6.5 hours - 109 Movies

Price US$ 99.95

OS Win 7 ,Vista, XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33440