# Advanced Excel Training - Online Excel Course

Product type
Level
Provider rating: starstarstarstarstar_half 8.5

Need more information? Get more details on the site of the provider.

## A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, 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 t…

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

## A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, 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 video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. 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.

• Over 136 lectures and 8.5 hours of content!
• Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.
• 136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!
• Suitable advanced Excel users. ideal for users who learn faster when shown.
• Visual training method, offering users increased retention and accelerated learning.
• Breaks even the most complex applications down into simplistic steps.

InfiniteSkills.com is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment.

There are no reviews yet.