inflearn logo
Challenge
Ended

Complete Data Analysis with Excel! 4-Week Challenge Season 2

Master Data Analysis with Excel! 4-Week Practical Challenge What You'll Learn! A hands-on analysis challenge that even those who only use Excel basics can easily follow! Learn through practice and master the core features of data analysis all at once. ✔ Pivot Tables & Pivot Charts → Summarize and visualize large volumes of data ✔ Subtotal Function → Find insights through group-by-group comparative analysis ✔ What-If Analysis (Scenario Analysis) → Methods to predict future data ✔ Data Consolidation Using Functions → Organize scattered materials neatly ✔ Conditional Formatting → Visualize only data that meets specific conditions 👉 After completing this challenge, you'll gain real analytical skills that go beyond simple organization—you'll be able to read, compare, predict, and visualize data. What You'll Learn! A hands-on analysis challenge that even those who only use Excel basics can easily follow! Learn through practice and master the core features of data analysis all at once. ✔ Pivot Tables & Pivot Charts → Summarize and visualize large volumes of data ✔ Subtotal Function → Find insights through group-by-group comparative analysis ✔ What-If Analysis (Scenario Analysis) → Methods to predict future data ✔ Data Consolidation Using Functions → Organize scattered materials neatly ✔ Conditional Formatting → Visualize only data that meets specific conditions 👉 After completing this challenge, you'll gain real analytical skills that go beyond simple organization—you'll be able to read, compare, predict, and visualize data.

Excel
MS-Office
Excel Power Pivot
Data literacy

News

2 articles

  • dmsgml1030님의 프로필 이미지

    Hello, I'm Teacher Eunhee

    Today at 8 PM, I conducted a live special lecture on the Excel Data Analysis Challenge
    This live special lecture explained the solutions for Mission 1 and Mission 2
    (Please download the live special lecture materials)

    Mission 1: Sorting and Subtotals
    Mission 2: Pivot Tables and Pivot Charts


    PS:
    Although not part of the mission, I explained in the live special lecture the 'data integration' work that's useful to know for analysis tasks, Excel tips that are helpful for work, and even the benefit of receiving the 'Excel Tips to Boost Work Efficiency 10x' e-book and practice examples when you write a course review.


    If you couldn't attend the special lecture due to time constraints, the recorded video has been uploaded, so please watch it when you have time
    Also, please watch the online classes and submit your missions
    I will provide feedback diligently

    After finishing the live special lecture, I'm left with a feeling of regret that I could have done better
    Great job everyone~

    0
  • dmsgml1030님의 프로필 이미지

    Complete practical data analysis skills in just 4 weeks - the most realistic course

    Have you ever hesitated to even start learning data analysis because it felt too difficult?

    In fact, data analysis can reach a professional level with just Excel, without any fancy programs.
    That's why we've prepared this.
    A 4-week program featuring only the "core skills of data analysis" - Excel Data Analysis Challenge Season 2!

    🔍 This course is training to develop your "analytical sense"

    Data analysis isn't just about learning functions—it's about developing an 'eye for data'.
    This challenge focuses on building exactly that perspective.

    ✦ Grasp the flow at a glance with sorting and prefix sums

    When you organize complex data, patterns that weren't visible before start to emerge.
    With sorting, grouping, and subtotal features, you can read "what this data is telling you" on your own.

    ✦ Quickly analyze large volumes of data with PivotTables and PivotCharts

    You will learn how to quickly summarize large amounts of data and visualize it with pivot charts to derive insights.
    This is the core of practical analysis.

    ✦ Predicting the Future with Data Integration + Virtual Analysis

    You can combine data from multiple sheets into one dataset and use 'What-If Analysis (Scenario Analysis)' to
    predict "If ○○ happens, how will the results change?"
    Isn't it amazing that you can do this with Excel?

    ✦ Extract Complex Conditional Data in One Go with Advanced Filter

    Don't worry even if there are multiple conditions.
    You'll develop the ability to extract only the data you need through advanced filters.

    ✦ Instantly highlight important data with conditional formatting

    In analysis, important data must be 'visible'.
    You'll learn how to highlight meaningful values with conditional formatting and bring color to your data.

    🎯 Curriculum Structure

    • Total 11 Classes: Condensed Core Data Analysis Skills Only

    • 3 Mission Challenges: Hands-on Practical Assignments to Solve Yourself

    • 2 Live Sessions: Explains the missions and demonstrates data analysis work in real-time

    This process doesn't just end with learning.
    Through the structure of 'Mission → Feedback → Application',your analytical skills will noticeably improve over 4 weeks.

    🚀 In 4 weeks, your analytical skills will be different

    Beyond simply learning functions, you will gain the ability to read, organize, analyze, and visualize data.
    And that change will clearly show in your work speed and the 'quality' of your results.

    This 2nd cohort is prepared with the goal of "analytical skills you really want to use immediately in practice."
    After 4 weeks together, data analysis will no longer be a difficult skill but will become "your weapon."

    📌Master Data Analysis with Excel! 4-Week Challenge Season 2
    Your analytical skills can transform in just 4 weeks.
    Start your journey with us today!

    0

$17.60