Productivity

Office

Practical training in using statistical data and visualizing Excel

Name: Practical training in using statistical data and visualizing Excel
Price: 11000 KRW

This course is a hands-on course in which you will find statistical data needed in the workplace, download it yourself, and create charts (graphs).

(5.0) 1 reviews

18 learners

hotcoca

실습 중심

데이터시각화

엑셀

Excel

MS-Office

What you will learn!

Creating charts using statistical data
Data Analysis

Create over 10 charts with 3 themes! 📈

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

Step 1

Following the lecture
Download the statistics.

Step 2

Chart (graph) type
Understand how to choose.

Step 3

Data such as bars, lines, circles, etc.
Let's practice the basic chart.

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.

Recommended for
these people

Who is this course right for?

For those who want to create charts and apply them immediately in real life
Anyone who wants to learn visualization using data

Need to know before starting?

Excel

Hello
This is

403

Learners

Reviews

Answers

4.6

Rating

Courses

일잘러가 되기 위해 꼭 필요한 보고서(제안서, 기획서) 작성기술과 결과를 돋보이게하는 시각화 기술(엑셀, PPT, OA)을 전문으로 연구합니다.

전략기획 전문기업, 연구개발 전문기업 등을 거쳐 현재 특허법인에서 기술사업화 컨설턴트로 활동하고 있다. 15년 이상 정부정책기획, R&D기획, 신사업기획 등의 프로젝트를 수행하면서 수많은 제안서, 기획서 등의 보고서를 작성한 경험을 가지고 있습니다.

현재 티엔 대표컨설턴트, 숭실대학교 경영학과 겸임교수로 활동하고 있다. 동원대학교 데이터문헌정보학과 겸임교수, 더비앤아이 책임연구원, 이디리서치의 책임연구원, 특허법인 이노 본부장 등을 역임했으며, 다수의 자문 및 평가위원으로 활동했습니다.

건국대학교, 건국대학교(글로컬), 한국세라믹기술원 등 다수의 대학 및 기관에서 강의를 진행했으며, 주요 저서로는 『누구나 탐내는 실전 기획서』가 있습니다.

Curriculum

All

7 lectures ∙ (3hr 12min)

Course Materials:

Lecture resources

Section 1. [Lecture] Part 1. How to use the statistics portal and practice

1 lectures ∙ (38min)

1. [Lecture] Part 1. How to use the statistics portal and practice
38:58

Section 2. [Lecture] Part 2. Understanding the charts needed for reports

1 lectures ∙ (28min)

2. [Lecture] Part 2. Understanding the charts needed for reports
28:14

Section 3. [Lecture] Part 3. Chart Creation Practice

5 lectures ∙ (2hr 5min)

3. [Writing Practice 1] Creating a vertical bar chart and horizontal bar chart (using Practice File 1))
17:16
4. [Writing Practice 2] Creating a Line Chart (Using Practice File 1)
25:06
5. [Writing Practice 3] Creating a Mixed Chart (Using Practice File 1)
20:50
6. [Writing Practice 4] Creating a circle chart, donut chart, and half-circle donut chart (using practice file 2)
35:12
7. [Writing Practice 5] Creating image charts and two-way charts (using practice file 3)
27:18

Published:

Last updated:

Reviews

All

1 reviews

5.0

1 reviews

youngjinlee0991
Reviews 11
∙
Average Rating 4.8
5
71% enrolled
It's a useful lecture.

$8.80

hotcoca's other courses

Check out other courses by the instructor!

Practical planning book that you can learn through PPT examples

hotcoca

Essential planning skills for office workers who want to grow into tomorrow's workers! We will teach you only the planning skills that are absolutely necessary in the field and provide real-life examples.

입문

presentation PT, Planning Document

Practical planning book that you can learn through PPT examples

hotcoca

Writing a Preliminary Startup Package Business Plan Using ChatGPT

hotcoca

We've ambitiously prepared a lecture packed with business plan writing know-how, leveraging ChatGPT, to help even beginners apply for the 2024 Pre-Startup Package.

입문

ChatGPT, Business Plan

Writing a Preliminary Startup Package Business Plan Using ChatGPT

hotcoca

