Excel for Marketers

via

Go Skills

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

Apply conditional formatting to better visualize your data

Build a custom dashboard and automatically update it with Power Query

Count data based on certain criteria with COUNT and COUNTIFS functions

Create the often-feared but exceptionally helpful Pivot Tables

Import and clean your data to ensure it’s error-free

Merge data from different lists with functions like VLOOKUP, and XLOOKUP

Organize your data with tables, sorting, and filtering

Produce beautiful charts to present your data

Course Content

Expand all sections

Module 1: Introduction

Module 2: Working with Data

Module 3: Analyzing Data

Module 4: Visualizing Data

Course Accreditations