왕초보를 위한 엑셀 매크로 VBA(입문)

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.

This is a class that teaches intermediate and advanced level data analysis and visualization chart creation methods to those who can handle Excel basics. With this class, you can master Excel completely!

If you are an office worker, you have probably experienced worrying about making a chart at least once. If you are confused about when and what chart to use and how to make it, I will give you a refreshing answer.

Learn various know-hows that will help you get the most out of Excel in your real 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.

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

"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.

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

First in Korea! A course on automating Word business documents with ChatGPT. Easily create various questionnaires, work reports, meeting minutes, and contracts, then immediately apply them to your work through hands-on practice.

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.

CI/CD environment is indispensable in modern project development. Let's become a (real) deployment fairy with TeamCity, the most widely used tool in the field!!

A company should not rely solely on the capabilities of its members, but should operate on systems and processes. To do this, a work culture that encourages collaboration and sharing is needed. This lecture explains the necessity of collaboration and the difficulties of existing collaboration methods, and explains how to effectively collaborate, build work history, and accumulate know-how based on Confluence.

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

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

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.

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.

“The era of merely asking AI and getting answers is over.” Now, AI acts on its own. 'Action-oriented AI agents' have emerged that read emails, check remaining annual leave in HR systems, schedule meetings, search internal documents to summarize information, and organize necessary images and links. What's surprising is that all of this can be created even if you're not a developer. By leveraging the Azure AI Agent platform and Microsoft's latest frameworks (Semantic Kernel, AutoGen, etc.), anyone can now build multi-agent systems deployable in actual work, without coding. Directly create 'working AI,' 'connected AI,' and 'AI that judges and moves on its own.' The future is no longer a distant story. It begins now, at your fingertips.