Learn
Learn
Close

They Ask, You Answer

A revolutionary approach to inbound sales, content marketing, and today’s digital consumer.

Learn MoreLearn More

Free Courses in IMPACT+

Dozens of sales, marketing, and content courses inside IMPACT+. Start learning now.

See all coursesSee all courses
Events
Events
Close
IMPACT+ Membership
IMPACT+ Membership
Close
Coaching & Implementation Services
Coaching & Implementation Services
Close

Services Overview

See how you can dramatically increase your inbound leads and sales.

Services Overview

Digital Sales and Marketing Mastery

Fast track your team’s success with IMPACT's most popular service.

Digital Sales and Marketing Mastery

Web Design

Launch a beautiful website that consistently generates leads and revenue.

Web Design

Virtual Sales Training

Equip your sales team with comprehensive training designed to help them close more deals in today's virtual-first world.

Virtual Sales Training

HubSpot Training & Implementation

Train your company to take ownership of HubSpot and get the most out of your investment.

HubSpot Training & Implementation

Case Studies

See dozens of examples of companies succeeding with Digital Sales and Marketing Mastery and They Ask, You Answer.

Case Studies
Become a Coach
Become a Coach
Close

6 Ways Marketers Can Use Excel to Make Work Easier [Free Templates]

6 Ways Marketers Can Use Excel to Make Work Easier [Free Templates] Blog Feature

September 13th, 2016 min read

I am going to level with you...I hate math.

You know those nightmares people have about public speaking? I had them about Calculus tests and Algebra. All those formulas, rules, and conditions never made sense to me. So, when I finished college, I was more than thrilled to say goodbye to my TI-83 and hello to the Adobe Creative Suite.

As I found myself moving away from design and into digital marketing, however, I realized all those formulas and theories were actually more useful than I thought. Even more to my dismay, I also discovered that those Excel documents and formulas I fought so fiercly were also quite useful in marketing.

Today, Microsoft Excel is an immensely valuable tool  for organizing and completing a number of my team's everyday marketing activities, and thankfully, some in the field who do enjoy numbers (and sharing), have kindly created free Excel templates that have been a huge life saver for me.

So much so, that I thought I'd pass them on.  Here are 6 ways I use Microsoft Excel on a regular basis and the free templates that make my life easier as a digital marketer!

1) Creating a Annual Marketing Calendar

Planning ahead for the entire year can be a daunting task - but trust me...it's worth every bit of your time and will likely save your brand money in the long run! 

Annual_Marketing_Calendar.jpg

I enjoy this template because the design includes annual and month-by-month planning, with space for goal driven data and raw marketing data all in one place.

Plus it covers multiple verticals like social media, email, blogs, content, advertising, sales, press releases, and more. 

With so much data, I definitely suggest closely monitoring and updating this document bi-weekly or monthly at the very least to help you stay on track to hit your annual goals.

[Download the Annual Marketing Calendar template from Smartsheet here]

2) Outline Your Blog Content

Since content is king as many like to say, it's imperative to plan your blog topics ahead to ensure that they are as effective as possible. Especially when you are working on a collaborative team when many team members are contributing to one blog. 

Blog_Editorial_Calendar_Excel_Template.png

A blog editorial calendar will not only keep you and your other team members organized, it will also allow you to spread out your topics and the personas who they speak to, strategize keywords ahead of time, and vary your offers and CTAs.

[Download the Blog Editorial Calendar from HubSpot here]

3) Plan Your Social Media Schedule

If you are like most marketers you are managing or at the very least are monitoring multiple social media channels. Each of which has a different audience and best practice way to post and communicated. 

Social_Media_Marketing_Calendar.jpg

It can be tough to stay on top of everthing so planning ahead is vital to the success or your campaign.

This will allow you to capitalize on theme specific posts, holidays, upcoming promotions. and seasons while freeing up your time to further interact with and grow each channel on a day to day basis.

[Download the social media marketing calendar template from Smartsheet here.]

4) Organize Your Website SEO

The list of things to review, include, and keep up-to-date with regarding on-page SEO is extensive to say the least...plus, it's often changing! As we all know though, SEO is one of the key elements to successful digital marketing and can make or break things like organic and paid search rankings.

SEO_Templates_Excel.png

With this handy dandy template, you can manage things like url, page title, headings, image alt text, CTAs, social sharing, and internal links all in one place.

Trust me...this one is a game changer when it comes to being effective!

[Download the on-page SEO Template from HubSpot here]

5) Plan Your Next AdWords Campaign

Let's face it, Google Adwords does not have the most user-friendly display when it comes to managing multiple AdWords campaigns at once. You have to click into each campaign to see all the details, and if you are like many other marketers out there you have multiple campaigns with various keywords and likely multiple ads. 

