Excel Macro VBA for Beginners (Introduction)

Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!

If there is an attachment in an email, save it to OneDrive! If someone uploads a file to the team site, get an email notification! If there is an email from a VIP customer, get a notification! Learn how to automatically do these repetitive tasks without you having to do them yourself.

You can meet Excel as a data analysis tool that can add value to your work. This is a basic Excel course that teaches concepts in a broad and thorough manner from the basics.

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!

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.

After the 4th industrial revolution, the boundaries of industries are collapsing and digitalization is accelerating, opening the era of RPA's software robot-based work automation. We want to automate repetitive and simple/complex tasks with one robot per person through UiPath, so that individuals can spend their time on higher value tasks. Increase the efficiency of digital labor through RPA and implement automation without restrictions on working hours~

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

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)

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!

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.

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.

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.

A flexible work pipeline connecting information exploration, analysis, and organization! A practical search-based automation curriculum completed with Felo

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)

Even if you don't know coding, you can read data - everything about no-code AI analysis that makes perfect sense! If you can use Excel, PPT, and Google Sheets, AI will now handle data analysis for you.

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.

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.

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

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