SkillPath Seminars
Call us: 1-800-873-7545

Microsoft Excel 2010 Bundle

by Philip Wiest
DVD-ROM; 3 DVD-ROM

PRICE: $199.95

Excel® training that focuses on three hot areas all Excel 2010 users wish they knew more about is here!

Microsoft® Excel® 2010 Shortcuts
Microsoft® Excel® 2010 PivotTables®
Microsoft® Excel® 2010 Charts & Graphs

These DVD-ROMs are not only loaded with "how-to-do-it" specifics, they save you time with their menu-based modules that allow you to pick and choose exactly what you want to learn.

Accompanying Excel worksheets allow you to work on the exact same data that the trainer uses.

Microsoft® Excel 2010 Shortcuts+

Taking your Excel experience to the next level is as easy as counting to 10. From breaking the boredom of data entry to the magic of simple macros, you’ll see how easy it is to get double the results in half the time. With the 10 easy-to-understand lessons taught in this amazing DVD video, you’ll realize you don’t have to speak "computerese" or be an Excel power user to create and use shortcuts that take the repetitive work out of all your routine tasks. You’ll save time, have fewer errors—and start putting the full power of Excel to work for you.

Course Topics:

  1. The Ultimate Top 10 Excel Shortcut Countdown
  2. Jaw-dropping Data Entry Shortcuts
  3. Sleight-of-Hand Navigation and Secrecy Shortcuts
  4. The World’s Fastest Formula Writing Shortcuts
  5. Stunningly Quick Excel Selection Shortcuts
  6. Instant Formatting Shortcuts and Custom Styles
  7. Constructing Mega-tables as Shortcuts
  8. The Magic of Designing Custom Templates as Shortcuts
  9. How to Develop Macros for Shortcuts
  10. The Next Step—Building Custom Functions and Best Practices

Bonus: 200+ Excel shortcuts in PDF format

Contains 10 Shockwave® Flash® files with accompanying Excel worksheets on one DVD-ROM. Play with Windows Media® Player, Media Player Classic, Flash or Microsoft® Internet Explorer®.

Microsoft® Excel 2010 PivotTables®+

Have you discovered the power of PivotTables? The "too complicated" excuse is gone—Excel 2010 makes creating and using PivotTables easier and faster than ever before. In this comprehensive 10-part program, master trainer Philip Wiest shows you what’s new—and what tools can help you the most. From layout and organization to analyzing data and creating reports, this tutorial breaks down this amazing Excel feature and teaches you all you need to know. With the help of this video DVD, Microsoft Excel PivotTables will soon become your most valuable tool for sorting through and summarizing data.

Course Topics:

  1. The Secret World of PivotTables
  2. Almost Everything You Need to Know
  3. Grouping Your Data in a PivotTable Report
  4. How to Customize PivotTable Formats
  5. Formulas and Functions
  6. How to Build PivotTable Reports From Remote Data Sources
  7. How to Manage All the PivotTable Report Options
  8. How to Convert PivotTable Reports Into Charts
  9. Troubleshooting Secrets From the Real World
  10. Best Practices

Contains 10 Shockwave® Flash® files with accompanying Excel worksheets on one DVD-ROM. Play with Windows Media® Player, Media Player Classic, Flash or Microsoft® Internet Explorer®.

Microsoft® Excel 2010 Charts & Graphs+

Excel’s number-crunching power is unmatched. But to make data really work for you, it often takes some pizzazz to make a splash. Excel 2010 can do that too, and we’ll show you how! From the essentials of chart styles and formats … to dazzling 3-D graphics and powerful Trendlines … to using Sparklines, Excel’s amazing new mini-chart feature—this comprehensive video training tool teaches you everything you need to know to turn your numbers into eye-popping, informative charts and graphs. Your data deserves to be noticed, and using these techniques will turn heads and get the results you’re looking for!

Course Topics:

  1. Getting Started
  2. Fundamentals
  3. Data Series
  4. Managing Labels
  5. Combination Charts
  6. Trendlines
  7. Pie Charts
  8. Line, XY Scatter and Bubble Charts
  9. Advanced Techniques
  10. Best Practices

Contains 10 Shockwave® Flash® files with accompanying Excel worksheets on one DVD-ROM. Play with Windows Media® Player, Media Player Classic, Flash or Microsoft® Internet Explorer®.