View a Free 2-Minute Clip of Microsoft Excel Power Tools from Melissa Esquibel:
Be honest with yourself: Do you have a love/hate relationship with Excel?
You know the power it wields, but does Excel end up costing you time and stress? Are you spending too much time fixing little mistakes, wrestling with formulas, scrolling back and forth, doing the same things over and over again – while you fall behind on your other projects?
Well, no more! Now you can uncover the tips the pros use to make Excel do the hard work – for you!
There’s a right way to do things and a long way. These Excel power tools, tips and tricks will net you hours of time and banish frustration forever.
The editors of the Administrative Professional Today newsletter have once again teamed up with Microsoft® Certified Trainer Melissa Esquibel to present this powerful training video designed to help you hone your skills – no matter which version of Excel you use.
Learn the tricks the pros use to not only create effective workbooks, but work with “inherited” workbooks to unravel their mysteries. You’ll discover:
Keystroke-saving methods for creating and copying formulas.
How to create a multi-worksheet workbook with identical worksheets and a summary page with formulas in under 5 minutes!
How to trace and track formulas work throughout the workbook without straining your eyes, your brain or your patience.
How to use one of the most powerful functions in Excel: the IF statement.
And more!
Content Summary
Workbook/Worksheet Shortcuts
Finding worksheets FAST
Color coding
Creating multiple identical worksheets
Worksheet and workbook templates
Formula Tips & Tricks
AutoFill formula shortcut
Absolute cell reference
Named ranges
IF Statements
Formula tool tip
Functions arguments dialog box
Inherited Workbook Tips
Reveal formulas
Finding named ranges
Trace formula precedents and dependents
Multiple worksheet/workbook views
Throughout the presentation, you’ll discover keyboard and mouse shortcuts that will cut your Excel time in half!
Still using Excel the same ol’ way you first learned it? Break through and discover some new Excel power tools. Start loving Excel – order Microsoft Excel Power Tools for Everyone TODAY!
Sincerely,
Alice Bumgarner
Editor, Administrative Professional Today
P.S. Your satisfaction is unconditionally guaranteed. If Microsoft Excel Power Tools for Everyone fails to meet your needs, we will refund 100% of your purchase price – no hassles, no questions asked.
About the Speaker:
Melissa Esquibel 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 Excel’s amazing benefits.
Who Should Watch:
Administrative professionals
HR professionals
Supervisors and managers
Business owners
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