yblee2k4677

実際の職場で使用されている例では、これらのケースでは、Excelのどの機能と関数を使用して作業を最も迅速かつ効率的に解決できるかを説明するため、臨場感100％を満たすことができるコース

onwings

プロ独自の差別化されたExcelデータ分析とチャートの可視化

学習が役に立ったと思います〜

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.

입문

초급

중급이상

엑셀

Excel

Differentiated Excel data analysis and chart visualization exclusively for professionals

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