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

You use 'pivot tables' a lot for data analysis, right?

However, Excel provides various analysis tools suitable for different situations beyond pivot tables.

In this lecture, we'll provide a complete summary of Excel analysis work through 10 methodsfor you

📚 Course Planning Background

When working, there are many cases where you need to summarize or analyze large amounts of data.

While you can manually analyze and summarize data by hand, doing it manually every time not only takes a lot of time, but also results in lower accuracy compared to using Excel's features.

So through this course, I hope you will learn various analysis tasks in Excel and then improve your work efficiency by applying the right analysis task for each situation in your work

📚 Here's what you'll learn in this course

1. Summarizing and Analyzing Large Amounts of Data
When analyzing large amounts of data to create reports or proposals, you can use pivot tables, pivot charts, and sorting, subtotals, and consolidation features. By following this course, you will be able to understand and utilize these features proficiently

[Example of Pivot Table and Pivot Chart Analyzing First Quarter Performance by Salesperson]

2. Predicting Result Values When Data Changes
When you want to predict how results change by modifying current data, you can use what-if analysis
To find the desired target value by identifying the changing valuesGoal Seek, to display the changing results in table format when data is modifiedData Table, and to create hypothetical situations and see how results change Scenario Managercan be learned.

[Example data table predicting changes in amount based on period changes and annual interest rate variations]

3. Extracting and Visualizing Data that Meets Conditions
If you want to extract data that meets certain conditions and use it for other purposes, use Advanced Filter, and if you want to color the extracted data to distinguish it from other data, use Conditional Formatting

[Example of conditional formatting with red formatting applied to rows where monthly expenditure total is 2 million or more]

📚 Course Curriculum

Week 1: Organizing and Summarizing Data in a Clear and Concise Manner

• Sorting Data: Organize your data neatly according to your desired criteria

• Comparative Analysis by Group Using Subtotals: Analyze group totals and averages all at once

Mission 1: Perform data sorting and subtotal missions using practical examples

Week 2: Data Summarization and Visualization

• Summarizing Data with Pivot Tables: Quickly aggregate large amounts of data

• Visualizing with Pivot Charts: Visualize pivot tables as charts for at-a-glance analysis

• Merging Multiple Tables with Consolidation: Gather scattered data in one place for analysis

Mission 2: Complete the mission of summarizing practical examples with pivot tables and expressing them in charts

Week 3: Predicting with Virtual Analysis

• Goal Seek: You can find the target value needed to produce the desired result

• Exploring Various Results with Data Tables: Simulate results as data changes, such as discount rates and profit margins

• Scenario Manager: You can compare and analyze multiple hypothetical situations to select the best scenario

  
  

  
  

Week 4: Advanced Analysis and Conditional Visualization

• Conditional Formatting: You can find data that meets certain conditions and apply formatting to emphasize it

• Advanced Filter: You can extract data with complex conditions separately

Mission 3: Perform a mission to extract data that meets the conditions using practical examples and complete a report with visualization

📚 'Data Analysis with Excel!' Challenge course consists of the following steps

1. While taking online classes for 4 weeks, I learned various Excel analysis features and

2. Complete and submit 3 missions on the analysis tasks you've learned

3. You'll learn how to use Excel's analysis features while receiving professional feedback

📚 How to Complete the Mission

Each section has missions prepared below the lectures
Read the mission description, download the mission attachment, solve it according to the instructions, and submit it

📚 Live special lectures are available

• You can fill in the gaps from your mission performance by listening to and following along with Teacher Eunhee's vivid lectures on the detailed explanations of the three missions.

• I'll explain useful Excel tips that are good to know for practical work
  
  

By the time the challenge course is coming to an end, the analysis work that once felt vague

By now, you will have transformed to the point where you can quickly create reports and analysis materials using Excel

Now you can finish your work quickly

📚 What You'll Learn After Taking This Course

1. Using Excel's PivotTable feature, you can easily organize data as desired, such as totals and averages by category, without the need to manually analyze large amounts of data.

[Pivot table summarizing average evaluation scores by department]

2. When there is a need to group large amounts of data and perform comparative analysis by group, you can use subtotals.

[Subtotal comparing quarterly performance by sales department]

3. If you need to predict the future using current data, you can derive predicted results virtually using Goal Seek, Scenario Manager, Data Tables, and other tools.

[Scenario describing changes in profit amount as margin rate and discount rate vary]

4. You can also use the consolidation feature to combine multiple tables into one. For example, there's a task to calculate the sum of incoming stock, sales volume, and inventory for each branch and consolidate them into a single table.

[Integrate Q1 and Q2 inventory status totals to complete the first half inventory status]

5. When analyzing and organizing data using advanced filters, conditional formatting, etc., you can extract the data you want more precisely and easily

🎁 Course Benefits

• You can ask questions anytime during the course → The instructor will answer directly

• When you submit a mission 2 or more times or write a course review, we will provide you with the "Excel Tips PDF for Improving Work Efficiency (100 pages)" e-book along with practice examples

  
  

📚Frequently Asked Questions Q&A

Q. Can non-majors take this course?

A. Yes. Excel is a program widely used in all types of work, so regardless of your major, it will be useful for anyone to know.

Q. Why should you learn Excel analysis work?

A. When working, large amounts of data inevitably accumulate. By utilizing pivot tables and subtotals when analyzing this data, not only will your work time be reduced, but you'll also become an Excel expert.

Q. Are there any important notes regarding course enrollment?

A. Please prepare Microsoft Office Excel 2016 or higher.

📚 Reviews from Students Who Took Eunhee's Classes

• It was easy to understand because you explained everything thoroughly from the basics.

• Thank you so much for teaching me so well!

• I really appreciated how you explained things slowly and in an easy-to-understand way.

• The instructor was very kind and the class pace was just right - not too fast - and the explanations were excellent, which made it a great experience

• The instructor kindly taught everything step by step, which helped me understand things I had missed before!

• It's not burdensome for beginners to take and there's no major difficulty in understanding. It helps improve one's abilities.

• The course was easy to follow as the instructor explained everything step by step from the basics, making it easy to understand. Now that the course is finished, I feel satisfied that I've built a foundational knowledge of what I learned.