In The Trenches

How To: Excel At Excel For SEM Applications, Part 3

Jun 26, 2009 at 7:08am ET by Josh Dreller

In this continuing series (part 1, part 2), I've shared some tips and tricks specifically for the search marketing professional using Microsoft Excel. The feedback has been great (thank you!), so I'm going to expand these posts to not just include tasks associated with SEM, but into a mini-Excel training course for search marketers using the software. By the end of this series of posts, I hope that it will become a reference point providing a good overview of efficiencies, tips/tricks, shortcuts, etc. for any search marketer in the trenches. I won't be covering everything you can do in Ex [...]

Filed in: In The Trenches

How To: Excel At Excel For SEM Applications, Part 2

Jun 12, 2009 at 7:00am ET by Josh Dreller

In part 1 of this series on Excel for search engine marketers, I started off by applauding the tool and pointing out how important it is to our industry. This week, before I get into the tips and tricks, I'd like to talk a little about training. Excel, like any sophisticated tool, can be dangerous in the hands of an inexperienced user. As proficient as I am today, I remember how intimidating it can be to the novice or even advanced user. In this industry, we often have the more junior level members pulling reports and scrubbing data. As they have the least amount of Excel training, their [...]

Filed in: How To: PPC, In The Trenches

How To: Excel at Excel for SEM Applications, Part 1

May 29, 2009 at 12:39pm ET by Josh Dreller

Ever since Microsoft Excel beat Lotus 1-2-3's butt to become the world's preferred spreadsheet solution, it has never looked back. It's hard for any search marketer to think of a world without Excel. I tell rookies new to the industry to move themselves a tiny bed into cell A1 because they're going to be practically living in Excel for the rest of their careers. Seriously though, search marketers who can master the ins and outs of this "simple on the outside, sophisticated on the inside" tool, will certainly have a leg up on their peers. I would hope that most of you have been exposed to [...]

Filed in: How To: PPC, In The Trenches

Become a Premium Member and see all articles in our In The Trenches archives!

Premium Members get unrestricted access to all archives - and more! Premium membership details below...

Become A Search Engine Land Premium Member

Gain insider access to the industry's leading online publication, covering the latest search engine news, in-depth features and analysis of products, technologies and search trends.

Subscribe as a premium member today and you'll get:

Unlimited access to news & How To articles.
Exclusive videos & webinars with search experts.
Expanded community profile & posting privileges.
Discounts to SMX Conferences & Events.
30 Day money back guarantee.

FREE DAILY SEARCH NEWS RECAP!

Stay on top of all the search news with our daily summary, the SearchCap newsletter. View a sample ›

STAY CURRENT THROUGHOUT THE DAY

The Search Engine Land feed keeps you informed as news happens. SEE ALL FEEDS »

SEARCH ENGINE LAND SPONSORS

Advertise With Us »

UPCOMING SEARCH ENGINE LAND CONFERENCES

Search Engine Land produces SMX, the Search Marketing Expo conference series. SMX events deliver the most comprehensive educational and networking experiences - whether you're just starting in search marketing or you're a seasoned expert.

SMX Web Site » | SMX Difference » | SMX News »

Join us at an upcoming SMX event:

UPCOMING SEARCH ENGINE LAND WEBCASTS

Learn more about search marketing with our free online webcasts and webinars from our sister site, Search Marketing Now. Upcoming online events include:

How Large Offline Marketers Drive Superior Search Marketing Results - July 21, 2009
Trademarks, Brand Terms and PPC Advertising: Updates You Must Know - July 22, 2009
Attribution Management Buyers Guide - July 28, 2009

See more webcast topics »

TRACK US SOCIALLY

BRAGROLL

See more awards and reviews »