Excel® Power Tips and Shortcuts

• Overview
• Credits

Learn simple Excel® tricks and shortcuts that will make you instantly more proficient.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.

Authors

Agenda

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