30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Microsoft Excel 2010 Tutorial

A professionally created, self-study video training course
Includes 10 hours of easy to follow Microsoft Excel 2010 video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Excel 2010 tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 10 hours
  • Video lessons: 126
  • Product code: 01596
  • In stock: YES
Learn how to use this industry standard spreadsheet application to create, manage, analyze spreadsheet data and a whole lot more with the help of these beginners Microsoft Excel 2010 tutorial videos. Presented by veteran Excel tutor Guy Vaccaro, he uses step-by-step video training movies to help demonstrate and explain the full complement of features, the complete toolset, and the recommended workflow's ensuring that by the conclusion of the training you'll be capable of working with MS Excel 2010 to a proficient standard and in a commercial environment. Included in over 9 hours of video tuition is instruction on using basic and advanced formula, lessons on performing functions, learning how to connect to the new Microsoft Web Apps and using your own SkyDrive to store and share your MS Excel projects. You can view the complete training listings below and start learning right away, click any of the blue linked lessons for FREE Excel 2010 tutorial videos and discover how effective this practical teaching guide is...
What Our Customers Are Saying

"Just a quick mail regarding the tutorial........ Excellent! Just the right level and speed I need, absolutely perfect. Far better than reading 10,000 words before you even get to the same working files."Kevin Baldwin, London
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via Download.
Paid Content

Get all lessons with purchase
Developing A Workbook
Formatting And Naming Of Worksheet Tabs
Moving Worksheets Within And Between Workbooks
Copying Worksheets Within Workbooks
Inserting And Deleting Worksheets
Viewing More Than One Workbook
Hiding And Unhiding Worksheets

Printing And Page Setup
Using The Print Area Command To Control What Excel Prints
Setting Page Margins And Page Orientation
Creating A Header And Footer
Using Page Break View
Setting Print Titles For Large Worksheets
Printing Gridlines Column Row Headings And Other Related Options
Enabling The New Page Layout View
Running The Spell Checker
Print Preview And Printing The Whole Or Part Of The Worksheet

Workbook Formatting
Modifying Typeface, Font Size And Colors
Merging Cells
Applying Number Formats
Aligning Cell Contents
Changing The Text Direction In A Cell
Adding Borders To Cells And Ranges
Applying A Date Format To A Cell Or Range
Use Of The Format Painter
Clearing Cell Contents And/Or Formatting

Carrying Out Calculations
Getting Started With Basic Math Formula Addition
Getting Started With Basic Math Formula Subtraction
Getting Started With Basic Math Formula Multiplication
Getting Started With Basic Math Formula Division
Getting Started With Basic Math Formula Operand
Order Of Operations with BODMAS
Introduction To Excel Formulas: SUM
Copying Formulas And Functions
Displaying Formulae On A Worksheet
Some Useful Functions For Counting
Some Useful Functions For Averages
Some Useful Functions For Highest And Lowest
Absolute Referencing Requirements
Formulas Across Worksheets
Functions Across Worksheets
3D Referencing
Making Use Of Named Cells And Ranges

Advanced Formatting
Enhancing Worksheets Using Themes
Working With Comments
Creating Your Own AutoFill List
Turning Your Data Into A Table For Formatting

Using Protection On A Worksheet
Protecting Part Of A Worksheet To Facilitate Data Entry
Controlling Access To Cell Ranges By Password And Or User Accounts
Saving A Workbook With Password Protection

Using Templates
Creating A Workbook From A Template
Creating Your Own Custom Template

Graphics Objects
Inserting And Modifying Clipart
Using SmartArt Graphics
Adding Drawn Shapes To A Worksheet
Inserting An External Picture
Adding A Background Image To A Worksheet
Formatting Graphic Objects
Controlling Stacking Order And Alignment Of Multiple Graphics Objects
Grouping Graphic Objects
Accessing Formula Results In A Callout Bubble

Using Excel As A Database
Fixing Rows And Columns On Screen
Fixing Rows And Columns For Print
Sorting Data In A Worksheet
Filtering Data In A Worksheet
Removing Duplicates In An Excel Database
Adding And Using Subtotals In An Excel Database
Splitting One Column Of Data Into More Columns
Splitting The Screen To View Different Parts Of The Same Worksheet
Linking To Data On A Webpage

Using Charts In Excel
Creating A Chart The Long Way
Creating A Chart The Quick Way
Changing A Chart From A Sheet Object To A Sheet
Modifying Your Chart Type
Controlling Chart Style And Layout
Adding A Trend line To A Chart
Pie Charts In More Detail

More Advanced Formula
Adding An IF Function For Cell Comparisons
Using the IF Function To Suppress Excel Error Messages
Text Manipulation With Formulae - Lesson 1
Text Manipulation With Formulae - Lesson 2
Date Formula In Excel
DATEDIF - A Hidden But Useful Formula
Use Of A Formula To Rank Scores

Conditional Formatting
Changing Cell Appearance Based On Its Value
Editing Conditional Formatting Rules On A Worksheet
Removing Conditional Formatting Rules
Highlighting Duplicate Values Using Conditional Formatting
Identifying The Top Or Bottom Percentage Of A Range
Use Of Data Bars Within Conditional Formatting
Use Of Colour Scales Within Conditional Formatting
Applying An Icon Set To Conditional Formatting Rules

Office Web Apps And Excel
What Is Office Web Apps?
Sign In To Or Sign Up For Your Own SkyDrive
Saving An Excel Workbook Into SkyDrive
Accessing And Editing An Excel Workbook Through SkyDrive
Telling Others Where Your Public Documents Are
Direct Linking Or Embedding Of SkyDrive Documents
Creating A Folder Structure Within SkyDrive
Deleting Files From SkyDrive

Credits And Beyond
About The MS Excel Tutor
Microsoft Excel 2010 Training CD End
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
Once purchased, you will receive 126 Microsoft Excel 2010 training videos (listed left), lasting a total of 10 hours and the working files.

Delivery Details
Download Course downloadable when payment processed (within one hour average)
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
Need to Train Multiple Users?
This Microsoft Excel 2010 course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system

For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Excel 2010 course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
See our complete range of Microsoft Excel Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Excel 2010. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"I was pointed to your site by a professor at my University. I have not only benefited by your excellent training in learning more, but I have also saved hundreds on textbooks and other reference material."David Willams Essex (UK)