Essential Excel Features & Functions for Marketing Analytics
4.1 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
89 students enrolled

Essential Excel Features & Functions for Marketing Analytics

Must have Excel skills for every Marketer, Marketing, Web, SEO and Digital Analyst and Strategist. Includes Solver.
4.1 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
89 students enrolled
Created by Anil Batra
Last updated 8/2019
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Essential functions for Marketing Analytics
  • Features to enhance marketing analytics
  • How to setup budget for various ad/channels such as Google Ads
  • Learn how to use Solver - Excel add-on
Requirements
  • Basic understanding of Excel
Description

Excel is one of the most used tool for data analysis by marketers, marketing analysts, web, SEO and digital analysts.

In this course we will learn about some awesome Excel features and functions and see several practical examples of how to use them for your analysis. Not only do I teach excel functions and features useful for Marketing, Digital and Web Analytics but also you will get cool ideas about what data you can analyze.

What you’ll learn

  • Understand various types of errors Excel throws and how to fix them

  • How to suppress the error or replace them with more meaningful data

  • Learn different ways of combining data from multiple columns

  • Understand different types of cell references.

  • Bulk delete blank rows to clean your excel sheet data

  • Find duplicate rows of data, highlight them and/or bulk delete them

  • Learn how to use VLOOKUP - Uses search engine (SEO) keyword data as an example.

  • Learn Pivot Tables - Example:  Digital Marketing Campaign Analysis

  • Find Optimal Campaign Budget Allocation with Excel Add-In Solver - This will change the way you allocate your marketing budgets.

Course requirements or prerequisites?

  • You should be familiar with the basics of Excel.

Who this course is for:

  • Anybody who wants to learn about some key features in Excel how to apply them to common data issues.

  • Marketing Analysts

  • Digital & Web Analysts

  • SEO analysts

Who this course is for:
  • Marketing Analysts
  • Data Analysts
  • Anybody who want to take their excel skills to next level
  • Search Engine Optimization marketers and analysts
  • Email Marketers and Marketing Analysts
Course content
Expand all 11 lectures 01:14:04
+ Manipulating the Data
2 lectures 14:40
Combining Multiple Columns
07:31
Understanding Cell References in Excel
07:09
+ Cleaning the data
2 lectures 09:08
Removing blank rows
02:48
Finding and Removing duplicate data
06:20
+ Data Analysis
3 lectures 35:14
Learn how to use VLOOKUP - Example of Search Keyword Data
09:57
Understanding Pivot Tables - Example Digital Marketing Campaign Analysis
11:13
Find Optimal Campaign Budget with Excel Add-In Solver
14:04