Excel Tips

Excel Quick Tips

• 1

  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.
• 2

  A Faster Way to Use the Fill Handle arrow_forward_ios ✓ Learn a faster way to use the fill handle in Excel.
• 3

  Two Ways to Use the Format Painter arrow_forward_ios ✓ Learn how to use the Format Painter in Excel.
• 4

  A Shortcut to AutoSum arrow_forward_ios ✓ Learn an Excel keyboard shortcut that makes the AutoSum function even faster.
• 5

  Quick Access Toolbar Shortcuts arrow_forward_ios ✓ Learn how to add shortcuts to the Quick Access Toolbar in Excel.
• 6

  How to Quickly Duplicate a Sheet arrow_forward_ios ✓ Learn a shortcut for making an exact copy of an existing worksheet.
• 7

  Jump to Any Sheet with a Shortcut arrow_forward_ios ✓ Here's a shortcut for quickly jumping to any sheet within a workbook.
• 8

  Select an Entire Row or Column arrow_forward_ios ✓ Learn these Excel shortcuts for selecting an entire row or column at one time.
• 9

  Find a Sum Without Using a Formula arrow_forward_ios ✓ Here's how to find a sum without using a formula.
• 10

  Why You Should Avoid Merging Cells arrow_forward_ios ✓ Use the Center Across Selection feature to easily merge cells in Excel.
• 11

  Using the Quick Analysis Tool arrow_forward_ios ✓ Learn how to browse through different visualization options with the Quick Analysis tool.
• 12

  How to Make Charts Auto Update arrow_forward_ios ✓ Learn how to use tables to keep charts up to date using this Excel feature.
• 13

  Use Transpose to Flip Data on its Side arrow_forward_ios ✓ Here's how to use the Transpose feature to rearrange your data instantly.
• 14

  Absolute References with the F4 Key arrow_forward_ios ✓ Learn how to convert a cell reference to an absolute reference with the F4 key.
• 15

  Add a New Row with a Shortcut arrow_forward_ios ✓ Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
• 16

  Use an Entire Column as a Cell Range arrow_forward_ios ✓ Learn how to use an entire column as a cell range in Excel.
• 17

  What are Named Ranges? arrow_forward_ios ✓ Learn how to use named ranges to make your formulas easier to write and read.
• 18

  A Trick for Finding Inconsistent Data arrow_forward_ios ✓ Here's a trick for quickly finding inconsistent data in a large spreadsheet.

Excel Functions

• 19

  How to Use Excel's VLOOKUP Function arrow_forward_ios ✓ Use VLOOKUP to find specific information in your worksheet.
• 20

  Use SUMPRODUCT to Calculate Weighted Averages arrow_forward_ios ✓ Use SUMPRODUCT to calculate weighted averages.
• 21

  Use the PROPER Function to Capitalize Names in Excel arrow_forward_ios ✓ Use the PROPER function to capitalize names in your spreadsheet.
• 22

  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.
• 23

  CONCATENATE: Excel's Duct Tape arrow_forward_ios ✓ Use the CONCATENATE function to combine two or more things in one cell.

More Tips

• 24

  5 Tips for Printing Excel Spreadsheets arrow_forward_ios ✓ Use these tips for printing Excel spreadsheets.
• 25

  How to Use Fractions in Excel arrow_forward_ios ✓ Learn how to work with fractions in Excel.
• 26

  How to Add Line Breaks in Excel arrow_forward_ios ✓ Learn how to add line breaks in Excel.
• 27

  Free Resources for Learning Office for Mac arrow_forward_ios ✓ Use these free resources for learning Office for Mac.
• 28

  Understanding Regional Differences in Excel arrow_forward_ios ✓ Use regional settings in Excel to use the program in any language.