Number of Videos: 260 Lessons – 18 Hours Duration
Ships on: DVD-ROM
User Level: Beginners
Works On: Windows 7,Vista,XP- Mac OS X
This bundle contains:
Learning Microsoft Excel 2010
Advanced Microsoft Excel 2010
In this video training bundle, you will learn first, how to use the basics of the industry standard spreadsheet program, Excel 2010, and then how to utilize the advanced features and functions in this software. Expert author Guy Vaccaro guides you through these two popular video based tutorials.
In the beginners tutorial, you will start with the basics of Excel 2010, learning the interface, and quickly move into entering data, and building a workbook. You then move on to formatting, and basic functions such as SUM, AVERAGE, and others. You will also get a chance to explore charting and templates. In the advanced tutorial, you will get in-depth with the powerful features of Excel 2010 such as using lookup tables, Pivot tables, Pivot charts, Sparklines, advanced formatting, and conditional formulas. You will even learn a little bit of programming Visual Basic for Excel. The advanced training is NOT for the beginner, and we recommend that you view the beginners training first, no matter what level you believe you are at.
By the conclusion of these two video training software tutorials, you will be an expert in creating Excel 2010 spreadsheets, building charts and presenting your important data in multiple ways. You will be capable of creating advanced formulas, and even creating macros for manipulating your data. Extensive working files are included to allow you to work on the exact same files that the author is presenting the computer based training with.