Microsoft Excel Training Series (Power Packed 15 DVDs) (2003/2007/2010) (PKGIMEA20E)

Reach Your Goal Faster with Excel Training Package

Whether you are new to the wonderful world of Excel or a seasoned professional, we are here to help you master the nuts and bolts of Excel with ease. Our simple and easy to understand tutorials cover a plethora of topics to transform you from a novice to an Excel pro within few hours.

Get your dose of career-enhancing information on Excel presented by experts, in the form of conference to help you ace Excel quickly and conveniently.

Pack 1: Microsoft Excel: Charts & Graphs (Power Packed 4 DVDs)

Save tons of times by creating fabulous charts in a clear and simple ways. Add pizzaz to your Excel charts and graphs with charting secrets, exclusively revealed by our industry experts in this informative DVD pack.

Take a look at the topics covered:

• Create a chart in a jiffy with a single keystroke shortcut
• Boost the data impact by adding pictures to your charts and tables
• Clear out the clutter—eliminate extraneous chart elements
• Save a custom chart type so Excel gives you exactly the chart you want every time

Pack 2: Microsoft Excel: Pivot Table (Power Packed 4 DVDs)

Unearth the enormous possibilities of Excel Pivot table! Like how with a simple drag and drop action one can easily analyze tons of data, create reports and extract underlying details in no time. Get some top-notch tips, tricks and techniques from our experts that will help you organize and analyze data with minimal errors.

Take a look at the topics covered:

• Know the pre-requisites for source data
• Create a PivotTable with few steps
• Manipulate the appearance of a PivotTable via drag and command techniques
• Accentuate field elements by using Slicers
• Creating ad hoc and date-based groupings within a PivotTable

Pack 3: Microsoft Excel: Shortcuts/Features (Power Packed 4 DVDs)

Make your co-workers green with envy for your proficient Excel know-how. Learn innumerable excel tips, tricks, secrets and practical shortcuts to reduce spreadsheet drudgery and double triple or even quadruple your productivity and efficiency at work.

Take a look at the topics covered:

• Leverage the Excel's built-in features to do the work for you
• Navigate easily through worksheets with keystroke and mouse shortcuts
• Time saving tips for data entry and formatting
• Quickly identify where formulas get and send information

Pack 4: Microsoft Excel: Advanced Excel Formulas & Functions (Power Packed 3 DVDs)

Turbo-charge your excel productivity with powerful professional tips on advanced excel formulas and functions offered by our excel experts. Expand your proficiency and master functions like VLOOKUP, INDEX, MATCH and a gamut of other advanced formulas and functions.

Take a look at the topics covered:

• Make us of IF, AND, OR, and CHOOSE functions
• Make use of Text functions to quickly clean up and restructure downloaded data
• Make use of function to look up data from a list in another workbook
• Make use of the special-purpose array functions and formulas