About Us|Contact Us|Learn Now: Find a Course
Like us and Save!  Join our Mailing List and Save!
Connect with us for News & Exclusive Offers:
View Cart
Contact Us
20% Discount
& FREE Shipping!

Microsoft Excel 2013 Tutorial

A professionally created, self-study video training course
Includes 8 hours of easy to follow Microsoft Excel 2013 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 2013 tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 8 hours
  • Video lessons: 106
  • Product code: 01743
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 3rd December 2012
Learn how to use the world's most popular spreadsheet application to accurately perform calculations, create graphs and charts and so much more with the help of these step-by-step Microsoft Excel 2013 tutorial videos.

Commencing from the absolute basics, expert MS Excel tutor Guy Vaccaro presents easy-to-follow training videos that help explain and demonstrate the uses of the important tools, getting to grips with the new features for the 2013 release, and some great workflow techniques that will help boost your skills and to work faster and smarter.

Through over seven hours of professionally created video training, the tuition includes a tour of the new workspace, managing workbooks and worksheets, the basics of data entry, learning mathematical formulas, how to format your worksheet, adding graphics to your spreadsheet, lessons on creating charts, using MS Excel as a database step-by-step and so much more.

The exact same Excel files that the trainer demonstrates on are also included in the course allowing you to work in parallel with his on-screen actions and accelerate the learning process.

The complete training course contents are listed below and you can start learning right away, click any blue linked lesson to sample a FREE Excel 2013 video tutorial and discover how effective this visual teaching method is...
What Our Customers Are Saying

"I have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Start Here
Let's Get Started With Excel 2013
The Excel Workbook Explained
Signing Up For Your Own Free SkyDrive
Customize The Quick Access Toolbar
Using The Included Working Files
About The MS Excel Tutor

Managing Excel Workbooks And Worksheets
Creating And Saving A New Workbook
Opening Workbooks And Save As Options
Saving And Opening SkyDrive Files
Navigating An Excel Workbook
Adding And Removing Worksheets
Renaming Copying And Moving Worksheets

Entering And Editing Data In Cells
Entering Text, Numbers, And Dates
Entering Numbers As Text
Editing The Contents Of A Cell
Undo And Redo Actions
Cut, Copy, And Paste
Dragging And Dropping Cells
The Fill Handle
Inserting And Deleting Cells Columns And Rows
Changing Column Widths And Row Heights
Hiding And Un-Hiding Columns And Rows
Searching For Values In A Workbook

Math Basics
Getting Started With Basic Math Formulas
Order Of Operation With BODMAS
Introduction To Basic Formulas
Copying Formulas And Functions
Displaying Formulas On A Worksheet

Formatting Worksheets
Selecting Cells For Formatting
Modifying Typeface Font, Size, And Colour
Merging And Wrapping Cell Contents
Using Number Formats
Cell Content Alignment And Orientation
Adding And Removing Borders From A Selection
Applying A Date Format To A Cell Or Range
The Format Painter
Finding And Replacing Formats
Clearing Cell Contents VsClearing Cell Formatting

Workbook And Worksheet Management
Worksheet Navigation And Coloured Worksheet Tabs
Moving Or Copying Worksheets Within And Between Workbooks
Viewing And Scrolling Multiple Workbooks At The Same Time
Hiding And Un-Hiding Sheets
Modifying More Than One Worksheet At A Time

Page Setup And Printing
Using Print Titles And Print Areas
Paper Size, Orientation, Margins, And Scaling Options
Creating Headers and Footers
Using The Page Break And The Page Layout Views
Printing A Range Of Cells
Running The Spell Checker
Controlling Most Print Settings In One Place

Mathematical Formulas
The Sum Function
Copying Formulas And Functions
Other Mathematical Functions: Average, Min, And Max
Useful Count Functions
Absolute Referencing Explained
Formulas Across Worksheets
3D Referencing
Making Use Of Named Cells And Ranges

Advanced Formatting
Enhancing Worksheets Using Themes
Adding, Editing, And Deleting Comments
Creating Your Own Autofill List
Converting Data To A Table For Formatting

Security
Activating And Deactivating Worksheet Protection
Protecting Part Of A Worksheet To Aid Data Entry
Password Protecting The Whole Workbook

Excel 2013 Templates
Using The 2013 Templates
Creating And Using Your Own Template

Graphics Objects
Obtaining And Inserting Online Images
Using SmartArt Graphics
Inserting Shapes And Screenshots
Formatting Graphical Objects
The Stacking Order
Grouping Multiple Objects Together
Using Graphical Objects And Mathematical Formulas

Using Charts In Excel
The New Recommended Charts Option
Create A Chart Using The Long Or The Short Method
Formatting A Chart With The 2013 Shortcut Options
Modifying The Chart Type
Formatting Chart Elements
Adding A Trendline
The Pie Chart In Detail
Mini Graphs: Sparklines

Excel As A Database
Fixing On Screen Rows And Columns
Fixing Print Rows And Columns
Sorting Data In Excel
Filtering Data To Reduce Dataset Size
Removing Duplicate Entries In The Data
Adding Subtotals To A Worksheet Of Data
Using Text To Columns Effectively
Linking To Data On A Webpage

Advanced Formulas
Using An If Formula
Use Of The If Function To Hide Excel Error Messages
Datedif: A Useful But Hidden Formula
Text Manipulation Using Functions
Use The Text Function To Format Numbers
Date Manipulation Functions
Introducing Sumif, Countif, And Averageif
Use Of Rank To Calculate Placings
Flash Fill: The Magic Touch

Conditional Formatting
Altering Cell Appearance Based On The Cell Value
Displaying Data Bars, Color Scales, Or Icon Sets
Using Top And Bottom Rules For Formatting
Creating A Formatting Rule From Scratch
Managing The Conditional Formatting Rules

What's Next
The New Office Apps For MS Excel 2013
Ready To Go Advanced
Purchase Info
PRICE
The DVD and Download options include the same training contents and both priced as below:
  US & Canada: $124.95 $99.94

UK: £79.95 £63.95 + VAT

EU: €84.95 €67.95 + VAT
Purchase DownloadPurchase on DVD
For both purchase options you receive 106 Microsoft Excel 2013 training videos (listed left), lasting a total of 8 hours.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
|
Need to Train Multiple Users?
This Microsoft Excel 2013 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 through the network with a pre-determined number viewing the tuition at any one time. more info
$500.00£319.93€339.94
(Per 10 user concurrent licence)
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 2013. Show your boss or potential employer!
Weekly Specials
    Get 10% Off Today! Join our Email Newsletter
     
This Weeks Special Offer
See the new and discounted
Navisworks 2015 Tutorial
Recommended courses to watch next
Microsoft Excel 2013 Advanced | Complete Range of Advanced Excel Tutorials | Microsoft OneNote 2013 | Microsoft Office 2013 | Microsoft Access 2013 | Microsoft Project 2013 | Microsoft Word 2013 | Microsoft Outlook 2013 | Microsoft PowerPoint 2013 | Microsoft Windows 8 | Complete Range of Microsoft Office 2013 Tutorials
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)