Checkout | Help

Training Home | Microsoft Office | Microsoft Excel 2010

Microsoft Excel 2010 Tutorial DVD - Video Training

Take your skills to the next level. This Microsoft Excel 2010 Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.

These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Microsoft Excel 2010 Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.

Share |

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Learn Microsoft Excel 2010 from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer a free insight into the quality of these Microsoft Excel 2010 tutorials.

Discounted Excel 2010 Bundle

Beginners to Advanced Microsoft Excel Bundle

You may wish to take advantage of our Discounted Training Bundle, that covers Excel from a beginners level all the way through to advanced.

OVER 18 hours of Microsoft Excel Training Videos - ONLY $149.95

Totally master Excel, from beginners to advanced. This single training bundle contains all you need to use Excel to maximum effect. Authored by Excel Guru Guy Vaccaro this course comes complete with working files

Customer Testimonials

I am both a production company owner with 30 years of experience, and a review writer. When I first started reviewing your site for P3 Update Magazine several months ago, I had no idea how awesome it was. Now, after having viewed over 275 movies, I rely on it to quickly learn new software applications. Learning FCP Studio was easy, and some of the advanced techniques that I learned really impressed my clients. I couldn't imagine anyone not needing this valuable resource.
david h.

01. Getting Started

Overview Of Excel 2010 Demo
The New File Menu In Excel 2010 Demo
Exploring The Excel Workbook Demo
What Will I Be Able To Do At The End Of This Course Demo
Customizing The Quick Access Toolbar Demo
Working With The Ribbons Demo
Using The Files Included With This Course Demo

02. Working With An Excel Worksheet

03. Selecting And Entering Data

Entering Text And Numbers Demo
Entering Numbers As Text Demo
Inputting Dates And Times Demo
Editing The Contents Of A Cell Demo
Using Copy And Paste Demo
The FILL Handle Demo
Using Undo And Redo Demo
Shortcuts For Selecting Cells Demo
Inserting Cells, Columns And Rows Demo
Deleting Cells, Columns And Rows Demo
Changing Column Widths And Row Heights Demo
Hiding And Unhiding A Column Or Row Demo
Searching For Values In A Worksheet Demo

04. Developing A Workbook

0401 Formatting And Naming Of Worksheet Tabs
0402 Moving Worksheets Within And Between Workbooks
0403 Copying Worksheets Within Workbooks
0404 Inserting And Deleting Worksheets
0405 Viewing More Than One Workbook
0406 Hiding And Unhiding Worksheets

05. Printing And Page Setup

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

06. Workbook Formatting

0601 Modifying Typeface, Font Size And Colors
0602 Merging Cells
0603 Applying Number Formats
0604 Aligning Cell Contents
0605 Changing The Text Direction In A Cell
0606 Adding Borders To Cells And Ranges
0607 Applying A Date Format To A Cell Or Range
0608 Use Of The Format Painter
0609 Clearing Cell Contents And/Or Formatting

07. Carrying Out Calculations

0701 Getting Started With Basic Math Formula Addition
0702 Getting Started With Basic Math Formula Subtraction
0703 Getting Started With Basic Math Formula Multiplication
0704 Getting Started With Basic Math Formula Division
0705 Getting Started With Basic Math Formula Operand
0706 Order Of Operations with BODMAS
0707 Introduction To Excel Formulas: SUM
0708 Copying Formulas And Functions
0709 Displaying Formulae On A Worksheet
0710 Some Useful Functions For Counting
0711 Some Useful Functions For Averages
0712 Some Useful Functions For Highest And Lowest
0713 Absolute Referencing Requirements
0714 Formulas Across Worksheets
0715 Functions Across Worksheets
0716 3D Referencing
0717 Making Use Of Named Cells And Ranges

08. Advanced Formatting

0801 Enhancing Worksheets Using Themes
0802 Working With Comments
0803 Creating Your Own AutoFill List
0804 Turning Your Data Into A Table For Formatting

09. Security

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

10. Using Templates

1001 Creating A Workbook From A Template
1002 Creating Your Own Custom Template

11. Graphics Objects

