Bức tranh lớn về VBA

You can learn advanced Excel Power Query skills that help you process data efficiently and scientifically, and apply them in practice. (Power Query menu and M code, Advanced Course)

This is the process of becoming the 'standard' for efficiently and scientifically processing and analyzing data using the most trendy method in Excel.

Automating data scraped from the web using RPA to visual analysis in Excel.

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.

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

Learn about tasks that can be done using Excel VBA. Learn about the basic syntax of VBA and objects, collections, properties, methods, and events, and create and use Visual Basic functions, Excel functions, and user-defined functions.

This content provides a practical guide to effectively utilizing generative AI for public institutions and non-profit organizations. It is designed to provide step-by-step specific application cases such as information summarization, document creation, and work capability improvement, starting from the basic principles of working with generative AI, so that learners can immediately apply the utilization method suitable for each situation.

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#

This course is for those who want to create charts more effectively. It introduces how to use various functions and form controls on the chart object to utilize charts more effectively.

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.

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 Practical - Spreadsheet Practice (2021 Revised))

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!🎁

Reorganizing the order of work to increase work efficiency in limited working hours In an era where productivity must be increased to match the reduced working hours, we will help you improve individual work capabilities and overall organizational performance by reorganizing the order of work.

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.

This is a Vibe Coding lecture that teaches how to create actual web services using public data with Google AI Studio (free), even without coding experience. We will create a complete service in Korean, utilizing the Public Facility Safety Information API, including search functionality, map integration, and AI analysis reports. You will learn the entire development process, from PRD planning to deployment, which can be immediately applied in real-world practice.

"Level Up Your Python Alone!" Starting from Python basics, all the way to creating 2D games and an Ollama-based AI chatbot! This is a practice-focused introductory course where you learn core syntax like variables, conditional statements, and functions, and improve your skills by building things yourself.

This course starts with signing up for a Notion membership, teaches the basic concepts needed to use Notion, and creates three Notion templates (dashboard, to-do list, portfolio) that beginners need most, and makes you fall in love with the charm of Notion.

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

You still haven't started studying data analysis...? Are you... what? 😦 Now, data analysis is not a choice but a necessity! Master data analysis with Masocampus lectures and live a new life!

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

Microsoft 365 Copilot is a powerful tool that adds AI to the Microsoft 365 apps we use daily, such as Word, Excel, PowerPoint, and Teams. In this lecture, we kindly explain everything from the basic concepts of Microsoft 365 Copilot to app-specific usage scenarios that can be directly applied to your daily work, making it easy for anyone to follow. You can experience Copilot's powerful features through prompt writing methods and scenario demos that can be directly utilized in actual work.

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

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.

This course introduces how to efficiently manage project schedules using ProjectLibre, a free open-source tool. As an alternative to MS Project, it enables more systematic integrated management of schedules, resources, and costs compared to Excel. Additionally, since it's similar to MS Project, learning this course will help you quickly adapt to MS Project in the future. This course uses a hands-on, follow-along approach that allows anyone to easily create practical schedules. If you want to improve your schedule management capabilities and increase project success rates without cost burden, be sure to take this course! * Version used: 1.9.8 Windows version

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