Create linked dynamic and linked static images

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
  • Create charts instantly with either of these keystroke shortcuts

    2m 54s
  • Display Print Preview instantly

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

    3m 53s
  • Zoom in and out quickly

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

  • Expand/collapse ribbon and fullscreen views

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

    3m 36s
  • Adjust the Quick Access Toolbar

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

  • Create split screens and frozen titles in a flash

    8m 34s
  • Restore missing labels and hide repeating labels

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

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

  • Navigate between workbooks efficiently

    3m 37s
  • Navigate between worksheets efficiently

    5m 15s
  • Navigate within worksheets

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

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

  • Select entire row, column, region, or worksheet

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

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

  • Accelerate data entry

    9m 54s
  • Enter dates and date series efficiently

    7m 40s
  • Enter times and time series efficiently

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

    9m 18s
  • Enhance editing tools

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

  • Accelerate copy and move tasks

    5m 46s
  • Accelerate worksheet copying and moving

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

    2m 49s
  • Display Paste Special options instantly

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

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

  • Create formulas rapidly

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

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

    4m 9s
  • Use AutoSum shortcuts

    3m 53s
  • Use rounding shortcuts

    5m 30s
  • Generate random numbers

    5m 3s
  • Count the number of unique entries

    5m 14s
  • Perform calculations without formulas

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

  • Insert, delete, hide, and unhide columns and rows rapidly

    5m
  • Re-align imported text

    5m 44s
  • Select and manipulate blank cells

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

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

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

  • Use keystroke shortcuts for frequently needed numeric formats

    6m 29s
  • Accentuate data with alignment tools

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

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

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

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

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

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

    3m 34s
  • Quickly format phone and SS numbers

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

  • Sort data with single buttons

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

    4m 37s
  • Identify and eliminate duplicates

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

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

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

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

    4m 31s
  • Display unique items from large lists

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

  • Manipulate chart placement with dragging techniques

    3m 44s
  • Create chart titles from cell content

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

    7m 20s
  • Create linked dynamic and linked static images

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

  • Become a more proficient Excel user with these short tips

    7m 22s
• Conclusion Conclusion

  • Goodbye

    33s