Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Microsoft Excel 2010 Tutorial Video - Training CD / DVD covers everything you need to know to get started creating extensive tables and spreadsheets, even if you've never used Microsoft Excel in the past. Narrated by longtime software trainer Lauri Matson, this intuitive course combines real-time video examples with expert narration that breaks down Excel into its most basic tools and tasks, letting users work from the ground up to gain a solid understanding of how the application works. Excel 2010 features a number of enhancements that let you work more effectively with pivot tables, macros, and the power that new 64-bit systems can provide. As one of the most popular programs in offices and homes worldwide, it's never been a better time to learn how to use the application, and these straightforward MS Excel tutorials are a great place to start. Topics covered within the training include working with the ribbon interface, creating and editing workbooks, freezing and locking cells, working with formulas, managing data, employing charts and graphics, exporting data to other formats and much more. The tutorial series can now be ordered as one training package on CD / DVD or can be viewed streaming online through the instant video subscriber option.

Associated Tutorials: MS Excel 2007 Tutorial | PowerPoint 2010 | Visio 2007 Tutorial | OpenOffice 3 | Microsoft Access 2010 | Microsoft Project 2010 | Crystal Reports 2011 | Microsoft Office for Mac 2011

Microsoft Excel 2010 Tutorial CD / DVD

When you order this Microsoft Excel 2010 Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft Excel 2010 from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I've tried videos from some of the other sites out there but I have not found anything that matches the quality and consistency of your products. "Victoria Munoro, Virginia

Microsoft Excel 2010 Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8 Hours in Duration and Covers 120 Lessons.
Introduction to Microsoft Excel 2010 Overview of Menus / Shortcuts / Commands Starting to Use Excel 2010
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Screen Customizing
  • Ribbon Customizing
  • Utilizing Quick Access Bar
  • Using Quick View of Shortcuts
Framework Building
  • Making a New Spreadsheet
  • Table Attributes
  • Overview of Saving / Sending / Publishing
Editing Methods
  • Understanding Home Ribbon Lesson 1
  • Understanding Home Ribbon Lesson 2
  • Learning to Adjust Columns and Rows
  • Utilizing AutoCorrect and Spell Check
Data Manipulating
  • Using Find and Replace Data
  • Utilizing AutoFill
  • AutoFill Customizing
Adding Special Effects
  • Working with SmartArt Lesson 1
  • Working with SmartArt Lesson 2
  • Pictures & Shapes
Utilizing Different View
  • Utilizing Excel Options
  • Learning More About Options
  • Overview of the View Menu
  • Screen Splitting
  • Setting Out Multiple Workbooks
Visualizing Worksheets
  • Using Conditional Formatting
  • Fixing Rules for Conditions
  • Learning More About Rules
  • Text Customization & Alignment
  • Customization Continued
Safeguarding Your Work
  • Worksheets and Cell Hiding
  • Choosing Visible Cells
  • Overview of Protection
  • Validation
  • Understanding Validation Messages
  • Validating Dates
  • The Trust Center
Linking with Paste Special
  • Utilizing Paste Special
  • Linking to Other Applications
  • Linking with a Formula
  • Linking Data between Worksheets
  • Linking with Multiple Workbooks
Overview of Printing
  • Overview of the Page Layout Menu
  • Utilizing Headers and Footer
  • How to Print Headings on All Pages
  • Reviewing the Page Layout Menu
Using Templates
  • Utilizing Templates
  • Making a Custom Template
  • Using Comments
  • Making Hyperlinks
Cell References
  • Mastering Addressing
  • Absolute versus Relative
Introduction to Formulas
  • Overview of the Formula Menu
  • Order of Operations - The Fundamentals
  • Computing Values with AutoSum
  • Printing versus Viewing Calculations
  • Fundamental Formula Examples
  • Function Insert
Introduction to Advance Formulas and Functions
  • Overview of Functions versus Formulas
  • Making Formulas (Countif)
  • Using Names
  • Making Formulas with Names (Countif)
  • About the IF Statement
  • Understanding Conditional Statement Examples
  • Working with Formulas Manipulating Text
  • Managing Formula and Function Errors
Using Tables
  • Utilizing Excel Tables
  • Knowing Limitations and Compatibility
  • Calculating Table Data Values
Filtering and Sorting
  • Organizing Data
  • Utilizing the Filter Tool
  • Working with Advanced Filters
  • Calculating Subtotals
  • Learn More About Subtotals
Graphics and Charts
  • Making a Chart
  • How to Use the Design and Format Ribbons
  • Overview of the Layout Ribbon
  • Additional Editing Methods
  • Moving Charts
  • Considering Combination Charts
Making a Specialty Chart
  • Mastering Dialog Box Terminology
  • Using Single Point Chart
  • Introduction to Detailing the Chart
  • Overview of Recapping Wizards
Making Your Spreadsheets More Interesting
  • Utilizing the Insert Menu
  • Understanding Graphics
  • Introducing Color to your Spreadsheets
Inserting Objects
  • AutoShape Creating and Formatting
  • Inserting Shapes and Photographs
  • How to Move / Copy / Resize Graphics
Integrating Excel
  • Integrating Excel with Word
  • Integrating Excel and Other Office Applications Lesson 1
  • Intregating Excel and Other Office Applications Lesson 2
  • Making PDF Files
Using Pivot Tables
  • Understanding a Pivot Table?
  • Pivot Formatting
  • Formatting Continued
  • Utilizing Calculations
  • Working with Pivot Charts
Utilizing Databases
  • Relational Database versus Flat
  • Utilizing External Data
  • Undersatnding a Query
Overview of Automation and Macros
  • Learning About Automating Routines
  • Making a Macro
  • Macros Continued
  • How to Create a Macro from a Button
  • Buttons Continued
New Attributes for Your Work
  • Utilizing Comments
  • Using Graphs in Comments
  • Working with Sparklines
  • Learning about Slicers in Pivots
Helpful Information
  • Utilizing Help
  • About Help and Formulas
  • Using Work Files
Summary
  • Conclusion
Author
  • Author Bio

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Microsoft Excel 2010 Training CD

Title Microsoft Excel 2010
Tutor Lauri Matson
Other tutorials by Lauri Matson
Videos 120 Lessons- Video run time: 8 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2010
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
129 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft Excel 2010 from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos| Online Microsoft Excel 2010 Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.