Pages

Saturday, January 4, 2014

PPC Excel Tips For Every Level: Part 2, Huge Time Savers For Beginners (And Beyond)

Excel is that must-have tool for managing, analyzing and reporting on paid search campaigns that is impossible to know too well. Many of us are self-taught — picking up tips and tricks here and there — which makes it even harder to know what shortcuts and secret powers we’re missing out on.



Beginner Tip: Don’t under estimate the time-savings to be gained from Keyboard Shortcuts.
I hesitate to even qualify these as beginner tips because it’s easy to have worked with Excel for years and not know every shortcut.  Rule of thumb: don’t waste time using your mouse if you don’t have to.  Make handy keyboard short cuts a natural part of your work process, and you’ll be amazed how much extra time you’ll have on your hands for actual analysis.

1. Automatically SUM() with ALT + =
John says he’s used the =Sum() formula for years, but recently discovered this function.  Automatically SUM() an entire column or row by clicking in the first empty cell in the column. Then press the ALT button and the = (equals) key to sum up the numbers in the above cells.

Excel Tip Automatically Sum With Keyboard Shortcut 

2. Copy Formulas with a Double-Click

While not technically a keyboard shortcut, this trick is a huge relief for anyone working with repeating formulas, such as a conversion rate or click-through rate calculations. After entering your formula hover the bottom right corner of the cell with your mouse until a little plus sign appears. Then just double click. The formula will copy down into the cells of that column to calculate the data in the rest of the rows in the spreadsheet.

Excel tips for PPC Double Click To Copy Down Formulas

3. Currency And Percentage Formatting Shortcuts
Keyboard shortcuts are only handy if you can remember them. John points out that there is actually logic behind when to use CTRL and SHIFT in keyboard shortcuts that will help you remember when to use them.
To format a number as a currency without having to use your mouse, the keyboard shortcut is CRTL + SHIFT + 4. Why? Well, Shift + 4 is how you type a dollar sign ($). Adding CTRL will then format the cell (or cells) as currency. The same works for formatting numbers as percent with CTRL + SHIFT + 5.

Excel PPC Tips Number Formatting Keyboard Shortcuts
Excel for PPC Keyboard Shortcuts

No comments:

Post a Comment

Like Us on Facebook