Easy to follow Microsoft Excel 2010 Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft Excel 2010 tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft Excel 2010 Tutorial Video - Try for FREE

Details

This Microsoft Excel 2010 Tutorial Video Online Training is a convenient way to learn how to use this massively popular spreadsheet application. Relied upon by individuals, academics, small businesses, and corporations worldwide, Microsoft Excel can be utilized for almost any purpose. And with the upgrades introduced in Excel 2010, there has never been a better time to learn what you can use the program to do. In this innovative video course, you get practical examples presented in real time, with a full suite of playback controls that allow you to pause, repeat, and skip lessons at any time. This allows you to learn on your own terms and set your own pace. Narrated by expert Lauri Matson, the tutorial video course features helpful, step-by-step walkthroughs of a number of tasks, paying special attention to areas where beginners often run into trouble. All of the lessons listed are available to watch online as soon as your registration is complete. The membership plan also includes full access to the catalog of tutorial video online training, featuring courses in hundreds of other popular programs and technologies.

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!

Benefits of Online Learning

Unlimited viewing. No Hidden Costs
Downloadable working files.
Instant Access
Expert instructors.
Use at home / work or both.
Works on PC or Mac.
Telephone Tech support.
Cancel at any time.
600+ courses for 1 low fee.
New titles added monthly.
100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2010 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.

Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below

Topics covered on this tutorial video include:

Welcome to Excel

Menus / Shortcuts / Commands

Getting Started

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

Microsoft Excel 2010 Video Tutorial

Title Microsoft Excel 2010 Training Tutorial

Author Lauri Matson
Other Training Videos by this author

Duration 8 hours

Number of Videos 120

Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions

Own this Training Course on CD

Would you like to own this Microsoft Excel 2010 Training title on CD?

You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Microsoft Excel 2010 tutorial on CD.

Multi User Accounts - Cost Effective Training

For Educational Establishments and Corporate Customers we have the idea way to train multi users simultaneously. Just like the single user account the Multi User option gives unlimited access to all listed courses. The cost of training multiple users is significantly reduced.

Free Certification - Prove Your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customer Comments

We have been customers of Apex Web Media for over 3 years and would have no hesitation in recommending their professional and efficient services to any company looking for professional, affordable training.
S.J Holt
Suwanee Georgia