Data isn't information until you get it to tell you something!
Data-Crunching Secrets of Excel
View a Free 2-Minute Clip of Data-Crunching Secrets of Excel 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.
With this 75-minute video 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 session with the tools you can put to work right away to handle all your Excel data like an old pro.
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 Your 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
Executives
Office managers
Business owners
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
Melissa Esquibel is a Microsoft