Excel 2010: Tips, Tricks, and 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