[Intermediate] Mastering Excel with a Solid Foundation Course

Stop doing patchwork tasks where you just change numbers in Word templates created by others! This course is a 'practical-optimized all-in-one condensed course' that helps you master the full menu manual from Word 2019 to the latest 2026 version from A to Z, building the self-sufficiency to perfectly handle any data analysis or document creation you encounter in the field.

Stop doing patchwork tasks where you just change numbers in Excel templates created by others! This course is a 'practical-optimized all-in-one condensed course' designed to help you master the entire menu manual from Excel 2019 to the latest 2026 version from A to Z, building the self-sufficiency to perfectly handle any data analysis or document creation you encounter in the workplace on your own.

From the daunting first cut to a brilliant finished piece, our systematic curriculum transforms you into a professional.

This is a systematic learning course designed to help you understand the fundamental principles of Photoshop beyond simple imitation. Structured as a 4-step roadmap—covering everything from layers, masks, and color correction to high-end retouching—it consists of 65 sessions averaging 5 minutes a day, allowing you to master practical design skills that can be applied immediately to any version of the software.

Follow along easily with example files for each session. A systematic logic guide that's hard to believe is a free lecture! Request the example files at sinuihyun@gmail.com.

This is a step-by-step approach training course for those who lack the basics.

System training with step-by-step examples; After Effects, which once felt overwhelming, finally begins to look systematic.

This course is recommended for those who want to learn the basics of Cinema 4D.

This course covers everything from Premiere Pro CC 2022 to the latest version. Let’s learn Premiere Pro systematically with example files provided for each class!

Through this course, students are expected to build a solid foundation in Excel. Those who have taken the Edupick Excel "Beginner - Intermediate" course will be able to understand the content even faster.

We expect that students will be able to build a solid foundation in Excel through Edupick lectures.

Through this course, students are expected to build a solid foundation in PowerPoint.

Take the EDUPIC course and become a true fan! This course is for advanced users of Word 2013 & 2016.

Take the EDUPIC course and become a true fan! This course is for intermediate users of Word 2013 & 2016.

Take an EDUPIC course and become a true fan! This is an introductory course for Word 2013&2016.

Through this lecture, I expect that students will be able to build a solid foundation of Motion 5 knowledge. I hope that you will create wonderful works through the Motion 5 basics course.

This course can be taken with Illustrator CC 2015 and later, as well as the latest version. Let's learn systematically with example files provided for each class.

This course is available for all versions from Premiere Pro CC 2015 to the latest version. Let's learn Premiere Pro systematically with example files provided for each class!

This course is designed to help you learn all of the Final Cut Pro manuals.

This course is available for all versions from Cubase 9 and above to the latest version. Let's learn Cubase systematically by practicing directly with example files!

Through this course, students are expected to build a solid foundation in Excel. Those who have taken the Edupick Excel "Beginner - Intermediate" course will be able to understand the content even faster.

We expect that students will be able to build a solid foundation in Excel through Edupick lectures.

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

Not just an Excel lecture that ends after learning, but a lecture where your own tools appear "snugly" on the ribbon. No more letting VBA books become bookshelf decorations! Even if you don't know a single line of code, you can complete your own automation buttons just by chatting with AI. Check out the free lecture now to see the CustomUI-based add-in production method, revealed from start to finish for the first time in Korea by a Microsoft Excel MVP.

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.

The HOT recruitment keyword in the era of digital transformation: "Digital Competency." That’s why Micro Campus has prepared this! A gem of a lecture that builds data-driven performance improvement skills using only Excel 🎁 (Become a core talent of your company after taking this course 😉)

This is a practical lecture designed for passing the ITQ Excel Grade A exam in a short period. You will master the four-step process—from data entry to pivot tables and charts—and learn time-saving skills to finish with 15 minutes remaining in the 60-minute exam. Rather than rote memorization, you will understand functions through intuitive pattern matching and complete your Excel skills to be immediately applicable in real-world tasks.

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.

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.

If you have completed the basic and essential lectures to understand Power Automate Desktop, now you will learn the most frequently used Excel automation flow in your work through hands-on practice so that you can automate more in your actual work.

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)

Visual design techniques that go beyond data visualization to instantly persuade others From visual cognitive design to future scenario analysis and AI workflows, all at once

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)

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

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

Excel automation is possible without uploading company data? Revealing AI secrets that maintain security while reducing work hours!

This is a practical course where you will learn how to directly control and automatically generate Word documents using Python and pywin32. You will understand the workflow of generating documents through code rather than manual writing, with the goal of creating an automation structure that can handle reports and documentation tasks with a single click.

This is a practice-oriented course designed to increase work productivity by automating repetitive Outlook email tasks using Python. From composing emails and saving drafts to accessing the inbox, searching for emails, handling attachments, categorizing emails, and creating calendar events and contacts— you will learn how to automate frequently repeated Outlook tasks using Python and pywin32. Rather than just explaining simple functions, this course is structured to help you build your own reusable Outlook automation programs through automation code ready for immediate practical use and real-world project examples.

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.

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