엑셀을 이렇게 활용할 수 있는지 몰랐습니다 너무 도움이 많이 되요!

김규리

본 과정은 엑셀의 기능을 설명하는 교육이 아니라 실제 업무 현장에서 사용되는 엑셀 예제를 이용하여 각 상황별로 어떠한 기능을 접목해야 가장 빠르고 효율적으로 업무를 수행할 수 있는지를 학습하는 과정입니다.

엑셀여신

업무가 100배 빨라지는 엑셀 데이터 활용과 분석 노하우

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

입문

초급

중급이상

엑셀

Excel

마이크로소프트 오피스 툴

MS-Office

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

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