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

Advanced Microsoft Excel 2010 Tutorial

A professionally created, self-study video training course
Includes 9 hours of easy to follow Advanced 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 Advanced Microsoft Excel 2010 tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 9 hours
  • Video lessons: 134
  • Product code: 01625
  • In stock: YES
Learn how to take control of the more complex and advanced features of the industry leading spreadsheet application with this easy-to-follow Advanced Excel 2010 tutorial.

Presented by expert tutor Guy Vaccaro, he uses high quality video training movies to help explain and demonstrate the more challenging aspects of Excel 2010, helping you to leverage the true potential of this software to work for you and your business.

In over eight hours of professionally created video training, the tuition includes calculating Mean using AVERAGEIF, lessons on carrying out lookups with HLOOKUP and VLOOKUP, data and math functions, using pivot tables, creating and recording Macros and so much more. You can view the complete training course contents below and start learning right away, click any of the blue linked lessons to sample FREE Advanced Excel 2010 tutorials...
What Our Customers Are Saying

"With all the training Manuals I've purchased, I must say that this is the best instructional on this piece of software i've come across. I feel that I will now be able to tap into that power with this excellent tutorial."Ian Ramsden, Fusion Systems;
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
Data Functions
The MATCH Function Explained
The INDEX Function Syntax
How To Stop Nonexistent Row Or Column Lookups In INDEX
The CHOOSE Lookup Function

Math Functions
Working With TIME In Excel
Rounding To Fractional Values
MOD For Working Out Remainders
Generating A Random Number
Pick A List Item At Random
Calculating Loan Repayments Using PMT
Investment Calculations Using PMT
Working Out Depreciation
Working Out Different Parts Of A Loan Calculation

What Is An Array And An Array Formula
Creating And Using An Array Formula
Conditional Evaluation In An Array Formula
The Very Clever TRANSPOSE Array Function

Functions For Working With Text
LEN And TRIM Two Very Useful Text Functions
Using LEFT And RIGHT For String Extraction
FIND And MID Working Together To Extract Parts Of Strings
Build Strings From Multiple Cells
Changing The Case Of Text In Cells
Formatting Numeric Values With A Text String Using TEXT
Extracting The Values From The Text Functions We Have Used

Other Useful Functions
Welcome To IS Functions
The OFFSET Formula Explained
Dynamic Named Ranges Using The OFFSET Function
Use The INDIRECT Function To Build Dynamic Formulas
Dealing With INDIRECT Errors
Use Formulas To Determine An Excel Filename And Or Sheet Name

Creating A Sparkline
Change The Design Of Sparklines
Dealing with Empty Cells
Comparing One Sparkline To Another by Altering Vertical Scale
Removing Sparklines From A Sheet

Outlining Explained
Creating An Outline Automatically
Creating An Outline Manually
Manually Removing Data From An Outline
Removing The Outlining From A Worksheet
Adjusting A Grouping Created By Automatic Outlining

Custom Views
Creating A Custom View Of A Worksheet
Changing From One Custom View To Another
Editing A Custom View
How To Delete A Custom View

Setting Up A Scenario And Entering Values
Display The Scenario Values
Editing The Values Of A Scenario
Deleting A Scenario
Merge Scenarios From Different Sheets
Getting A Summary Of All Scenarios

Auditing And Troubleshooting Formulas
Description Of Tracer Arrows
Tracing Precedents And Dependents
Remove Tracer Arrows
Error Checking Using Auditing Tools
Step By Step Processing Of Formula To Help With Troubleshooting
Utilizing The Watch Window

Pivot Tables
What Is A Pivot Table
Steps To Create A Pivot Table
Rearranging Fields In A Pivot Table
Changing The Math Of The Data Summary
Number Format Control Of The Summary Area
Creating A Second (Or More) Pivot Table On The Same Data
Moving A Pivot Table
Removing A Pivot Table
Making Use Of The Report Filter Option
Sorting A Pivot Tables Columns
Displaying Values As A Percentage
Refreshing A Pivot Table Manually Or Semi-Automatically
Drilling Down Behind The Pivot Table Summaries
Applying Pivot Table Styles
Creating Your Own Custom Pivot Table Style
Copying A Pivot Table Style Between Workbooks
Using More Than One Field In Row And Column Headings
Disabling And Enabling Grand And Sub Totals
Filtering Columns And Rows Within A Pivot Table
Dealing With Empty (NULL) Cells
Exploring The Additional Pivot Table Options
Introducing The Slicer Tool
Managing Your Slices
Formatting Your Slices
Connecting A Pivot Table To SQL Server
External Connection Refresh Rate And Password Saving

Pivot Charts
Creating A Pivot Chart
Altering Chart Types Formats And Layouts
Advanced Layout Control Of A Pivot Chart
Filtering A Pivot Chart
Hiding Pivot Chart Elements
Moving A Pivot Chart Between Sheets
Deleting A Pivot Chart (With Care)

Goal Seek And Solver
Using Goal Seek To Carry Out What If Analysis
Using SOLVER To Carry Out What if Analysis
Activating The SOLVER Add In
Add Constraints Into A SOLVER Problem
Alberts Cafe Solver Solution

Macros in Microsoft Excel 2010
What Is A Macro in Excel 2010
Creating Storing And Running Your First Macro
Using Relative Or Absolute Referencing During Recording
Saving Workbooks With Macros Issues
Opening Files Containing Macros
The PERSONAL Workbook
How To Delete Macros
Use A Macro For Formatting in MS Excel 2010 - Lesson 1
Use A Macro For Formatting in MS Excel 2010 - Lesson 2
Trigger A Macro With A Keyboard Shortcut
Using Form Buttons To Trigger Macros
Customizing The Form Buttons
Assigning Macros To Ribbon Icons
Create Your Own Ribbon
Remove Options From Ribbons
View And Edit Macro Code
Add A Confirmation Dialog Box To Macros
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
Once purchased, you will receive 134 Advanced Microsoft Excel 2010 training videos (listed left), lasting a total of 9 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 Advanced 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 Advanced 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 Advanced 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 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