Special Offer! Until August 31, enter code schoolrocks2014 at the checkout to receive 50% off your DVD/Download order.

LinkedIn Google + Facebook YouTube Twitter
Project-based computer software/IT training videos
Microsoft Excel - Advanced Formulas And Functions Training Video

Microsoft Excel - Advanced Formulas And Functions Training Video

A Practical Excel Training Course That Teaches Real World Skills

In this project-based Microsoft Excel - Advanced Formulas And Functions video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Microsoft Excel - Advanced Formulas And Functions training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Microsoft Excel - Advanced Formulas And Functions subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft Excel - Advanced Formulas And Functions tutorial, online or offline... so you'll know the exact steps for your own projects.

Share |
SKU: 01838 | Duration: 5.5 hours - 58 tutorial videos | Date Released: 2013-09-16
Works on: Windows PC or Mac | Format: DVD and Download | Instructor: Guy Vaccaro

Table of Contents

expand all / collapse all

Course Description

In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel.

You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries.

By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.

Related Products

Advanced Microsoft Excel 2013 Training

Advanced Microsoft Excel 2013 Training

Level: Advanced
Instructor: Guy Vaccaro
Length: 10 hours
Lessons: 128
Released: 2013-01-29
Sku: 01755
Price: $99.95
More Info
Microsoft Excel - Shortcut Guide

Microsoft Excel - Shortcut Guide

Level: Intermediate
Instructor: Guy Vaccaro
Length: 3.25 hours
Lessons: 41
Released: 2013-09-30
Sku: 01848
Price: $24.95
More Info
Microsoft Excel - Tables Deep Dive

Microsoft Excel - Tables Deep Dive

Level: Intermediate
Instructor: Erin Olsen
Length: 3.5 hours
Lessons: 36
Released: 2013-12-10
Sku: 01877
Price: $24.95
More Info
Learning Microsoft Office For iPad

Learning Microsoft Office For iPad

Level: Beginner
Instructor: Andy Anderson
Length: 1.75 hours
Lessons: 39
Released: 2014-06-09
Sku: 01940
Price: $49.95
More Info

Unlimited Online Access - Just $25.00

Learning Library IconNot sure which video training course to purchase? Join our Online Learning Library and have unlimited access to all our content 24/7 for only $25.00 per month.

Subscribe Now
  • Unlimited Access To All Our Content
  • No Contract - You Can Cancel At Any Time
  • New Titles Added Each Week
  • Working Files Included
  • Access From Any Location
  • No Restrictions View As Much Content As You Wish
  • Free iPad/iPhone App - Learn While You're On The Move

Education and Enterprise Users

Want a cost effective solution to train multiple users?

Infinite Skills offer a variety of solutions to provide training across your organisation.

The Infinite Skills Multi-User training solutions can accommodate educational and corporate/government organizations of all sizes. It’s built to be a self-contained learning platform, but can also be easily integrated into an existing LCMS if required. Simply put it’s an highly affordable training platform that can be customised to meet your exact requirements no matter how many people you need to provide training to. select your organization type below to find out more.

Discounted Microsoft Excel Bundle

Discounted Microsoft Excel Bundle

OVER 23 hours of Beginner to Advance Excel Training - ONLY $124.95 Purchase the bundle and save. This bundle contains 6 Excel Courses.

MORE INFO

Multi User Version Available

An affordable way to train multiple users This course is also available in multi-user format which is ideal for corporate users, schools and universities. The multi-user training loads directly onto your own server and delivers training to multiple users over your own network. More info...

  • $250.00 Per 10 User Licence

100% Money Back Guarantee

Complete Customer Satisfaction is our goal. All Infinite Skills Training DVDs come with a 100% money back guarantee. If your not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund. View our full terms and conditions