yjlee8743

This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.

onwings

Differentiated Excel data analysis and chart visualization exclusively for professionals

입문

초급

중급이상

엑셀

Excel

Get started

Useful Excel tips to know

Convert downloaded Raw Data

Core functions needed to properly handle formulas and functions

Data analysis done in one go with pivot tables

Differentiated data visualization using charts

(Project Example 1) Convert the format of the purchase summary table downloaded from Hometax and aggregate it

(Project Example 2) Converting an employee's work history sheet into a report form for the Korea Workers' Compensation and Welfare Service

(Project Example 3) Analyze special bonus payment amount by dividing by department, employment and retirement

(Project Example 4) Creating an Analysis Report Using Claim Receipt Raw Data

(Project Example 5) Find the lowest unit price by product name and specification and create a unit price comparison table

Course End