Add the Current Date to a Cell ✓
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 ✓
Learn a faster way to use the fill handle in Excel.
Two Ways to Use the Format Painter ✓
Learn how to use the Format Painter in Excel.
A Shortcut to AutoSum ✓
Learn an Excel keyboard shortcut that makes the AutoSum function even faster.
Quick Access Toolbar Shortcuts ✓
Learn how to add shortcuts to the Quick Access Toolbar in Excel.
How to Quickly Duplicate a Sheet ✓
Learn a shortcut for making an exact copy of an existing worksheet.
Jump to Any Sheet with a Shortcut ✓
Here's a shortcut for quickly jumping to any sheet within a workbook.
Select an Entire Row or Column ✓
Learn these Excel shortcuts for selecting an entire row or column at one time.
Find a Sum Without Using a Formula ✓
Here's how to find a sum without using a formula.
Why You Should Avoid Merging Cells ✓
Use the Center Across Selection feature to easily merge cells in Excel.
Using the Quick Analysis Tool ✓
Learn how to browse through different visualization options with the Quick Analysis tool.
How to Make Charts Auto Update ✓
Learn how to use tables to keep charts up to date using this Excel feature.
Use Transpose to Flip Data on its Side ✓
Here's how to use the Transpose feature to rearrange your data instantly.
Absolute References with the F4 Key ✓
Learn how to convert a cell reference to an absolute reference with the F4 key.
Add a New Row with a Shortcut ✓
Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
Use an Entire Column as a Cell Range ✓
Learn how to use an entire column as a cell range in Excel.
What are Named Ranges? ✓
Learn how to use named ranges to make your formulas easier to write and read.
A Trick for Finding Inconsistent Data ✓
Here's a trick for quickly finding inconsistent data in a large spreadsheet.
How to Use Excel's VLOOKUP Function ✓
Use VLOOKUP to find specific information in your worksheet.
Use SUMPRODUCT to Calculate Weighted Averages ✓
Use SUMPRODUCT to calculate weighted averages.
Use the PROPER Function to Capitalize Names in Excel ✓
Use the PROPER function to capitalize names in your spreadsheet.
How to Count Cells with COUNTA ✓
Use the COUNTA function for counting cells and for determining how many cells have data in them.
CONCATENATE: Excel's Duct Tape ✓
Use the CONCATENATE function to combine two or more things in one cell.
5 Tips for Printing Excel Spreadsheets ✓
Use these tips for printing Excel spreadsheets.
How to Use Fractions in Excel ✓
Learn how to work with fractions in Excel.
How to Add Line Breaks in Excel ✓
Learn how to add line breaks in Excel.
Free Resources for Learning Office for Mac ✓
Use these free resources for learning Office for Mac.
Understanding Regional Differences in Excel ✓
Use regional settings in Excel to use the program in any language.