1/3

Practical Excel skills for data analysis and management

Beginner
8 chapters · 4 hours 18 minutes
English · Japanese · Korean|Audio Korean

Skills You’ll Learn

Using a slicer, the ultimate filter

Everything about slicers that can overcome the weak points of filters

From pivot table processing to machining

Are you still setting up the data one by one? Everything in the pivot table

100% improvement in work efficiency! Essential Excel Skills Practice

All about data analysis and management


Rather than the time it takes to process and transform the data, the data is incorrect and modified, or

Are you lost in searching for the cause of the data error?


We will select and organize only the skills necessary for practical work.

data!

How are you going to make it?

How are you going to manage it?

How will it be transformed?

Complete conquest of data processing and transformation!

Once you've finished working on the interactive dashboard, you can manage your data with Excel!



The theory is simple! The concept is definitely!

I will quickly grasp the theory and show you the practical skills properly

As a hands-on example that you can use right away

A class you can listen to today and use right at the office tomorrow!



I recommend this class to people like this


✓ Those who want to learn advanced Excel skills

✓ Company executives and employees who need to manage and analyze data with Excel


커리큘럼

Step by step from data input to management, processing, and utilization. It is structured around actual work.



A skill you can learn all at once!

Each course is structured to conduct practical training after theory, so you can improve your applicability to your work~!


The most commonly used example files in practice

It is a class designed for realistic practice using pre-set practice data


Various errors encountered in practice

The most commonly used skills in practice


Let's practice all of them.



Class preview

Using a slicer, the ultimate filter

슬라이서 사용하기

When creating materials, wasn't there a time when something wasn't enough?

Filters alone have a few weaknesses.

A slicer that can overcome the weak points of filters! I'll tell you all

From pivot table processing to machining

피벗 테이블 처리부터 가공

Are you still setting up the data one by one?

I'll help you out with Calteau.

Use the pivot table to create data that comes in at a glance.



An opportunity to meet structured classes with professional corporate instructors

기업 전문 강사 소개

▶ ︎ Instructor introduction

Class Kit · Coaching Session


Curriculum

Creator

SMIDA BOOKSTORE

SMIDA BOOKSTORE

Hello,

I'm a lecturer Yoo Sung-min.


Education

•Graduated from Incheon University, Department of Business Administration


careers

•CEO of Knowledge Tree, a company specialized in education

•K-Lancer Star Lecturer, Korea Productivity Center

•Korea Productivity Center Excel Division Online Course Instructor

•Commissioned Lecturer, Seoul Human Resources Development Institute

•Conducting Excel lectures at a number of companies (Samsung Electronics, Hanwha, etc.)

View similar classes you might also like

Data analysis and visualization using ExcelOffice Productivity  |  Hantip

Notes on Copyright Protection

  • All videos and materials included in the class are protected intellectual property under relevant laws.
  • You may face legal action if you copy, distribute, transmit, modify or edit the videos or materials included in the class without permission.
CLASS 101, LLC.
1201 North Market St. Suite 111, Wilmington, DE, 19801
support@101.inc