Handling Marketing Data with Excel - Introduction

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!

Practice environment

• Operating System and Version (OS): Windows, macOS, Linux, Ubuntu, Android, iOS, etc. OS type and version

• Tools used: Microsoft Excel

• PC specifications: CPU, memory, disk, graphics card, etc. Recommended specifications for running the program, etc.

Learning Materials

• Format of learning materials provided (providing Excel files related to practice data and examples)

  
  

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