I think it can be applied to practice. It's so good. I want to listen to other lectures.

hj011659

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 data utilization and analysis know-how that makes work 100 times faster

입문

초급

중급이상

엑셀

Excel

마이크로소프트 오피스 툴

MS-Office

1. Course Introduction

2. Data conversion techniques that shorten work time

Core techniques needed for using formulas and functions

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

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

Project (Example) 3: Process corporate card usage history and create a department-specific analysis table

Project (Example) 4: Create a yearly transaction analysis table using Internet download data

Project (Example) 5: Create a report analyzing sales amount by day of the week

Project (Example) 6: Create an automated analysis table that can only view selected quarterly performance

Leveraging Power Query to Leverage and Analyze Big Data