firehighkim7644

How to vlookup data scattered across multiple files without moving the sheet? How to add data that is not in the original data to the pivot table? How to merge files in one folder at once? How to process more than 100 million data in a worksheet? If you can't think of an answer, take this course.

masocampus

Summary of the key points of efficient Excel usage desired by companies

엑셀

피벗테이블

데이터

Masocampus

입문

초급

중급이상

Excel

00 Textbook Download Center

01 Lecture Introduction

02 Raw Data Management Using Cells and Ranges

03 Master the pivot table function for practical processing

04 Comprehensive practical training on frequently used corporate reports

05 Data integration and editing that is difficult if you don’t know

06 Data Model and Measurements