1101 Inserting And Modifying Clipart
1102 Using SmartArt Graphics
1103 Adding Drawn Shapes To A Worksheet
1104 Inserting An External Picture
1105 Adding A Background Image To A Worksheet
1106 Formatting Graphic Objects
1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
1108 Grouping Graphic Objects
1109 Accessing Formula Results In A Callout Bubble

12. Using Excel As A Database

1201 Fixing Rows And Columns On Screen
1202 Fixing Rows And Columns For Print
1203 Sorting Data In A Worksheet
1204 Filtering Data In A Worksheet
1205 Removing Duplicates In An Excel Database
1206 Adding And Using Subtotals In An Excel Database
1207 Splitting One Column Of Data Into More Columns
1208 Splitting The Screen To View Different Parts Of The Same Worksheet
1209 Linking To Data On A Webpage

13. Using Charts In Excel

1301 Creating A Chart The Long Way
1302 Creating A Chart The Quick Way
1303 Changing A Chart From A Sheet Object To A Sheet
1304 Modifying Your Chart Type
1305 Controlling Chart Style And Layout
1306 Adding A Trend line To A Chart
1307 Pie Charts In More Detail

14. More Advanced Formula

1401 Adding An IF Function For Cell Comparisons
1402 Using the IF Function To Suppress Excel Error Messages
1403 Text Manipulation With Formulae - Part 1
1404 Text Manipulation With Formulae - Part 2
1405 Date Formula In Excel
1406 DATEDIF - A Hidden But Useful Formula
1407 SUMIF COUNTIF And AVERAGEIF
1408 Use Of A Formula To Rank Scores

15. Conditional Formatting

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

16. Office Web Apps And Excel

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

17. Credits And Beyond

1701 About The Author

Microsoft Excel 2010 Training Video Info

Title Information.

In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to the latest version of Microsoft's standard spreadsheet application.

In this Excel Training Video, you will learn by watching the author actually perform the operations he is instructing on, as he explains step by step to how to perform these functions. Guy explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and even covers topics such as basic to advanced formula and functions. He has even included a chapter on connecting to the new Microsoft Web Apps, and how to use your own SkyDrive to store and share your Microsoft Excel projects. Included with this training video are full practical working files, to allow you to work along side of Guy as he teaches you how to use Microsoft Excel 2010.

By the completion of this computer based training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial environment. Close »

Instructor : Guy Vaccaro

All Training Courses by this author

Publisher:

InfiniteSkills - SKU: 01596

Duration:

9.5 hours - 126 lessons

Date Released:

2010-06-22

Platform:

Windows PC or Mac

Format :

Download or DVD-ROM

Price:

$99.95

£63.99

€74.99

Select your delivery option

Related Microsoft Excel 2010 Training Videos :

Multi User Version Available

An affordable way to train multiple users
This course is also available in multi-user format which is ideal for corporate users, schools and universities. The multi-user training loads directly onto your own server and delivers training to multiple users over your own network. It's easy to install and can be integrated into existing learning systems or used as a stand alone solution. Additional information...

Cost Per 10 User Licence:
	$500.00		£320.1		€375.15

Unlimited Learning for Schools & Government

Ideal for Schools, Universities and Government bodies, that are interested in training an unlimited number of users in a wide range of different applications. A cost-effective learning platform that delivers content over your own network. Simple to install and configure, it can be integrated into an existing LCMS or used as a standalone learning platform to deliver on demand training classes anywhere within your organization.
More Information

100% Money Back Guarantee

Complete Customer Satifaction is our goal.
All InfiniteSkills Training DVDs come with a 100% money back guarantee. If your not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund.

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Web Programming With Python
Learning Adobe Photoshop Lightroom 4
Learning CSS3
Learning MySQL 5
Learning Oracle 11g

View All Our Free Content on the iPad

Got An iPad, Why Not View All Our Free Movies? Keep up to date with all our new and current releases, right from your iPad, just download our free App directly from Apple and you're set to go. Content will be added automatically as new titles are released. It's easy to use, it's Portable and it's FREE

Customer Comments

Also, I had to learn Captivate on the fly. As in, this week. The tutorial got me started and I can now create exactly what it is I need with only a few hours' training, and at pennies on the dollar compared to other methods of learning. Thanks.
kieran h

Infinite Skills Inc
T: 858-866-9147.
Email :