Advanced Microsoft Excel 2010 Training DVD Tutorial

Advanced Microsoft Excel 2010 Training DVD ROM

Duration: 8.5 hours
Lessons: 134

In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners Excel 2010 tutorial by delving even deeper into this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this video based tutorial, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP.

This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced tutorial video for Excel 2010 is not for beginners, and only if you have a firm grasp of the basics should you proceed with this video training. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same files the author trains you with.

Click Tutorials for Computer Software to go back a level

Advanced Microsoft Excel 2010 Training DVD ROM

SUMMARY OF CONTENTS

For Full contents list, please click PDF button above.

01. Getting Started
02. The IF Function
03. Performing Lookups
04. Data Functions
05. Math Functions
06. Arrays
07. Functions For Working With Text
08. Other Useful Functions
09. Sparklines
10. Outlining
11. Custom Views
12. Scenario
13. Auditing And Troubleshooting Formulas
14. Pivot Tables
15. Pivot Charts
16. Goal Seek And Solver
17. Macros

Publisher: Infinite Skills
Author: Guy Vaccaro
Media Type: Video DVD ROM
Run Time: 8.5 hours
Language: English
Level: Advanced

System Requirements
Mac: OS X 10.2 or higher
PC: Win 7/Vista/XP/2000
DVD ROM
1024 x 768 Monitor Resolution

Not for use on a set top box - only works on a computer!

Delivery Options selectable at the Checkout

UK
- Only 99p Standard UK Delivery (plus vat where applicable)
- Optional services including UK Next Working Day Delivery
For all UK delivery options including UK Next working day, please see our Delivery Information Page

International
Royal Mail Registered Airmail or FedEx Courier options available.
For all International delivery options and price guide, please see our Delivery Information Page

International customers may also find our Ordering for Overseas Customers Information Page helpful.