Excerpts from my latest article at Practical eCommerce: “SEO: Using Excel for Keyword Analysis.”

Excel is without a doubt the SEO tool I use most frequently. Excel helps me organize my thoughts, decide which keywords or pages to focus on, illustrate key concepts, and even draft rudimentary content. Of course you can use these tips for far more than SEO analysis. Unfortunately, some of these features are only available in Excel 2010. For full descriptions of each item and how I use them in my daily SEO work, please click through to Practical eCommerce: “SEO: Using Excel for Keyword Analysis.”

Favorite Excel 2010 Formulas

  • VLOOKUP
  • SUMIFS
  • IF ISERROR
  • CONCATENATE

Favorite Excel 2010 Menu Items

  • Freeze Panes
  • Remove Duplicates
  • Manual Calculation

Favorite Excel 2010 Keyboard Shortcuts

  • Highlight Range: Ctrl+Shift+Arrow Key.
  • Move to End: Ctrl+Arrow Key.
  • Filter: Ctrl+Shift+L.
  • Delete: Alt+E, D.
  • Insert > Cells: Alt+I, E.
  • Paste Special > Values: Alt+E, S, V.
  • Transpose Rows and Columns: Alt+E, S, E.
  • Escape.

These are some of the commands, formulas and shortcuts I use day in and day out in Excel 2010. Sometimes it’s ugly, sometimes it’s kludgy, but it always gets the job done. What are your favorite time-saving Excel shortcuts?

Read the article in full at Practical eCommerce »

Tags: ,

Leave a Reply