Learn powerful tips, tricks, and shortcuts that can help you take your Excel game to the next level.
Overview
Syllabus
Introduction
- Save time in Excel
- Enter data or formulas in nonadjacent 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
- Create charts with these keystroke shortcuts
- Zoom in and out quickly
- Access ribbon commands with Alt key sequences
- Expand and collapse the ribbon and full-screen views
- Create split screens and frozen titles in a flash
- Restore missing labels and hide repeating labels
- Customize the display of status bar totals
- Navigate between workbooks and worksheets efficiently
- Navigate within worksheets efficiently
- Open, close, save, and create new workbooks with keystrokes
- Select an entire row, column, region, or worksheet
- Select noncontiguous ranges and visible cells only
- Accelerate data entry
- Enter dates and date series efficiently
- Enter times and time series efficiently
- Use custom lists for data entry and list-based sorting
- Enhance editing tools
- Accelerate copy and move tasks within cells and worksheets
- Drag and insert cells with the Shift key
- Display the Paste Special options
- Accelerate copy, move, and paste actions with the right mouse button
- Create formulas rapidly
- Select all dependent or precedent cells
- Use AutoSum shortcuts
- Count the number of unique entries
- Use conditional formatting to highlight formula cells
- Perform calculations without formulas
- Insert, delete, hide, and unhide columns and rows
- Realign imported text
- Select and manipulate blank cells
- Collapse and expand detail with group and ungroup buttons
- Create double-spaced or triple-spaced printouts
- Use keystroke shortcuts for frequently needed numeric formats
- Accentuate data with alignment tools
- Add a color background to every fifth row in a range
- Use conditional formatting based on comparison criteria
- Use special formats for times over 24 hours
- Add and remove strikethrough and borders with keystroke shortcuts
- Display values in thousands or millions without formulas
- Format phone and social security numbers
- Clean up spaces with the TRIM function
- Split column data using Text to Columns and Flash Fill
- Join data with the TEXTJOIN function and Flash Fill
- Insure unique entries with data validation rules
- Display unique items from large lists
- Use new rich data types (Office Insiders)
- Manipulate chart placement and sizing with dragging techniques
- Create chart titles from cell content
- Create and manipulate shapes with the Shift, Ctrl, and Alt keys
- Create linked dynamic and linked static images
- Adjust report layouts to allow totals on top or bottom
- Revisit relevant source data with the drill down feature
- Become a more proficient Excel user with these short tips
- Next steps
Taught by
Dennis Taylor