Add the Current Date to a Cell print ✓
Learn how to add a date or time stamp to any cell with this Excel keyboard shortcut.
A Faster Way to Use the Fill Handle print ✓
Learn a faster way to use the fill handle in Excel.
A Shortcut to AutoSum print ✓
Learn an Excel keyboard shortcut that makes the AutoSum function even faster.
Quick Access Toolbar Shortcuts print ✓
Learn how to add shortcuts to the Quick Access Toolbar in Excel.
How to Quickly Duplicate a Sheet print ✓
Learn a shortcut for making an exact copy of an existing worksheet.
Jump to Any Sheet with a Shortcut print ✓
Here's a shortcut for quickly jumping to any sheet within a workbook.
Select an Entire Row or Column print ✓
Learn these Excel shortcuts for selecting an entire row or column at one time.
Why You Should Avoid Merging Cells print ✓
Use the Center Across Selection feature to easily merge cells in Excel.
Using the Quick Analysis Tool print ✓
Learn how to browse through different visualization options with the Quick Analysis tool.
How to Make Charts Auto Update print ✓
Learn how to use tables to keep charts up to date using this Excel feature.
Use Transpose to Flip Data on its Side print ✓
Here's how to use the Transpose feature to rearrange your data instantly.
Absolute References with the F4 Key print ✓
Learn how to convert a cell reference to an absolute reference with the F4 key.
Add a New Row with a Shortcut print ✓
Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
Use an Entire Column as a Cell Range print ✓
Learn how to use an entire column as a cell range in Excel.
What are Named Ranges? print ✓
Learn how to use named ranges to make your formulas easier to write and read.
A Trick for Finding Inconsistent Data print ✓
Here's a trick for quickly finding inconsistent data in a large spreadsheet.
How to Use Excel's VLOOKUP Function print ✓
Use VLOOKUP to find specific information in your worksheet.
Use the PROPER Function to Capitalize Names in Excel print ✓
Use the PROPER function to capitalize names in your spreadsheet.
How to Count Cells with COUNTA print ✓
Use the COUNTA function for counting cells and for determining how many cells have data in them.
CONCATENATE: Excel's Duct Tape print ✓
Use the CONCATENATE function to combine two or more things in one cell.