Excel Quick Tips

• 1

  Add the Current Date to a Cell ✓

  Learn how to add a date or time stamp to any cell with this Excel keyboard shortcut.

• 2

  A Faster Way to Use the Fill Handle ✓

  Learn a faster way to use the fill handle in Excel.

• 3

  Two Ways to Use the Format Painter ✓

  Learn how to use the Format Painter in Excel.

• 4

  A Shortcut to AutoSum ✓

  Learn an Excel keyboard shortcut that makes the AutoSum function even faster.

• 5

  Quick Access Toolbar Shortcuts ✓

  Learn how to add shortcuts to the Quick Access Toolbar in Excel.

• 6

  How to Quickly Duplicate a Sheet ✓

  Learn a shortcut for making an exact copy of an existing worksheet.

• 7

  Jump to Any Sheet with a Shortcut ✓

  Here's a shortcut for quickly jumping to any sheet within a workbook.

• 8

  Select an Entire Row or Column ✓

  Learn these Excel shortcuts for selecting an entire row or column at one time.

• 9

  Find a Sum Without Using a Formula ✓

  Here's how to find a sum without using a formula.

• 10

  Why You Should Avoid Merging Cells ✓

  Use the Center Across Selection feature to easily merge cells in Excel.

• 11

  Using the Quick Analysis Tool ✓

  Learn how to browse through different visualization options with the Quick Analysis tool.

• 12

  How to Make Charts Auto Update ✓

  Learn how to use tables to keep charts up to date using this Excel feature.

• 13

  Use Transpose to Flip Data on its Side ✓

  Here's how to use the Transpose feature to rearrange your data instantly.

• 14

  Absolute References with the F4 Key ✓

  Learn how to convert a cell reference to an absolute reference with the F4 key.

• 15

  Add a New Row with a Shortcut ✓

  Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.

• 16

  Use an Entire Column as a Cell Range ✓

  Learn how to use an entire column as a cell range in Excel.

• 17

  What are Named Ranges? ✓

  Learn how to use named ranges to make your formulas easier to write and read.

• 18

  A Trick for Finding Inconsistent Data ✓

  Here's a trick for quickly finding inconsistent data in a large spreadsheet.

Excel Functions

• 19

  How to Use Excel's VLOOKUP Function ✓

  Use VLOOKUP to find specific information in your worksheet.

• 20

  Use SUMPRODUCT to Calculate Weighted Averages ✓

  Use SUMPRODUCT to calculate weighted averages.

• 21

  Use the PROPER Function to Capitalize Names in Excel ✓

  Use the PROPER function to capitalize names in your spreadsheet.

• 22

  How to Count Cells with COUNTA ✓

  Use the COUNTA function for counting cells and for determining how many cells have data in them.

• 23

  CONCATENATE: Excel's Duct Tape ✓

  Use the CONCATENATE function to combine two or more things in one cell.

More Tips

• 24

  5 Tips for Printing Excel Spreadsheets ✓

  Use these tips for printing Excel spreadsheets.

• 25

  How to Use Fractions in Excel ✓

  Learn how to work with fractions in Excel.

• 26

  How to Add Line Breaks in Excel ✓

  Learn how to add line breaks in Excel.

• 27

  Free Resources for Learning Office for Mac ✓

  Use these free resources for learning Office for Mac.

• 28

  Understanding Regional Differences in Excel ✓

  Use regional settings in Excel to use the program in any language.