Dear Colleague:

If it’s called software, why is it so hard to use?

Microsoft^® Excel^® is supposed to make your job easier. But it’s tough enough mastering the basics, much less the multitude of features you haven’t even tapped. What good are all those capabilities if you don’t know how to use them – or even about them?

There’s an easy way: Learn from an expert at both software and training – Melissa Esquibel, Microsoft^® Certified Trainer. We’ve combined two of her most popular webinars into Microsoft Excel 2007: Time-Savers for Every Skill Level, an easy-to-follow Executive Summary that will help you truly master Excel.

Imagine! No more retyping data again and again … trying to keep worksheets in order when you change or add information … wasting precious time adjusting column widths and other parameters. Instead of making you work hard, Excel will work harder for you.

When we say Time-Savers for Every Skill Level, we mean it. If you’re an Excel newbie, you’ll get up to speed fast. If you’ve worked with Excel for years, you’ll make it jump through new hoops. This report shows you:

• How to slash time with Autofill, Autocorrect and Custom Lists

• The many uses of macros – customizations you create and copy, instead of reinventing the wheel every time

• How to import data and quickly fix any formatting issues

• The power of templates: starting, modifying, saving, reusing

• How to do more and type less

You’ll be amazed at the amount of information and value packed into Microsoft Excel 2007: Time-Savers for Every Skill Level. Amazed at the power you’ll unleash in your software, too.

Some people moan and groan about Microsoft’s dominance in office software. Not us. We think Excel is a terrific product for tracking and manipulating data – if you know how to use the software.

That’s why the editors of Administrative Professional Today teamed up with guru Melissa Esquibel to offer you this print version of her training. We started with one of her most popular webinars on Excel:

Ways to Improve Speed and Accuracy

1. Shortcuts, Tips & Tricks
2. Wrangling Worksheets
3. Typing Less in Excel
4. Time-Saving Templates
5. Troubleshooting Formulas

Reason enough to get the report, yes? But instead of stopping there, we added the content from a second powerful webinar:

“Power Tools” for Managing Data

1. Drilling Down to the Data You Need
2. Whipping Text Imports Into Shape
3. Macros – Reuse/Recycle
4. Vertical Lookup Functions

Then we asked ourselves, how could we make this report even more valuable? By adding the questions asked by participants in the webinars, plus Melissa’s helpful answers. Result: an appendix that answers questions you may be wrestling with.

For a concise Executive Summary, Microsoft Excel 2007: Time-Savers for Every Skill Level packs a wallop. Soon you’ll be squeezing every ounce of productivity out of Excel.

With 25+ years of IT and training experience, Melissa Esquibel really knows her stuff – and how to make it your stuff. Here’s an example from just one topic in the training: Function and Ctrl Key Shortcuts.

• Favorite shortcuts. You already copy and paste with Ctrl + C and Ctrl + V, right? But are you using these other key combos?
  
  
  Ctrl + O                     Open File
  Ctrl + S                      Save File
  Ctrl + Z                      Undo
  Ctrl + D / Ctrl + R      Fill Down / Fill Right
  Ctrl + + / Ctrl + -        Insert / Delete Rows and Columns

• How to create a chart from data in a worksheet. Simply select or click and drag over the cells and press F11. You’ll see the Chart Tool bar appear floating. You can drag it to the right and make it easier to see what you’re doing. (See diagram.)
  
  

  
                                                             Just one of 47 figures in this info-packed report.

• How to customize Excel results to suit your needs and preferences. You can change the chart type by pressing the Chart Type icon … add data below the chart with the Data Table icon … change how the series is charted by switching from Series by Row to Series by Column … and Excel will automatically optimize the size of your chart.

Melissa even teaches you how to translate your learning into a daily habit:

If you think becoming a shortcut key user is beyond your abilities, I urge you to reconsider. Here’s a method that, over time, can help. Jot three or four shortcuts on a Post it note and place it on your monitor for a week. When you have those down pat, do another three or four. Within a month you can add up to a dozen new shortcuts to your toolbox.

It’s all about saving time, the one thing you can’t buy more of.

Microsoft Excel 2007: Time-Savers for Every Skill Level will boost your productivity every time you open Excel. Order now, and learn on your own schedule, at your own pace. You may even enjoy it.

When we asked Melissa to translate her webinars into print, we urged her to capture her “voice” – the personality that, along with her smarts, has made her such a popular trainer. Here’s a quote from the Executive Summary:

When I teach this class live, I ask this question: “How many of you have done a Vertical Lookup?” Then I make everyone raise their hands. That’s because you’ve all done one. Every time you go to your favorite fast-food restaurant and look at the menu for the item you want and then over one column for the price, you’re doing a vertical lookup.

Then Melissa digs deep to explain the what, where, which column, and what if I can’t find it aspects of Vertical Lookups in Excel. Throughout this Executive Summary she gives you detailed knowledge that separates a novice or intermediate user from a tenth-degree black belt Excel master.

In short, you get all the benefits of two webinars without the time, hassle and cost of attending them. This training runs on your schedule.

Whether you find yourself frustrated by Excel or want to take your productivity to the max – or both – get your copy of Microsoft Excel 2007: Time-Savers for Every Skill Level.

Act now, because now is the best time to start saving time.


Sincerely,



Phillip A. Ash
Publisher

P.S. What’s the cost for Microsoft Excel 2007: Time-Savers for Every Skill Level? Probably less than you spent on your last tank of gas. And you’ll get more mileage out of Excel day after day after day after …

P.P.S. How important is your time? No matter where you are on the career ladder, from entry level to CEO, you have 24 hours in a day. If you can save minutes every day, they add up to hours you can spend making more money or having more fun. Invest a little time in learning now and you’ll save precious time for years to come. Order now.