Excel and Database (Introduction) [Subtitles included]

Through this course, even beginners can master Power BI from the basics to intermediate level!

Are you still using Google Sheets simply like Excel? If you use Google Sheets properly, you can significantly reduce the time spent on collecting data through copy-pasting, getting confused by the latest files, and fixing formula errors. Try automatically operating reports and dashboards that are always up-to-date based on real-time data connections.

I will show you how to use Excel effectively in your work and how to create data that is easy to analyze.

"Master Excel from the basics to workflow automation in just 25 days. This course is designed to help you become a high-performer by mastering core practical functions like VLOOKUP, Pivot Tables, and Macros to reduce repetitive tasks, while also gaining the skills to create dashboards that visualize data at a glance."

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.

Now you can use Python in Excel! A light lecture to try out the latest features!

This is a practice-oriented course designed to increase work efficiency by automating repetitive Excel tasks with Python. You will learn how to automate the entire workflow—from opening files to data processing, inspection, consolidation, and saving—and will also be provided with practical automation code using pywin32.

Excel automation is possible without uploading company data? Revealing AI secrets that maintain security while reducing work hours!

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

Coding Excel data with Python?! It's not that hard~ Becoming a cutting-edge professional is only 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. :)

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

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)

This covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn how to create Excel formulas needed for practical work, easily understand Excel functions, and even write macros and VBA coding using ChatGPT.

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)

AI Excel that automates perfectly for your tasks without any company security concerns. From data preprocessing to visualization, everything is OK in just a few minutes—without any coding knowledge!

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.