Excel 2010: Power Shortcuts

Introduction
Welcome
Using the exercise files

1. Top Ten Shortcuts
Entering data or formulas in non-adjacent cells simultaneously
Converting formulas to values with a simple drag
Copying data or formulas down a column instantly
Adjusting all or selected column widths or row heights in a flash
Instantly displaying all worksheet formulas
Two quick shortcuts for creating charts
Print Preview
Instant date or time entry
Undo/Redo/Repeat
Zooming in and out quickly

2. Ribbon and Quick Access Toolbar Tips
Expanding and collapsing the Ribbon and Full Screen view
Keyboard command access
Quick Access toolbar display tips

3. Display Shortcuts
Split screens and frozen titles in a flash
Repeating title creation and suppression
Customizing your display of Status Bar totals

4. Navigation Shortcuts
Navigation shortcuts
Tips for navigating between workbooks
Navigating within worksheets

5. Selection Shortcuts
Selecting an entire row, column, or worksheet
Selecting noncontiguous ranges and visible cells only
Selecting the current region and moving around region corners

6. Data Entry and Editing Shortcuts
Accelerating data entry
Auto-Fill techniques for entering dates
Auto-Fill techniques for entering times
Custom lists for rapid entry
Cell editing tips

7. Drag-and-Drop Techniques
Copy/Move acceleration tips
Worksheet Copy/Move shortcuts
Dragging and inserting variations
Instantly displaying Paste Special options

8. Formula Shortcuts
Rapid formula creation
Selecting all cells that depend on the active cell
Selecting all cells that can affect the active cell
AutoSum shortcuts
Rounding shortcuts
Generating random numbers
Counting unique entries
Performing calculations without formulas

9. Operational Shortcuts
Controlling rows and columns
Realigning imported text
Handling blank cells
Collapsing and expanding detail

10. Formatting Shortcuts
Formatting numbers
Aligning data
Adding background color for readability
Formatting data conditionally
Creating custom formats
Formatting periods over 24 hours
Applying strikethroughs and borders

11. Database Techniques
Sorting shortcuts
Cleaning up spaces
Identifying duplicates
Splitting columns
Ensuring unique entries
Forcing dates to be weekdays only
Displaying unique items from large lists

12. Charting and Visual Object Tips
Placing and adjusting charts
Creating chart titles from cell content
Creating and manipulating shapes
Linking and unlinking pictures
Conclusion
Goodbye