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