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




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

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

Advanced Microsoft Excel 2010 Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!
 Professionally created, self-study video training.

About this Tutorialshow details
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...
Learn this Software - See below for FREE TUTORIALS
BEGINNER COURSES...
We also have the
Microsoft Excel 2013 Tutorial

and the
Beginners Microsoft Excel 2010 Tutorial


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


FREE Shipping on ALL Orders
Advanced Microsoft Excel 2010 Tutorial Info
Tutor: Guy Vaccaro
Duration: 8.5 hrs / 134 video lessons
This course is currently on offer:
20% OFF & FREE Shipping!
UK Price: £79.95 £63.95 + VAT

EU Price: €84.95 €67.95 + VAT

US & Canada: $124.95 $99.94
Product Code: 01625
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 8, 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Share |


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 provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling 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, workshops & classes.
  You can jump to and from lessons allowing you to learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals, basic handbooks, and for dummies books.
Customer Testimonials
Associated Training CDs:
Microsoft Access 2010 | Microsoft OneNote 2013 | Microsoft PowerPoint 2010 | Complete Range of Microsoft Office 2010 Tutorials | Microsoft Outlook 2010 | Complete Range of Advanced Excel Tutorials | Microsoft Excel 2013 Advanced | Microsoft Office 2010 | Complete Range of Microsoft Excel Tutorials | Complete Range of Microsoft Office 2013 Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials have a higher sound & video quality.

FREE Sample Videos from this Course

Getting Started
How Advanced Does The Advanced Get?
Using The Files Included
About The Tutor
New In 2010 - The Sparkline

The IF Function
The Syntax Of IF
Nesting The IF Statement
Use AND Operator To Reduce Quantity Of Nested IFs
Use OR Operator To Reduce Quantity Of Nested IFs
The NOT Operator Within AND And OR Statements
SUMIF For Selective Adding Up
COUNTIF For Selective Counting
AVERAGEIF For Mean Of Cells That Meet Our Criteria
Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions

Performing Lookups
VLOOKUP Explained
Applied Examples For VLOOKUP
HLOOKUP Explained
HLOOKUP In Action
Looking For A Near Match In A Lookup
Checking For Missing Data In A Lookup
Extending The Size Of A Lookup Table
Nested LOOKUPs

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


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

Arrays
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
REPLACE And SUBSTITUTE In Action
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
Error Checking With ISERR ISERROR ISNA And IFERROR
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

Sparklines
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
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

Scenario
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