AdWords_Excel_Marketing_.png

This template will not only help keep you organized and allow you to view all your campaigns in one screen, it will also help you catch mistakes and implement best practicesfor keywords and each step of your marekting funnel.

[Download the AdWords Campaign Manager Template from HubSpot here]

6) Monthly Marketing Metrics

We all know that your marketing efforts are only effective if you are tracking and benchmarking their success.

Without data points of where you started and where you are now there is absolutely no way to measure sucess and show ROI for your clients or boss. 

Monthly_Marketing_Metrics_Excel.png

With this template you can measure traffic, leads and customers from each channel - month over month, year over year and watch as your success grows!

[Download the Marketing Metrics Template from HubSpot here]

How Do You Use Excel for Marketing?

Everyone is different when it comes to the best solution(s) to keep their marketing efforts and metrics organized - one thing that is the same across the board though is the importance of it. 

We would love to hear about some of the ways Excel has made your marketing life easier, so please share them in the comments section below.

Want to learn more about digital sales and marketing?

Master digital sales and marketing when you join IMPACT+ for FREE. Gain instant access to exclusive courses and keynotes taught by Marcus Sheridan, Brian Halligan, Liz Moorehead, Ann Handley, David Cancel, Carina Duffy, Zach Basner, and more.

Sign up for free
Take a peek

Access hundreds of FREE courses and keynotes

Free Course
Digital Sales & Marketing Framework for Today’s Buyers
By: Marcus Sheridan
View Course Preview View Course Preview
Free Keynote
A New Way to Compete & Win
By: Brian Halligan
View Course Preview View Course Preview
Free Virtual Keynote
How To Genuinely Feel Confident, Be Likable, And Build Trust On Camera
By: Liz Moorehead
View Course Preview View Course Preview
Free Keynote
The Future of Marketing is Conversational​
By: David Cancel
View Course Preview View Course Preview
Free Deep Dive
HubSpot On a Budget: Getting Started with HubSpot Starter Hubs
By: Courtney Caldwell
View Course Preview View Course Preview
Free Course
Assignment Selling: Content is Your Greatest Sales Tool
By: Marcus Sheridan
View Course Preview View Course Preview
Free Keynote
The Big, Bold, Brave New World of Marketing​
By: Ann Handley
View Course Preview View Course Preview
Free Course
Investing in Incredible Digital Sales and Marketing Results
By: Chris Duprey
View Course Preview View Course Preview
Free Course
How To Show Your Content Makes Money With HubSpot Marketing and Sales Hubs
By: Liz Moorehead
View Course Preview View Course Preview
Free Virtual Keynote
The Visual Sale
By: Marcus Sheridan & Tyler Lessard
View Course Preview View Course Preview
Free Keynote
Marketing Tech: What’s Now, What’s Near and What’s Not Anytime Soon?​
By: Dharmesh Shah
View Course Preview View Course Preview
Free Course
Inbound Lead Generation & Conversion Optimization
By: Carina Duffy
View Course Preview View Course Preview
Free Virtual Keynote
Fundamentals of Videography: You Can Be a Great Videographer Too
By: Zach Basner
View Course Preview View Course Preview
Free Deep Dive
The Ultimate Customer Service Toolkit for Any Budget
By: Andriti Gulati
View Course Preview View Course Preview
Free Course
6 Topics Subject Matter Experts Need to Address
By: Kevin Phillips
View Course Preview View Course Preview
Free Keynote
Fanocracy: The Power of Making Business Personal​
By: David Meerman Scott
View Course Preview View Course Preview
Free Keynote
The Power of Pillar Content
By: Liz Moorehead
View Course Preview View Course Preview
Free Keynote
SEO for the Future
By: Franco Valentino
View Course Preview View Course Preview
Free Course
Fundamentals of Social Media Marketing
By: Stephanie Baiocchi
View Course Preview View Course Preview
Free Deep Dive
A Practical Guide To Video Graphics
By: Colton Trcic
View Course Preview View Course Preview
Free Session
How To Get Your Community To Know, Like, And Trust You With Video
By: Marki Lemons Rhyal
View Course Preview View Course Preview
Free Course
Video Sales and Marketing Strategy
By: Zach Basner
View Course Preview View Course Preview
Here Are Some Related Articles You May Find Interesting

Want to Contribute Content to impactplus.com? Click Here.

IMPACT+ Sign Up
A FREE online learning community with on-demand courses, hundreds of expert-led sessions, thousands of your peers ready to support you, and much more.
Check it out
Hundreds of courses and recorded keynotes, completely FREE
Check it out
Access hundreds of digital sales and marketing courses and recorded keynotes, completely FREE