[Episode] Excel + Python (Basic)

The easiest explanation of R-based data visualization📊. (Almost) everything you need to know😎. At the end, we will plot COVID-19 💉vaccine vaccination data on a map🗺️!

A friendly R class from a professional instructor who teaches data analysis for over 1,000 hours a year! We've renewed the existing lectures and will also inform you of the latest trends.

A current professional data analysis instructor at a large company who passed the Big Data Analysis Writer and Practical exams in one go will help you prepare quickly by summarizing the key points.

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.

This course is a friendly and easy course that selects only the essential contents that can be applied immediately in practice, and increases work efficiency by using Excel as if it were your own hands and feet.

Have you ever felt itchy and stuffy whenever you created a function in Excel? If so, solve it with this course that covers everything from A to Z about functions!

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

The 🔥 HOT recruitment keyword in the digital transformation era, "digital competency", is what Masocampus has prepared! A gem-like lecture that will help you develop data-based performance improvement capabilities using only Excel 🎁 (After taking the course, become a key talent for your company 😉)

In this class, you will learn techniques for retrieving (crawling) and processing data from various operating sites using Python, and apply them directly to various examples that you may encounter in the field. Through this, you will learn techniques that focus on solving practical problems based on an understanding of the basic principles of how the web works, rather than one-dimensional task automation by copying and pasting given codes, and accordingly, you will be able to collect and process data from any site in the future. You will also learn how to resolve various exceptions that occur in this process with code, and ultimately, you will be able to solve and automate various problems that occur in daily life with programming thinking.

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

This course is a course that practices the basics of machine learning mathematics and statistics using Python. Machine learning and deep learning require programming skills, but they also require a mathematical background to understand the principles. Through this course, you can gradually learn the basic mathematics required for artificial intelligence.

We explored the essential Python syntax necessary for big data analysis and, through various examples, presented methods such as big data file processing and visualization.

This course will help you quickly learn the core concepts of Python and the Pandas library. Improve your programming skills by solving the practice problems at the end of each part!

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.

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

Time Series: Become a Data Analysis Expert! Let's be analysts strong in theory & practice!

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.

With Python Quant Investment, you can create investment strategies based on data and invest according to the strategy. You can implement various asset allocation strategies and ultimately create your own investment strategy.

Revolutionize your stock investments with AI! In this lecture, you will directly build a real, working AI automated trading system targeting the top 25 NASDAQ stocks. We provide a special opportunity to gain experience and know-how through simulated investments with the 한국투자증권 API, and to perform AI stock automated trading with a real account. Even stock beginners will have no problem. We will easily explain basic stock concepts and why you should invest in US stocks, and provide all source code and remote support. From now on, investment is essential for the next 60 years of our lives. Create your own AI investment partner that will be with you!

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.

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

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.