Need an Excel productivity boost? You can now learn simple tricks and many shortcuts that will make you instantly more proficient using Excel.
Most Excel users are underutilizing this software. Start using the full power of Excel, and learn cool Excel tips and tricks that will make you the go to person in your office. Master more than 100 tips to make you a power user. This topic gives you a ton of productivity pointers. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week. This topic will be presented using Excel 2010 with occasional references to Excel 2007.
With a Single Keystroke Shortcut, You Can:
• Apply Currency, Date, Time, General, Percent or Scientific Formatting
• Display or Hide All Worksheet Formulas Instantly
• Create a Chart of Current Data, Complete With Legend and Scaling
• Add a New Worksheet to the Current Workbook
• Enter the Current Date or Time
Copy Formulas or Data Into Hundreds (Even Thousands) of Cells With a Double-Click
Copy or Move Data With Simple Dragging Instead of Multistep Command Sequence
Increase or Decrease Values in a Range Without Setting up Formulas
Convert Formulas to Values in One Step, Not Six
Create Double-Spaced Printouts Without Tediously Inserting Rows in Your Data
Navigate Seamlessly Through Workbooks and Worksheets With Keystroke or Mouse Shortcuts
Build Lists of Dates, Times or Values Without Using Lengthy Formulas or Commands
Dennis Taylor with Taylor Associates
AIPB ,ASAP PACE ,CPE ,IAAP ,Additional credit may be available upon request.