Back
Course details
View pricing Try for free
View pricing Try for free

Excel for Marketers

Testimonials (62 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

Learn how to use Excel to gain data-driven insights with the GoSkills Excel for Marketers course.

This beginner-friendly course is designed to help marketing professionals get the most out of Excel to save time and be more efficient in their daily tasks. By the end of this short course, you will know how to build your own dashboard using traffic data from Google Analytics. 

If you want to better use Excel for digital marketing endeavors like tracking monthly statistics, measuring the success of campaigns, analyzing SEO opportunities, or managing link building efforts, this course is for you. 

Only basic knowledge of Excel is required to benefit from this course. If you are an Excel pro already, you'll pick up some useful tips and tricks to harness the power of Excel for marketing analytics.

In this course, you will learn how to:

  • Import and clean your data to ensure it’s error-free.
  • Organize your data with tables, sorting, and filtering.
  • Merge data from different lists with functions like VLOOKUP, and XLOOKUP.
  • Count data based on certain criteria with COUNT and COUNTIFS functions.
  • Create the often-feared but exceptionally helpful Pivot Tables.
  • Apply conditional formatting to better visualize your data.
  • Produce beautiful charts to present your data.
  • Build a custom dashboard and automatically update it with Power Query.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

Excel for Marketers
Focus video player for keyboard shortcuts
Auto
  • HD
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Summary

Skill level: Beginner
Certificate: Yes (Excel certification)
Lessons: 11
Accredited by: CPD
Pre-requisites: None
Versions supported: 2016, 2019, 365
Video duration: 1h 15m
Estimated study time: 4.5h for all materials

Accreditations and approvals

CPD - The CPD Certification Service. Microsoft Partner

Instructors

Lydia Uys

Lydia Uys

Course design and review

Dan Gorgone

Dan Gorgone

Presenter


Syllabus

Introduction 1 lesson Free Lesson

1

Try it!

Introduction

An introduction to the course

Working with Data 3 lessons

1

Importing and Cleaning Data

As a Marketer, it’s incredibly important to have up-to-date, clean data. In this lesson we apply some common edits to unusable data to clean it up for use.

2

Counting Items Based on Certain Criteria

This lesson will show you COUNTIF and COUNTIFS that will allow you to quickly gather insights from your data based on the frequency of information.

3

Merging Data from Different Lists

XLOOKUP and VLOOKUP enable you to merge data to add greater context to the data.

Analyzing Data 4 lessons Free Lesson

1

Try it!

Tables to Make Life Easier

If you often work with data sets that are quite large, then you might consider using an Excel table. Tables have a lot of functionality automated and make life easier.

2

Sort & Filter with Tables

If you have a large dataset, it’s easy to get overwhelmed with too much information. Sorting and filtering help you reduce large amounts of data so that you can focus on only the relevant data.

 

3

Pivot Tables from Tables

You often need to make sense of data using a variety of reports and stats. Pivot tables help you do just that.

4

Try it!

Conditional Formatting to Dynamically Add Color to Reports

Conditional formatting can highlight items based on rules you set and, as the data changes and other data meets the requirements, your highlights will change automatically.

Visualizing Data 2 lessons

1

Charts as a Visualization Tool

In our quest to visually represent data, a chart is indispensable.

2

Dashboards to Display Critical Information at a Glance

Having a macro-level - or a birds-eye view - of your marketing efforts is essential. It allows you to see trends, make better business decisions, and point out areas to investigate.

Automating the Process 1 lesson

1

Use Power Query to do the Heavy Lifting

Power Query automates the process of getting data into a table and performing routine edits.

 

Download syllabus


Certificates

You can earn 2 certificates with this course

Certificate of Training

Rewarded upon successful completion of your training course.

See sample

Certificate of Achievement

Rewarded upon successful completion of your training course and test.

See sample
Get started View pricing
View pricing Get started

See what our customers are saying...

“After completing this course my job actually made more sense. Thank you.”

    

Angela L. Gray

“The instructor was very prepared & spoke slow enough to follow along & retain information.”

    

JR

“Excellent instructor and easy to understand.”

    

Md. Tanvir Bin Elias

“Great course, and good pace. Learned a lot :)”

    

Sharon

“Very well explained. In the end of the course, I was able to use in my reports all what I learned from here; particulary creating Dashboards was really interesting! ”

    

Enerieta Dergjini

“Bite size and to the point courses. Well thought out details!”

    

Okyay Nalcaoglu

“Awesome!!”

Kory N Mueller

“An easy to comprehend and affordable program. ”

Devin Lofton

“Great presentation and easy to implement lessons.”

Rodney Trivangalo

“Brilliant, well balanced and informative modules.”

Andy Turner

“Very logical and easy to learn from this web tool.”

Alan HU

“Awesome and efficient classes with very well explained small videos.”

Josh Coley

Others who bought this course also viewed

Excel for Accounting
     4.8 (54 reviews)
Microsoft Excel - Dashboards
     4.8 (173 reviews)
Recommended
Microsoft Excel 365 - Basic & Advanced
     4.7 (2,477 reviews)
Recommended
Microsoft Excel - Pivot Tables
     4.6 (402 reviews)
Back to the top

© 2023 GoSkills Ltd. Skills for career advancement