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.
# 12.11 First Live Special Lecture Summary
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~

