Microsoft Excel 2010 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

• 'I purchased the Painter CD from VTC. I first heard of your company from a review in the Computer Link, a section of the San Diego Union Tribune. From there I checked out your web site, and got your phone no. John (Heck, vice president) and Rochelle (Carrera, administration manager) were very helpful and courteous when I called with a problem installing the CD. Thanks again!'
  Jay R. Steele,
  Photographer, Computer Animator, Graphic Artist, Teacher
  San Diego, CA ;

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:-

• Introduction
• Course Objectives

• Touring the Excel Screen
• Understanding the Backbone of File Management
• Compatibility with Earlier Versions

• Starting Excel
• Multiple Methods for Tasks
• Moving Around

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

• Customizing the Ribbon
• Quick Access Bar
• Quick View of Shortcuts

• Creating a New Spreadsheet
• Table Features
• Saving / Sending / Publishing

• Home Ribbon pt. 1
• Home Ribbon pt. 2
• Adjusting Columns and Rows
• AutoCorrect and Spell Check

• Finding and Replacing Data
• Using AutoFill
• Customizing AutoFill

• SmartArt pt. 1
• SmartArt pt. 2
• Shapes and Pictures

• Using Excel Options
• Options Continued
• The View Menu
• Splitting the Screen
• Arranging Multiple Workbooks

• Conditional Formatting
• Setting Rules for Conditions
• Rules Continued
• Alignment and Text Customization
• More Customization

• Hiding Cells and Worksheets
• Selecting Visible Cells
• Protection
• Validation
• Validation Messages
• Validating Dates
• The Trust Center

• Using Paste Special
• Linking Data between Worksheets
• Linking with Multiple Workbooks
• Linking to Other Applications
• Linking with a Formula

• The Page Layout Menu
• Headers and Footer
• Print Headings on All Pages
• Wrapping Up the Page Layout Menu

• Using Templates
• Creating a Custom Template
• Working with Comments
• Creating Hyperlinks

• Understanding Addressing
• Absolute vs. Relative

• The Formula Menu
• The Basics: Order of Operations
• Calculating Totals with AutoSum
• Printing vs. Viewing Calculations
• Basic Formula Examples
• Insert Function

• Functions vs. Formulas
• Creating Formulas (Countif)
• Names
• Creating Formulas with Names (Countif)
• The IF Statement
• Conditional Statement Examples
• Formulas Manipulating Text
• Formula and Function Errors

• Working with Excel Tables
• Understanding Limitations and Compatibility
• Calculating Table Data Totals

• Sorting Data
• Using the Filter Tool
• Applying Advanced Filters
• Working with Subtotals
• Subtotals Continued

• Creating a Chart
• The Design and Format Ribbons
• The Layout Ribbon
• More Editing Techniques
• Moving Charts
• Combination Charts

• Understanding Dialog Box Terminology
• Single Point Chart
• Detailing the Chart
• Recapping Wizards

• The Insert Menu
• Working with Graphics
• The Need for Color

• Creating and Formatting AutoShapes
• Adding Photos and Shapes
• Move / Copy / Resize Graphics

• Working with Word
• Excel and Other Office Applications pt. 1
• Excel and Other Office Applications pt. 2
• Creating PDF Files

• What is a Pivot Table?
• Formatting Pivots
• More Formatting
• Calculations
• Pivot Charts

• Flat vs. Relational Database
• Working with External Data
• What is a Query?

• Automating Routines
• Creating a Macro
• More Macros
• Macros from Buttons
• More Buttons

• Using Comments
• Graphs in Comments
• Sparklines
• Slicers in Pivots

• Using Help
• Help and Formulas
• Work Files

• Wrap Up

• About the Author

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 2010 Training - VIDEO INFO

TitleMicrosoft Excel 2010

TutorLauri Matson

Duration8 hours - 120 Movies

Price US$ 99.95

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

Delivery Ground / 2 day / Next Day

Product Code34181