Excel: Tips and Tricks (2023)

Contents

• Introduction Introduction

  • Become a proficient Excel user

    27s
• 1. Seven Super Shortcuts 1. Seven Super Shortcuts

  • Enter data or formulas in non-adjacent cells simultaneously

    2m 50s
  • (Locked)
    Copy data or formulas down a column

    3m 19s
  • (Locked)
    Instantly enter today's date or time

    3m 33s
  • (Locked)
    Convert formulas to values with a simple drag

    3m 50s
  • (Locked)
    Display all worksheet formulas instantly

    3m 5s
  • (Locked)
    Create charts instantly with these keyboard shortcuts

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

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

  • Access ribbon commands with Alt key sequences

    4m 12s
  • (Locked)
    Expand or collapse the ribbon and full screen views

    2m 23s
• 3. Display Shortcuts 3. Display Shortcuts

  • Create split screens and frozen titles in a flash

    4m 27s
  • (Locked)
    Restore missing labels and hide repeating labels

    3m 58s
• 4. Navigation and Selection Shortcuts 4. Navigation and Selection Shortcuts

  • Navigate between workbooks and worksheets efficiently

    4m 36s
  • (Locked)
    Navigate within worksheets efficiently

    3m 46s
  • (Locked)
    Open, close, save, and create new workbooks with shortcuts

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

    2m 13s
  • (Locked)
    Select non-contiguous ranges and visible cells only

    3m 20s
• 5. Data Entry and Editing Shortcuts 5. Data Entry and Editing Shortcuts

  • (Locked)
    Accelerate data entry

    4m
  • (Locked)
    Enter dates and date series efficiently

    3m 23s
  • (Locked)
    Enter times and time series efficiently

    4m 33s
  • (Locked)
    Use Custom Lists for rapid data entry and list-based sorting

    4m 15s
• 6. Drag-and-Drop Techniques 6. Drag-and-Drop Techniques

  • (Locked)
    Accelerate copy and move tasks in cells and worksheets

    2m 36s
  • (Locked)
    Drag and insert cells with the Shift key

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

    2m 29s
  • (Locked)
    Accelerate formatting with the right mouse button

    2m 31s
• 7. Formula Shortcuts 7. Formula Shortcuts

  • (Locked)
    Create formulas rapidly

    4m 18s
  • (Locked)
    Select all dependent or precedent cells

    4m 17s
  • (Locked)
    Use AutoSum shortcuts

    2m 21s
  • (Locked)
    Use Conditional Formatting to highlight formula cells only

    2m 42s
  • (Locked)
    Perform calculations without formulas

    2m 50s
• 8. Operational Shortcuts 8. Operational Shortcuts

  • (Locked)
    Re-align imported text

    2m 53s
  • (Locked)
    Collapse/expand detail quickly with group/ungroup buttons

    4m 6s
  • (Locked)
    Create double-spaced printouts quickly

    2m 55s
• 9. Formatting Shortcuts 9. Formatting Shortcuts

  • (Locked)
    Use keyboard shortcuts for frequently used numeric formats

    4m 17s
  • (Locked)
    Accentuate data with alignment tools

    2m 26s
  • (Locked)
    Add/remove borders and strikethrough with keyboard shortcuts

    3m 21s
  • (Locked)
    Display values in thousands or millions without formulas

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

    3m 33s
• 10. Data Management Techniques 10. Data Management Techniques

  • (Locked)
    Clean up spaces quickly with the TRIM function

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

    3m 43s
  • (Locked)
    Ensure unique entries with data validation rules

    3m 58s
• 11. Charting and Visual Object Tips 11. Charting and Visual Object Tips

  • (Locked)
    Control chart placement and sizing with dragging techniques

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

    3m 30s
  • (Locked)
    Create linked dynamic and linked static images

    4m
• 12. Ten Tiny Tips 12. Ten Tiny Tips

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

    4m 19s
• Conclusion Conclusion

  • (Locked)
    Continue learning Excel

    20s