• http://www.ppcblast.com/ PPC Blast

    This is such a great post. i am by far a pro in Excel and need to learn as much as possible about how to make it make my life easier. Thanks for this help!

  • Satish

    Woah! This is awesome! I tried on few of my SEO documents, and they are not rocket science at all. Was wondering if you can make one for SEO reports too! :D

  • BlackRock Advertising

    Thanks Mrs ginny. its really working for our marketing team

  • Paresh Shrimali

    Good Post..
    I suggest also more excel shortcut for increasing Excel User Speed.

    Key Description
    CTRL+PgUp Switches between worksheet tabs, from left-to-right.
    CTRL+PgDn Switches between worksheet tabs, from right-to-left.
    CTRL+SHIFT+( Unhides any hidden rows within the selection.
    CTRL+SHIFT+& Applies the outline border to the selected cells.
    CTRL+SHIFT_ Removes the outline border from the selected cells.
    CTRL+SHIFT+~ Applies the General number format.
    CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
    CTRL+SHIFT+% Applies the Percentage format with no decimal places.
    CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.
    CTRL+SHIFT+# Applies the Date format with the day, month, and year.
    CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
    CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
    CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

  • Paresh Shrimali

    Good Post..
    I suggest also more excel shortcut for increasing Excel User Speed.

    Key Description
    CTRL+PgUp Switches between worksheet tabs, from left-to-right.
    CTRL+PgDn Switches between worksheet tabs, from right-to-left.
    CTRL+SHIFT+( Unhides any hidden rows within the selection.
    CTRL+SHIFT+& Applies the outline border to the selected cells.
    CTRL+SHIFT_ Removes the outline border from the selected cells.
    CTRL+SHIFT+~ Applies the General number format.
    CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
    CTRL+SHIFT+% Applies the Percentage format with no decimal places.
    CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.
    CTRL+SHIFT+# Applies the Date format with the day, month, and year.
    CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
    CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
    CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

  • http://www.globalwebforce.com/ William Forrest

    Excel can really help a marketer save time and accommodate more tasks on his to-do list.

  • http://www.globalwebforce.com/ William Forrest

    Excel can really help a marketer save time and accommodate more tasks on his to-do list.

  • Bhushan Parikh

    Great tips and nice post Ginny Marvin…. looking forward to implement it…

  • Chase Anderson

    Another classic example of a non-english speaker writing in english in a way that says exactly the opposite of what they wanted ;). Do you mean “I am far from being a pro in Excel”?

  • Chase Anderson

    Another classic example of a non-english speaker writing in english in a way that says exactly the opposite of what they wanted ;). Do you mean “I am far from being a pro in Excel”?

  • Ian Vaisman

    This is a great article as Excel shortcuts are extremely useful for anyone working with spreadsheets within the PPC space or outside of it.

    Ginny, not to be nitpicking, but I believe in your last table under the “Format” column, the first cell should be “0.1 as $0.10″ instead of “0.1 as $1.00″ Again, great article!

  • John Gagnon

    Glad you liked the tips – they’re very simple for sure. I’ll let Ginny follow-up on the SEO specific list!

  • John Gagnon

    Glad you liked them.

  • John Gagnon

    These are great ones Paresh. Another great set are for navigation:
    CTRL + ⬆ (up)
    CTRL + ⬇ (down)
    CTRL + ⟵ (left)
    CTRL + ⟶ (right)

  • Monica Barber

    Chase – Is it necessary to be so nasty? The person compliments the writer and you blast him because it wasn’t proper English. Real nice dude.

  • Glenn Vinckx

    I love these shortcuts, I use them frequently. Thanks! Can’t wait for more Excel tips!

  • http://www.ppcblast.com/ PPC Blast

    Powerful assumptions Chase. I am an English speaker. Born and raised here in Indiana. Simply a mistake in the post. Thanks for noticing it.

  • Caleb Keiter

    Great post! Since I imagine many of us are Mac users, here are the OSX versions:

    Sum – Shift + Command + T
    Format as currency – Shift + Control + 4
    Format as percentage – Shift + Control + 5

  • Caleb Keiter

    Great post! Since I imagine many of us are Mac users, here are the OSX versions:

    Sum – Shift + Command + T
    Format as currency – Shift + Control + 4
    Format as percentage – Shift + Control + 5