ChatGPT × Excel Practical Applications: Business Automation for Everyone to Start Easily

Through this course, students will master the core functions of NotebookLM step-by-step and learn how to delegate repetitive office tasks—such as report writing, meeting minute summaries, and data analysis—to an AI assistant. Moving beyond simple conceptual learning, the course provides actual work routines and checklists, equipping students with practical skills that can be applied to their jobs immediately after completion.

A first in Korea! This course teaches you how to automate Word documents for business using ChatGPT. You can easily create various questionnaires, business reports, meeting minutes, and contracts, and apply them directly to your work through hands-on practice.

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.

A first in Korea! This course teaches you how to automate Word documents for business using ChatGPT. You can easily create various questionnaires, business reports, meeting minutes, and contracts, and apply them directly to your work through hands-on practice.

Introduces new features in Excel 2013 and helps you develop Excel's basics and business application skills by learning data entry, table creation, function utilization, data management and analysis, chart creation, and data visualization using conditional formatting.

Repetitive tasks like organizing Excel sheets, sending emails, and categorizing receipts… Are you still doing them manually? Now, leave those tasks to n8n and AI, and focus on what really matters. This course is designed to help anyone implement workflow automation using n8n—a tool that requires no coding—and apply it directly to real-world tasks. In just one hour, you will implement automation from A to Z yourself. Instead of a long 10-hour lecture, we give you only the essential core! To save your time, we focus solely on practical, real-world workflows.

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.

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

Artificial Intelligence is transforming the way professionals work with data. Microsoft Copilot in Excel allows you to analyze, clean, format, automate, and optimize spreadsheets faster than ever before. But using Copilot effectively requires more than just typing prompts — it requires understanding Excel fundamentals, structured thinking, and prompt engineering. This course gives you exactly that. You will learn how to combine Excel expertise with AI-powered automation to dramatically improve productivity, accuracy, and workflow efficiency. What You Will Gain From This Course • Save hours every week using AI-driven Excel automation • Analyze large datasets in seconds using Copilot • Clean and fix messy data effortlessly • Write powerful formulas with AI assistance • Master prompt engineering for Excel Copilot • Build professional reports and dashboards faster • Improve decision-making with AI-powered insights • Optimize workflows for real-world business scenarios By the end of this course, you will not just “use” Copilot — you will control it. What This Course Covers Foundations What is Microsoft Copilot How to activate and use Copilot in Excel Introduction to Excel basics and navigation Data types and conversions Data entry and validation techniques Excel Core Skills Mathematical, logical, and time functions Nested functions for complex calculations Combining logical and LOOKUP functions Conditional statements and formatting Pivot tables and advanced formatting Data Analysis with Copilot Data general analysis and Q&A Sorting, filtering, and profiling data Handling and fixing missing data Identifying and correcting common data errors Transposing data for trend analysis Date-time formatting techniques AI-Powered Excel Automation Generating synthetic data Adding formula columns with Copilot Subtotals and advanced calculations Optimizing workflows using Copilot Enhancing data presentation Editing spreadsheets intelligently Prompt Engineering for Excel Copilot Writing effective prompts Advanced prompt engineering techniques Evaluating prompt performance Optimizing prompts for better results Customizing Copilot for improved outcomes Real-World Application Creating a travel budget using Copilot Practical exercises and activities Performance evaluation and improvement strategies Why This Course Is Different Most Excel courses teach formulas. Most AI courses teach theory. This course bridges both. You will learn Excel fundamentals and advanced skills alongside AI-powered Copilot usage. That combination makes you significantly more productive than someone who only knows Excel or only knows AI prompts. This course is structured for clarity, practical application, and real-world efficiency. Who This Course Is For • Business professionals who work with Excel daily • Data analysts and aspiring analysts • Managers who want faster reporting • Students preparing for corporate roles • Entrepreneurs handling business data • Anyone who wants to leverage AI inside Excel No prior AI experience is required. Excel basics are covered before advancing into automation and Copilot optimization. Why You Should Enroll Today Microsoft Copilot is becoming a core productivity tool across organizations. Professionals who understand how to use AI effectively inside Excel will have a measurable competitive advantage. Instead of spending hours writing formulas, cleaning data, or building reports manually, you will learn how to work smarter. If you want to future-proof your Excel skills and become significantly more efficient with data, this course is for you. Enroll now and master Microsoft Copilot in Excel with confidence.

You still haven't started studying data analysis...? Do you... think you're something special? 😦 Data analysis is no longer an option, it's a must! Master data analysis with Microsoft Campus lectures and start living your best life!

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 covers data analysis using ChatGPT and Pandas utilization. Get a preview of the changed future ChatGPT will create.

We will make the entire data analysis process more accessible using chatGPT and generative AI. While gaining a better understanding of the data analysis process, you can also learn how to apply AI in practical data science.

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 structured around conversation situations frequently encountered in practice, including emotion-regulating communication, softening negative expressions, internal and external communication strategies, empathetic customer service, and role-based simulations. It utilizes ChatGPT to design effective prompts and practice various speaking styles. This is a practical course designed to strengthen strategic expression skills that consider situational context, rather than simply automating expressions.

This lecture teaches how to create diverse quant investment strategies using ChatGPT. Use ChatGPT to build your own quant investment strategy.

The "How Far Can You Go with ChatGPT?" series: Creating a Stock Auto-Trading Application and Web Investment Reports!

This course is a practical training program that utilizes various generative AI tools such as Napkin AI, Gamma AI, Felo AI, Imagen 3, and Suno AI based on ChatGPT to automatically generate and utilize content needed in real office environments. It focuses on multimodal content creation capabilities including report summarization, presentation composition, image generation, and music production, and includes hands-on practice of application cases for each task that leverage the characteristics of each tool.

<200% ChatGPT Questioning Methods> is a practical content focused on 'How to ask ChatGPT questions to get the desired answers?' In this course, we primarily use the free version of ChatGPT. Depending on the content, we also practice with some paid versions to provide exercises suited to the learner's usage environment. Through this course, learners will learn how to ask effective questions to ChatGPT and, by actively using various extensions, can boost their work applicability.

AI solutions that maximize innovation and performance! Your business will leap to a new dimension.

Apply the latest trends in generative AI directly to your work! The bible of prompt engineering lectures, containing only the essentials.

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.