[Office worker's honey item] Office emergency kit for office workers! Know and use Excel functions properly

From basic functions to high-level practical documents used in the field, to new features exclusive to Excel 2016! Give wings to your documents with Excel 2016!

You use 'pivot tables' a lot for data analysis, right? However, Excel provides various analysis tasks that are suitable for the situation in addition to pivot tables. In this lecture, we will organize Excel analysis tasks in 10 ways (sorting, subtotals, pivot tables, pivot charts, target value search, data tables, scenario managers, integration, advanced filters, conditional formatting)

Through Edupick lectures, students are expected to be able to build a solid foundation in Excel.

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

Are you wondering which tool to use for data analysis? Get started easily with Excel!

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

A class on analyzing customer/sales data with Excel, even without R or Python!

Data-based decision-making ability, an essential competency in the era of digital transformation! As companies rush to find talent with digital capabilities, develop BA capabilities to successfully solve organizational problems through this course!

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

You know the importance of 🔥Big Data🔥 in your business, but you gave up on data analysis tools with difficult names like Python, R, SQL... before you even started? Don't worry anymore 😉 A beginner's course that teaches anyone how to analyze data and discover valuable insights using Excel, which is highly accessible!🎁

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

AI Excel that automates perfectly for your work without company security concerns. From data preprocessing to visualization in just a few minutes, no coding knowledge required!

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)