Practical training in using statistical data and visualizing Excel

Create over 10 charts with 3 themes! 📈

To be applicable to practice,
The course consists of three stages

You need to know the basics to apply them.

Charts (graphs) are a constant presence in every report or report we write. They're so widely used and important. Even after taking numerous classes, when it comes to actually applying them in practice, I often feel lost as to where to begin. This indicates a lack of fundamental understanding. Understanding the fundamentals is more important than mastering complex and diverse charts.

Develop your practical data utilization skills.

Just because you have a single data set doesn't mean you can create just one chart. Charts are created to convey a message based on data, and the type and visualization of the chart varies depending on the message. This course aims to help you create more than ten charts using three sets of data.

Lecture Structure ✨

Part 1. How to Use the Statistics Portal and Practice

Understand where to obtain national statistical data and gain practical experience by downloading data directly according to actual conditions.

Part 2. Understanding the charts needed for the report

You will learn how to create charts using statistical data and what are the important parts of chart creation.

Part 3. Chart Creation Practice

[Writing Practice 1] Creating Vertical and Horizontal Bar Charts (Using Practice File 1)

Using the first practice file, you'll create your own vertical and horizontal bar charts. Through this exercise, you'll learn not only how to create charts, but also how to adjust axes, adjust bar thickness (interval width), and other features.

[Writing Practice 2] Creating a Line Chart (Using Practice File 1)

Let's create a line chart using the practice file in step 1. Through this exercise, you'll learn not only how to create a chart, but also how to change line colors, change markers, and place legends.

[Writing Practice 3] Creating a Mixed Chart (Using Practice File 1)

Using the practice file #1, you'll create your own mixed chart (line + bar, bar + bar). Through this practice, you'll learn how to use auxiliary axes, set the correct axes, and create mixed charts.

[Writing Practice 4] Creating a Circle Chart, Donut Chart, and Semi-Circle Donut Chart (Using Practice File 2)

Using the second practice file, you'll create your own pie chart, donut chart, and semi-pie chart. Through this exercise, you'll learn how to arrange circle segments, adjust hole sizes, and process statistical data.

[Writing Practice 5] Creating Image Charts and Two-Way Charts (Using Practice File 3)

Using the third practice file, you'll create your own image chart and interactive chart. Through this exercise, you'll learn features like inserting images into bars and chart design techniques.