PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop CS5 Tutorial

Quicktime is required for the movies, click here to download if needed.
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality. Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

- See right for full details on this Microsoft Excel 2010 Tutorial

- See far right to purchase this Microsoft Excel 2010 Training CD

- Start to use the 2010 offering of this industry leading spreadsheet application to a professional and confident standard with the help of these comprehensive video training movies.

Microsoft Excel 2010 Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!

Professionally created, self-study video training.

About this Tutorial

show details

Learn how to use this industry standard spreadsheet application to create, manage, analyze spreadsheet data and a whole lot more with the help of this beginners Microsoft Excel 2010 tutorial. 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, performing functions, 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...

hide details

Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs or Download
For Mac and PC

FREE Shipping on all Orders

Microsoft Excel 2010 Tutorial Info

Tutor: Guy Vaccaro
Duration: 9.5 hrs / 126 video lessons
Cost for UK: £79.95 £63.95 + VAT
Cost for EU: €84.95 €67.95 + VAT
Cost for US & Canada: $124.95 $99.94 *no further discounts can be applied
Product Code: 01596
DELIVERY DETAILS Downloads: Training downloadable when payment processed (by next working day) CDs: Please allow 2-3 days for UK, Europe US & Canada, 3-5 days rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

Don't take our word for it, see our Customer Testimonials

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.

Learning is fast as the trainers guide you using simplistic terms and minimal jargon.

Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses, seminars & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Getting Started

Overview Of Excel 2010

The New File Menu In Excel 2010

Exploring The Excel Workbook

What Will I Be Able To Do At The End Of This Course

Customizing The Quick Access Toolbar

Working With The Ribbons

Using The Files Included With This Course

Working With An Excel Worksheet

Creating A New Workbook

Saving A Workbook

Saving In Other Formats

Open A Existing Workbook

Navigating An Excel Workbook

Selecting And Entering Data

Entering Text And Numbers

Entering Numbers As Text

Inputting Dates And Times

Editing The Contents Of A Cell

Using Copy And Paste

The FILL Handle

Using Undo And Redo

Shortcuts For Selecting Cells

Inserting Cells, Columns And Rows

Deleting Cells, Columns And Rows

Changing Column Widths And Row Heights

Hiding And Unhiding A Column Or Row

Searching For Values In A Worksheet

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the course via CD or Download

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

Security
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
SUMIF COUNTIF And AVERAGEIF
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 Tutor
Microsoft Excel 2010 Training CD End


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649