Become a proficient Excel user - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Become a proficient Excel user

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

  • Enter data or formulas in nonadjacent cells simultaneously

    3m 19s
  • (Locked)
    Copy data or formulas down a column

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

    4m 53s
  • (Locked)
    Convert formulas to values with a simple drag

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

    4m 1s
  • (Locked)
    Create charts instantly with these keystroke shortcuts

    2m 28s
  • (Locked)
    Zoom in and out quickly

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

  • Access ribbon commands with Alt key sequences

    3m 49s
  • (Locked)
    Expand or collapse ribbon and full‑screen views

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

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

    7m 19s
  • (Locked)
    Restore missing labels or hide repeating labels

    6m 5s
• 4. Navigation and Selection Shortcuts 4. Navigation and Selection Shortcuts

  • Navigate between workbooks and worksheets efficiently

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

    5m 20s
  • (Locked)
    Use keystrokes to open, close, save, and create new workbooks

    2m 15s
  • (Locked)
    Select an entire row, column, range, or worksheet

    2m 37s
  • (Locked)
    Select noncontiguous ranges and visible cells only

    5m 14s
• 5. Data Entry and Editing Shortcuts 5. Data Entry and Editing Shortcuts

  • (Locked)
    Accelerate data entry

    5m 47s
  • (Locked)
    Enter dates and date series efficiently

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

    5m 24s
  • Use custom lists for rapid data entry and list-based sorting

    7m 33s
• 6. Drag-and-Drop Techniques 6. Drag-and-Drop Techniques

  • (Locked)
    Accelerate copy and move tasks

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

    2m 35s
  • Display Paste Special options instantly

    3m 24s
  • (Locked)
    Accelerate formatting with the right mouse button

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

  • (Locked)
    Create formulas rapidly

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

    3m 18s
  • (Locked)
    Use AutoSum shortcuts

    3m 29s
  • (Locked)
    Highlight formula cells only with conditional formatting

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

    3m 25s
• 8. Operational Shortcuts 8. Operational Shortcuts

  • (Locked)
    Realign imported text

    3m 50s
  • (Locked)
    Collapse and expand detail using group and ungroup buttons

    4m 32s
  • (Locked)
    Create double-spaced or triple-spaced printouts quickly

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

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

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

    3m
  • (Locked)
    Add or remove borders and strikethrough with shortcuts

    4m 7s
  • (Locked)
    Display values in thousands or millions without formulas

    4m 5s
  • (Locked)
    Quickly format phone and Social Security numbers

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

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

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

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

    4m 4s
  • (Locked)
    Fast sorting and filtering with the right mouse button

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

  • (Locked)
    Drag to control chart placement and sizing

    5m 43s
  • (Locked)
    Create and manipulate shapes with Shift, Ctrl, and Alt

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

    4m 8s
  • (Locked)
    Quickly create full or partial screen capture images

    3m 5s
• 12. Ten Tiny Tips 12. Ten Tiny Tips

  • (Locked)
    Continue learning Excel

    5m 1s