Excel: Tips and Tricks 

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