Learn powerful tips, tricks, and shortcuts from Excel trainer and popular instructor Dennis Taylor.
Overview
Syllabus
Introduction
- Become a proficient Excel user
- Enter data or formulas in non-adjacent cells simultaneously
- Copy data or formulas down a column
- Instantly enter today's date or time
- Convert formulas to values with a simple drag
- Display all worksheet formulas instantly
- Create charts instantly with these keyboard shortcuts
- Zoom in and out quickly
- Access ribbon commands with Alt key sequences
- Expand or collapse the ribbon and full screen views
- Create split screens and frozen titles in a flash
- Restore missing labels and hide repeating labels
- Navigate between workbooks and worksheets efficiently
- Navigate within worksheets efficiently
- Open, close, save, and create new workbooks with shortcuts
- Select an entire row, column, region, or worksheet
- Select non-contiguous ranges and visible cells only
- Accelerate data entry
- Enter dates and date series efficiently
- Enter times and time series efficiently
- Use Custom Lists for rapid data entry and list-based sorting
- Accelerate copy and move tasks in cells and worksheets
- Drag and insert cells with the Shift key
- Display Paste Special options instantly
- Accelerate formatting with the right mouse button
- Create formulas rapidly
- Select all dependent or precedent cells
- Use AutoSum shortcuts
- Use Conditional Formatting to highlight formula cells only
- Perform calculations without formulas
- Re-align imported text
- Collapse/expand detail quickly with group/ungroup buttons
- Create double-spaced printouts quickly
- Use keyboard shortcuts for frequently used numeric formats
- Accentuate data with alignment tools
- Add/remove borders and strikethrough with keyboard shortcuts
- Display values in thousands or millions without formulas
- Quickly format phone and SS numbers
- Clean up spaces quickly with the TRIM function
- Split column data using Text to Columns and Flash Fill
- Ensure unique entries with data validation rules
- Control chart placement and sizing with dragging techniques
- Create and manipulate shapes with the Shift, Ctrl, and Alt keys
- Create linked dynamic and linked static images
- Become a more proficient Excel user with these short tips
- Continue learning Excel
Taught by
Michael Ninness