Today we have more handy Excel tricks from Bing Ads Evangelist John Gagnon.
Many website owners use Excel on a daily basis. They might keep a list of backlinks they want to track, or use it to track keyword rankings.
I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know. It’s going to be a long series — but by the time we’re finished, you’ll be able to create dashboards that excel in both form and function.
One question I get asked a lot is this: what Excel skills are most important for marketers to learn? I have whittled that interminable list down to five skills that I believe are absolutely essential for marketers to know, presented below in order of importance
One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received traffic in the past year. This can be accomplished by pulling a landing page report and using VLOOKUPs in Excel to see any of your broken pages used to receive traffic.
There comes a time in a marketer’s life when making pretty charts with a predefined dataset just doesn’t cut it. And finding the sum and average of a column of data just doesn’t satisfy you anymore. Eventually — and it’s really inevitable — you will actually have to dive deep into the data…
One thing I’ve never understood about Excel is why it doesn’t support regular expressions (which the cool kids call regex). Regex allows you to do advanced sorting and filtering.
I’m spoiled now.
Have you ever done a search to find out how to do something in Excel, just to find the search results littered with macro options?
Having covered all the basics of how to make tabular data tell a story using custom cell formatting and conditional formatting for both static tables and pivot tables, we’re now going to jump into the really fun stuff: charting data out in Excel. I’m not going to cover the basics of creating…