Name: Handling Marketing Data with Excel - Introduction
Price: 31900 KRW

Handling Marketing Data with Excel - Introduction

An introductory course on easily organizing and analyzing marketing data with Excel! Learn through hands-on practice, including PivotTables, functions, and practical problem-solving, to acquire data analysis skills that can be immediately applied in real-world work.

I want to analyze my marketing data in Excel, but where do I start?

Sales data, customer lists, advertising performance reports...
There is a lot of marketing data that we encounter in practice,
This lecture is for those who are at a loss as to how to organize and analyze .

This course is an introductory course on marketing data analysis using Excel .
It's okay if formulas are unfamiliar and pivot tables are difficult.
It is structured so that you can follow along step by step, with practical examples, from the beginning.

🎯 Key points you can learn through examples!

“This hands-on example is based on real marketing data ,
Click-through rate (CTR), advertising efficiency analysis, automatic aggregation, visualization, etc.
You can experience step-by-step analysis techniques that can be applied directly to practice .

Core functions/tools: IF, INDEX-MATCH, SUMIF, COUNTIF, PivotTable/Chart
Optimized for advertising and marketing data practice
With easy examples that anyone can follow ,
Designed for immediate application in real-world work .

You can learn things like this 👩‍💻

Calculating advertising performance indicators such as click-through rate (CTR) and advertising efficiency analysis
Classify regular customers by analyzing total sales and purchase price by customer ID
Extract and automate conditional data with IF, VLOOKUP, and INDEX-MATCH
Create a sales summary report by region, age group, and gender using pivot tables and charts
Sales forecast simulation using discount application, scenario tool, and target finding
Automating conditional sales and profit aggregation with SUMIF/COUNTIF/SUMIFS functions

Real analytics through practice 💡

A total of 30 practice problems are provided.
If you follow along step by step, you will soon be able to perform the following analysis:

📌 "How much of the sales were generated in the Seoul area alone?"
📌 "Which product group has the highest profit rate by category?"
📌 “Who are the best customers who have purchased in the last 6 months?”
📌 "If the unit price increases by 10%, how much will the total sales change?"

I recommend this to these people 🙌

People who are working in marketing but are not yet familiar with Excel analysis
People who need to deal with customer/sales data but don't know where to start
Beginners who are just starting out with data analysis
Beginners in data analysis who want to expand to Tableau and SQL later are also welcome!

I don't have any advanced knowledge. All I need is to be able to turn on Excel!

Without complex coding or analysis tools,
We'll show you how to organize and analyze your marketing data with just Excel .
Focusing on data cases that are actually used a lot,
You will get used to the flow of “This is how to solve this type of practical problem.”
Start your first step in marketing data analysis right now with this course! Whether you have the required prerequisite knowledge considering the learning difficulty
Content directly related to the course, such as lecture video quality (audio/picture quality), and recommended learning methods
Questions/Answers and future updates
Notice regarding copyright of lectures and learning materials

Recommended for
these people

Who is this course right for?

New to Marketing Data Analysis
Those who want to learn practical data analysis skills using Excel
Applicants for Marketing/Sales/Planning roles preparing for job search and career change.

Need to know before starting?

Basic Excel experience is a plus, but not required. VLOOKUP, IF, pivot tables, etc., are explained in detail with practical exercises in the lecture, so the course is designed for even those new to Excel to easily follow.

Handling Marketing Data with Excel - Introduction

What you will learn!

🎯 Key points you can learn through examples!