Microsoft Outlook 2007: Beyond E-mail to E-fficiency
Data isn't information until you get it to tell you something!
Data-Crunching Secrets of Excel

 View a free 2-Minute
Data-Crunching Secrets of Excel
clip from Melissa Esquibel
:

Do you have a love/hate relationship with Microsoft® Excel®?

You know the power it wields, but it sure would make your life easier if you knew all the tricks the pros use to take it to the next level. Now you can!

The editors of the Office Technology Today newsletter have once again teamed up with master trainer Melissa Esquibel to present a video recording on advanced Excel skills. Data-Crunching Secrets of Excel is designed for those who have some experience working with data lists and tables (beyond Sort and Filter), as well as basic formulas and functions in Excel (beyond SUM, AVERAGE, COUNT).

As the data pile gets larger and larger, the answers seem to get buried deeper and deeper. Knowing the secrets of working with data in Excel can bring you actionable information quickly, consistently and in a way that stays nimble as your datasets grow.


In this 75-minute recording on advanced Excel skills presented by Microsoft® Certified Trainer Melissa Esquibel, you’ll find out...

Teaching Points
  • Performing LookUps in Formulas
  • Conditional Formulas
  • Subtotal Secrets
  • Pivot Tables
Content Summary

LookUp Functions
  • VLookUp
  • Inside an IF
  • ISNA
Conditional Formulas
  • SUMIF
  • DSUM
  • SUMIFS
Subtotals
  • Data Standards
  • Creating Subtotals
  • Banded Totals
  • A Trick with Charts
Pivot Tables
  • Creating Pivot Tables
  • Manipulating Data
  • Creating a Formula
Data isn’t information until you can get it to tell you something. You’ll leave this Data-Crunching Secrets of Excel recording with the tools you can put to work right away to handle all your Excel data like a pro.

Sincerely,

Pat DiDomenico
Editorial Director, Office Technology Today

P.S. Your satisfaction is unconditionally guaranteed. If Data-Crunching Secrets of Excel fails to meet your needs, we will refund 100% of your purchase price—no hassles, no questions asked.

About the Speaker:

Melissa Esquibel is a Microsoft® Certified Trainer. She combines her 25+ years of experience in information technology with a background in training, technical writing and business risk analysis. Her goal is to help you understand the amazing workflow benefits of Microsoft® Excel®.
Who Should Watch:
  • Administrative professionals
  • HR professionals
  • Supervisors and managers
  • Office managers
  • Business owners
  • Executives
  • Payroll professionals
  • Anyone who wants to take Excel to the next level
This recording is sponsored by:
Business Management Daily
7600A Leesburg Pike, West Building, Suite 300 • Falls Church, VA 22043-2004
(800) 543-2055 • Customer@BusinessManagementDaily.com