I learned many new features. It was a big help. Thank you.

shjun63156670

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work settings to learn which functions to apply in each situation to perform tasks most quickly and efficiently.

onwings

2026 새해 복 마🐴니 할인

Excel data utilization and analysis know-how that makes work 100 times faster

입문

초급

중급이상

엑셀

Excel

마이크로소프트 오피스 툴

MS-Office

1. Course Introduction

2. Data Transformation Techniques that Shorten Work Hours

Key techniques for using formulas and functions

Project (Example) 1: Complete the transaction history table using a function after editing the supplier DB

Project (Example) 2: Compare two data lists to manage training history and create a summary table

Project (Example) 3: Process Corporate Card Usage Details to Create Departmental Analysis Report

Project (Example) 4: Creating Annual Transaction Partner Analysis Table from Internet Download Data

Project (Example) 5: Writing a Daily Sales Analysis Report by Day of the Week

Project (Example) 6: Creating an Automated Analysis Table to View Only Selected Quarter Performance

Power Query for Big Data Utilization and Analysis