Advance Excel Trainings
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 training, 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 training 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 training 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 training 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.