Using the exercise files

Contents

• Introduction Introduction

  • Welcome

    33s
  • Using the exercise files

    17s
• 1. Top 10 Shortcuts 1. Top 10 Shortcuts

  • Enter data or formulas in nonadjacent cells simultaneously

    3m 17s
  • Copy data or formulas down a column instantly

    2m 49s
  • Instantly enter today's date or time

    3m 20s
  • Convert formulas to values with a simple drag

    5m 4s
  • Adjust all or selected column widths or row heights in a flash

    4m 43s
  • Display all worksheet formulas instantly

    3m 30s
  • (Locked)
    Create charts instantly with either of these keystroke shortcuts

    2m 54s
  • (Locked)
    Display Print Preview instantly

    2m 25s
  • (Locked)
    Undo, redo, and repeat with keystrokes

    3m 53s
  • (Locked)
    Zoom in and out quickly

    3m 23s
• 2. Ribbon and Quick Access Toolbar Tips 2. Ribbon and Quick Access Toolbar Tips

  • (Locked)
    Expand/collapse ribbon and fullscreen views

    2m 43s
  • (Locked)
    Access ribbon commands with Alt key sequences

    3m 36s
  • (Locked)
    Adjust the Quick Access Toolbar

    7m 31s
• 3. Display Shortcuts 3. Display Shortcuts

  • (Locked)
    Create split screens and frozen titles in a flash

    8m 34s
  • (Locked)
    Restore missing labels and hide repeating labels

    8m 46s
  • (Locked)
    Customize the display of status bar totals

    5m 22s
• 4. Navigation Shortcuts 4. Navigation Shortcuts

  • (Locked)
    Navigate between workbooks efficiently

    3m 37s
  • (Locked)
    Navigate between worksheets efficiently

    5m 15s
  • (Locked)
    Navigate within worksheets

    7m 10s
  • (Locked)
    Open, close, save, and create new workbooks with keystrokes

    5m 50s
• 5. Selection Shortcuts 5. Selection Shortcuts

  • (Locked)
    Select entire row, column, region, or worksheet

    6m 58s
  • (Locked)
    Select noncontiguous ranges and visible cells only

    8m 26s
• 6. Data Entry and Editing Shortcuts 6. Data Entry and Editing Shortcuts

  • (Locked)
    Accelerate data entry

    9m 54s
  • (Locked)
    Enter dates and date series efficiently

    7m 40s
  • (Locked)
    Enter times and time series efficiently

    3m 15s
  • (Locked)
    Use custom lists for rapid data entry and list-based sorting

    9m 18s
  • (Locked)
    Enhance editing tools

    3m 40s
• 7. Drag and Drop Techniques 7. Drag and Drop Techniques

  • (Locked)
    Accelerate copy and move tasks

    5m 46s
  • (Locked)
    Accelerate worksheet copying and moving

    4m 12s
  • (Locked)
    Drag and insert cells with the Shift key

    2m 49s
  • (Locked)
    Display Paste Special options instantly

    5m 46s
  • (Locked)
    Accelerate Copy/Move/Paste actions with the right mouse button

    6m 56s
• 8. Formula Shortcuts 8. Formula Shortcuts

  • (Locked)
    Create formulas rapidly

    6m 26s
  • (Locked)
    Select all cells that depend on the active cell

    5m 9s
  • (Locked)
    Select all cells that can affect the active cell

    4m 9s
  • (Locked)
    Use AutoSum shortcuts

    3m 53s
  • (Locked)
    Use rounding shortcuts

    5m 30s
  • (Locked)
    Generate random numbers

    5m 3s
  • (Locked)
    Count the number of unique entries

    5m 14s
  • (Locked)
    Perform calculations without formulas

    3m 2s
• 9. Operational Shortcuts 9. Operational Shortcuts

  • (Locked)
    Insert, delete, hide, and unhide columns and rows rapidly

    5m
  • (Locked)
    Re-align imported text

    5m 44s
  • (Locked)
    Select and manipulate blank cells

    6m 30s
  • (Locked)
    Collapse and expand detail quickly with outlining shortcuts

    9m 58s
  • (Locked)
    Create double-spaced or triple-spaced printouts quickly

    2m 53s
• 10. Formatting Shortcuts 10. Formatting Shortcuts

  • (Locked)
    Use keystroke shortcuts for frequently needed numeric formats

    6m 29s
  • (Locked)
    Accentuate data with alignment tools

    6m 2s
  • (Locked)
    Add a color background to every 5th row in a range

    5m 40s
  • (Locked)
    Use conditional formatting based on comparison criteria

    5m 13s
  • (Locked)
    Use conditional formatting to highlight formula cells only

    2m 54s
  • (Locked)
    Create custom formats: Dot leaders and more

    6m 1s
  • (Locked)
    Use special formats for times over 24 hours

    4m 9s
  • (Locked)
    Add/remove strikethrough and borders with keystroke shortcuts

    3m 34s
  • (Locked)
    Quickly format phone and SS numbers

    3m 54s
• 11. Data Management Techniques 11. Data Management Techniques

  • (Locked)
    Sort data with single buttons

    4m 34s
  • (Locked)
    Clean up spaces quickly with the TRIM function

    4m 37s
  • (Locked)
    Identify and eliminate duplicates

    6m 21s
  • (Locked)
    Split column data using Text to Columns and Flash Fill

    5m 26s
  • (Locked)
    Join data with the TEXTJOIN function and Flash Fill

    4m 46s
  • (Locked)
    Ensure unique entries with data validation rules

    5m 19s
  • (Locked)
    Force typed dates to be weekdays only with data validation rules

    4m 31s
  • (Locked)
    Display unique items from large lists

    5m 17s
• 12. Charting and Visual Object Tips 12. Charting and Visual Object Tips

  • (Locked)
    Manipulate chart placement with dragging techniques

    3m 44s
  • (Locked)
    Create chart titles from cell content

    2m 48s
  • (Locked)
    Create and manipulate shapes with the Shift, Ctrl, and Alt keys

    7m 20s
  • (Locked)
    Create linked dynamic and linked static images

    7m 42s
• 13. Ten Tiny Tips 13. Ten Tiny Tips

  • (Locked)
    Become a more proficient Excel user with these short tips

    7m 22s
• Conclusion Conclusion

  • (Locked)
    Goodbye

    33s