Rediscovering Excel: Encyclopedia of Practical Tips

This course is for those who are new to Excel or want to upgrade from basic to advanced level.

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

This is a course that allows you to quickly learn the essential Excel tasks that office workers must encounter, using the latest features.

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

A ChatGPT lecture planned with 2024's latest information. Based on large enterprise & finance field content, it covers hands-on 3.5/4.0 prompt practice and diverse generative AI tool use.

Expanding Excel's data processing capabilities and enhancing data handling performance through integration with external systems (SQL Server, Access, etc.) - Utilizing core Excel features such as Power Pivot (Excel Data Model) - Ultimately extending usability beyond the various limitations and inefficiencies of Excel

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.

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!

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.

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

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. :)

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

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

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!

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.

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)

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)