Chief Choi's Excel Pivot Table Master Class
This course will teach you how to use Excel Pivot Tables to quickly and easily analyze data and create dynamic automated reports in your daily life and practice. Pivot Tables are easy and powerful. Through this course, you can begin the process of solving problems through data analysis.
Pivot Table Offline Lecture Opening Guide [Multi-Campus Office Worker Excel Cafe]
I need to be able to analyze my work because I know it best.
๐ But our goal should not be analysis itself, but rather deriving business insights. So learning about analytics and tools should not become a barrier to forgetting the goal.
So, I'm ready.
๐ฉโ๐ปMulti-campus Office Worker Excel Cafe๐จโ๐ป
๐ฉ You can easily solve repetitive, complex, and periodic data processing through Excel Cafe. Excel Pivot Table will be a great starting point for starting and utilizing business data analysis.
๐ Schedule
The course will consist of a total of 4 sessions, with the 1st and 4th sessions being held offline, and the 2nd and 3rd sessions being held live online.
โพ 1st Session: October 13 (Tue) 19:30 ~ 21:30 [Offline]
โพ 2nd Session: Thursday, October 15, 19:30 ~ 21:30 [Online Live]
โพ 3rd Session: October 20 (Tue) 19:30 ~ 21:30 [Online Live]
โพ 4th session: Thursday, October 22, 19:30 ~ 21:30 [Offline]
โก Curriculum
โพ [1st session] Understanding and utilizing the principles of pivot tables Understand the principles of pivot tables and learn how to use them in real work.
โพ [2nd session] Pivot table management and visualization After creating a pivot table, you will learn how to delete and move it, change the original data, and learn about layout, styles, and charts.
โพ [3rd session] Pivot table data exploration and utilization of ratios Learn techniques for sorting and filtering data in pivot tables, as well as groups and slicers. You will also learn techniques for comparative analysis of data using ratios.
โพ [4th session] Create your own real-time Excel dashboard Let's create a real-time Excel dashboard using everything we've learned so far.
โ Course Features
โพ Offline sessions 1 and 4 will be held at Multicampus Seolleung, while online sessions will be held at convenient locations for both instructors and students.
โพ This is the office worker drinking study group โJikterdiโ. We provide drink coupons every hour so that you can study comfortably as if you were having a cup of coffee with a colleague or studying.
โพ Excel Cafe is a cross-composition of Pivot Table and Power Query, and a Power Query Excel Cafe will be opened in November.
๐ Course registration
โพ Apply for the course on the course page: https://bit.ly/32E5MPk
โพ 10,000 won discount coupon (register when applying): WAFCFJSV
๐จโ๐ซ Please email me anytime for inquiries~
billiekorea@gmail.com