Excel for Marketers

Go Skills

(6)

Course Features

Duration

4.5 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

1.3 hour

Course Description

The GoSkills Excel course for marketers teaches you how to use Excel to gain data driven insights. This course is easy to follow and will help you save time and make your marketing more efficient. This course will teach you how to create your own dashboard with traffic data from Google Analytics. Even if you are already an Excel pro, you will learn useful tips and tricks to harness Excel's power for marketing analytics.

Course Overview

Personlized Teaching

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

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

Course Content

Expand all sections

Module 1: Introduction

Module 2: Working with Data

Module 3: Analyzing Data

Module 4: Visualizing Data

Course Instructors

Lydia-Uys

Course design and review

Lydia is a Chartered Accountant with experience in financial management, lecturing, and consulting. She first trained as an external auditor and then proceeded to work as a financial manager, consult...

Dan Gorgone

Presenter and Course Producer

Dan has created over 50 online courses about marketing, business growth, UX, and more. He has over a decade of experience developing courses and workshops for companies including MarketingProfs, Mixergy, Treehouse, and Full Sail University.

Course Accreditations

Course Reviews

Average Rating Based on 6 reviews

5.0

100%