clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master Microsoft Excel 2010 - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it’s all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included. To begin learning today, simply click on the movie links.
Microsoft Excel 2010 Training
Access the complete Microsoft Excel 2010 Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Excel 2010 plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Excel 2010 from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Excel 2010
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Excel 2010
Description: Click here to open / close full description
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it’s all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included. To begin learning today, simply click on the movie links.

-Close-
Instructor: Lauri Matson (more by this author)
Instruction: 120 Tutorials - Duration: 8 hrs
First Release: 2011-07-01
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Excel 2010
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Excel 2010
 
Below is content list for all of the lessons included with the Microsoft Excel 2010 Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Welcome to Excel
movie image Introduction
movie image Course Objectives

Menus / Shortcuts / Commands
movie image Touring the Excel Screen
movie image Understanding the Backbone of File Management
movie image Compatibility with Earlier Versions

Getting Started
movie image Starting Excel
movie image Multiple Methods for Tasks
movie image Moving Around


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

Customizing Your Screen
Customizing the Ribbon
Quick Access Bar
Quick View of Shortcuts

Building a Framework
Creating a New Spreadsheet
Table Features
Saving / Sending / Publishing

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

Manipulating Data
Finding and Replacing Data
Using AutoFill
Customizing AutoFill

Adding Special Effects
SmartArt pt. 1
SmartArt pt. 2
Shapes and Pictures

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

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

Protecting Your Work
Hiding Cells and Worksheets
Selecting Visible Cells
Protection
Validation
Validation Messages
Validating Dates
The Trust Center

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

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

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

Cell References
Understanding Addressing
Absolute vs. Relative

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

Advance Formulas and Functions
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 Tables
Working with Excel Tables
Understanding Limitations and Compatibility
Calculating Table Data Totals

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

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

Creating a Specialty Chart
Understanding Dialog Box Terminology
Single Point Chart
Detailing the Chart
Recapping Wizards

Spicing Up Your Spreadsheets
The Insert Menu
Working with Graphics
The Need for Color

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

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

Working with Pivot Tables
What is a Pivot Table?
Formatting Pivots
More Formatting
Calculations
Pivot Charts

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

Automation and Macros
Automating Routines
Creating a Macro
More Macros
Macros from Buttons
More Buttons

New Features for Your Work
Using Comments
Graphs in Comments
Sparklines
Slicers in Pivots

Final Tips
Using Help
Help and Formulas
Work Files

Conclusion
Wrap Up

Credits
About the Author
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2012 VTC Canada All Rights Reserved.