Practical lecture on report charts finished with Excel

hotcoca

If you are an office worker, you have probably experienced worrying about making a chart at least once. If you are confused about when and what chart to use and how to make it, I will give you a refreshing answer.

입문

Excel, MS-Office

Practical lecture on report charts finished with Excel

hotcoca

Similar courses

Explore other courses in the same field!

Data visualization practice using Excel

masocampus

Stop messy and complicated data! 💥 Now organize your data clearly in Excel and become a professional worker 😉

초급

Excel, MS-Office

Data visualization practice using Excel

masocampus

Office Witch's Power BI - Data Analysis Visualization

wisdomfactory

Team leaders, you say, if you give me an Excel file, I have to look at it one by one? Can't you organize it so that it's pretty and easy to see at a glance? I'm busy organizing and analyzing data, but when will I edit it nicely? When that happens, you think, how great would it be if there was a magical tool that visualizes the Excel data I organized beautifully? Yes, there is. Power BI, a magical tool created by MS. It's a simple visualization tool that makes it easy to see the Excel data you created at a glance, and once you create it, it's continuously updated and used later! We'll tell you very, very easily and kindly what the program is and how to use it!

초급

Power BI, Excel

Office Witch's Power BI - Data Analysis Visualization

wisdomfactory

Deep Learning Framework Made with Excel

hjk1000

Let's implement a deep learning framework directly with Excel! Let's solve supervised learning/unsupervised learning/reinforcement learning with the implemented framework!

초급

VBA, Deep Learning(DL), Excel

Deep Learning Framework Made with Excel

hjk1000

Powering Your Data! Excel Data Analysis

alpaco

Are you wondering which tool to use for data analysis? Get started easily with Excel!

입문

Excel, Excel PowerQuery

Powering Your Data! Excel Data Analysis

alpaco

Automating VBA tasks using Excel

krksap

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

초급

Excel, MS-Office, VBA

Automating VBA tasks using Excel

krksap

Data Classes for High-Performing MDs

mdunnie

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

입문

Data literacy, Excel, Google Sheets

Data Classes for High-Performing MDs

mdunnie

Basic Statistics with Excel

statisticsplaybook

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

초급

Excel, Statistics

Basic Statistics with Excel

statisticsplaybook

[For Beginners] Data Visualization with Power BI

dee

In the [Beginner's] Data Visualization with Power BI course, you will learn how to edit data using the query editor, visualize data using various tools, and check and share the analyzed results.

입문

Power BI, MS-Office

[For Beginners] Data Visualization with Power BI

dee

Excel Macro VBA for Beginners (Introduction)

ridd

Forget boring theories! We're going straight into practice from the beginning of the lecture. Once you start, you'll be captivated by the charm of Excel Macro VBA that you won't be able to stop~!

입문

Excel, VBA, Business Productivity

Excel Macro VBA for Beginners (Introduction)

ridd

Analyzing and predicting marketing data with Excel

groschool

A class on analyzing customer/sales data with Excel, even without R or Python!

초급

Excel, Performance Marketing

Analyzing and predicting marketing data with Excel

groschool

Data Automation (with VBA)

엑셀디자인

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

중급이상

Excel, VBA

Data Automation (with VBA)

엑셀디자인

Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

usefulit

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

입문

Computer Specialist in Spreadsheet & Database, MS-Office, Excel

Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

usefulit

Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

usefulit

초급

Computer Specialist in Spreadsheet & Database, MS-Office, Excel

Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

usefulit

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

초급

Excel, VBA, ChatGPT

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

ITQ Powerpoint Certification to be completed over the weekend

erumcoding

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

입문

MS-Office, PowerPoint, ITQ

ITQ Powerpoint Certification to be completed over the weekend

erumcoding

[Pass ITQ Excel A in One Go] in 3 days

dmsgml1030

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

초급

ITQ, Excel, MS-Office

[Pass ITQ Excel A in One Go] in 3 days

dmsgml1030

Practical training in using statistical data and visualizing Excel

What you will learn!

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

You need to know the basics to apply them.

Develop your practical data utilization skills.

Lecture Structure ✨

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

hotcoca's other courses

Similar courses

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

Recommended for
these people

Hello
This is