GoSkills Excel for Marketers

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.

Reed courses certificate of completion

Digital certificate - Included

• Introduction 02:19

  • 1: Introduction Preview 02:19

• Working with Data 19:12

  • 2: Importing and cleaning data 07:36
  • 3: Counting Items Based on Certain Criteria 04:59
  • 4: Merging Data from Different Lists 06:37

• Analyzing Data 28:10

  • 5: Tables to Make Life Easier Preview 09:03
  • 6: Sort & Filter with Tables 05:32
  • 7: Pivot Tables from Tables 07:49
  • 8: Conditional Formatting to Dynamically Add Color to Reports Preview 05:46

• Visualizing Data 18:25

  • 9: Charts as a Visualization Tool 08:35
  • 10: Dashboards to Display Critical Information at a Glance 09:50

• Automating the Process 07:36

  • 11: Use Power Query to do the Heavy Lifting 07:36

• Quiz 11:00

  • 12: Excel for Marketers Quiz 11:00

Introduction

Introduction

An introduction to the course

Working with Data

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.

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.

Merging Data from Different Lists

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

Analyzing Data

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.

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.

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.

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

Charts as a Visualization Tool

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

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

Use Power Query to do the Heavy Lifting

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

Marketers needing to use Excel.

Only basic knowledge of Excel is required to benefit from this course.

Marketers

Currently there are no Q&As for this course. Be the first to ask a question.