Complete Data Analysis with Excel! 4-Week Practical Challenge

You use 'pivot tables' a lot for data analysis, don't you?

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

In this lecture, we'll provide a comprehensive summary of Excel analysis tasks using 10 different methodsfor you

📚 Course Planning Background

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

While there is a method of manually analyzing and summarizing data directly, 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 Excel's various analysis tasks and then improve your work efficiency by applying the right analysis tasks 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 utilize pivot tables, pivot charts, and sorting, subtotals, consolidation features. By following this course, you will be able to skillfully understand and utilize these features

[Example of pivot table and pivot chart analyzing quarterly 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 determining the changing valuesGoal Seek, to display changing results in table format when data is modifiedData Table, and to create hypothetical situations and see how results change Scenario Manager, among other features you can learn.

[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 conditions for other purposes, use Advanced Filter, and if you want to color the extracted data to distinguish it from other data, use Conditional Formatting, etc.

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

📚 Course Curriculum

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

• Sorting Data: Neatly organize data 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 partial sum missions using practical examples

Week 2: Data Summary and Visualization

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

• Visualizing with Pivot Charts: You can visualize pivot tables as charts to enable analysis at a glance.

• Combining Multiple Tables with Integration: Gather scattered data in one place for analysis

Mission 2: Perform a mission to summarize practical examples using pivot tables and express them as charts

Week 3: Predicting with Virtual Analysis

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

• Checking Various Results with Data Tables: Simulate results as data changes, including discount rates, profit margins, etc.

• 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 specific conditions using practical examples and complete a report with visualizations

📚 'Excel Data Analysis, Even Complete Beginners Can Do It!' Challenge course consists of the following steps

1. Learn various Excel analysis features while taking online classes for 4 weeks and

2. Submit 3 missions on the analysis work you have learned and submit them.

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

📚How to Complete Missions

Missions are prepared below the lectures for each section
Read the mission description, download the mission attachment file, solve it according to the instructions, and submit it

📚 Live special lectures are prepared

• You can fill in the gaps from when you performed the missions by listening to Teacher Eunhee's vivid lectures with detailed explanations of the 3 missions and following along.

• I'll explain useful Excel tips that are handy to know for practical work
  (The live special lecture schedule will be announced later in the news)

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

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

📚 Things You Learn After Taking the Course

1. Using Excel's pivot table 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 upcoming future using current data, you can derive virtual prediction results using Goal Seek, Scenario Manager, Data Tables, and other tools.

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

4. You can also use the integration feature to combine multiple tables into one. For example, there's the task of calculating the total intake, sales, and inventory quantities for each branch and integrating them into a single table.

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

5. Advanced filters, conditional formatting, and other data analysis tools allow you to extract the data you want more precisely and easily when organizing and analyzing data.

🎁 Course Benefits

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

• When you submit missions 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 also 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. When analyzing this data, using pivot tables and subtotals will not only reduce work time but also make you an Excel expert.

Q. Are there any important considerations regarding course enrollment?

A. Please prepare MSOFFICE EXCEL 2016 or higher program.

📚 Student Reviews from Those Who Took Teacher Eunhee's Classes

• It was easy to understand because you taught me thoroughly from the basics

• Thank you so much for teaching me so well!

• It was great that you explained it slowly, easily, and well.

• The instructor was very kind and the class pace wasn't too fast - they explained things at just the right speed, which was excellent.

• The instructor was so kind to teach everything step by step carefully, so it was great to understand well even the things I had missed or overlooked!

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

• It was great to follow the class progress as you explained step by step from the basics so that it was easy to understand. Now that the class is over, I feel satisfied that I have built foundational knowledge about the process I learned.