The Marketer's Master Guide to Excel

Little seven years old girl with a handmade superhero disguise.

There are three types of people in the world: those who hate Excel, those who really hate Excel and those who realize you can run the world if you're an Excel master.

I consider myself to be in the last category. However, sometimes Excel is my worst enemy. As a digital marketer, I've had plenty of those, "Why me?!?" moments following hours of work climaxing in one epic crash. Thousands of ads replaced with a single, gut-wrenching error message. Somehow, Autosave is always conveniently disabled.

Most of the time though, Excel is my best friend. My BFF, even. Writing a macro that saves hours or days of work can be one of the most satisfying feelings in the entire world. Plus, it frees up your time to focus on the important stuff, like strategy and what you're going to have for dinner later that night.

We may have a tumultuous relationship, but Excel really is a marketer's best friend. It's a powerful tool that can help make your life easier and free up valuable mindshare for more strategic thinking. Get to know the Excel I've come to love by checking out a few tips and tricks that have made our teams here at Nebo efficient marketing machines.

Here's a sneak peek of what you'll find in our downloadable Excel Guide:

  • Pivot Tables
  • vLookup and Using $
  • Forecasting
  • Conditional Formatting
  • Paste Special
  • Templates
  • Hiding Cells
  • Text to Columns
  • Formulas
    • =LEN()
    • =IFERROR()
    • =TRIM()
    • =CONCATENATE() and "&"
    • =IF()
    • Nesting Formulas
    • =COUNTIF()

 

Written by Jenn Vickery on July 22, 2016

Comments

Add A Comment
Jvick 1 lpx2nyr
Written by
Jenn Vickery
Senior Vice President, Marketing