Practical Excel for Getting Off Work Earlier

From cleaning up messy raw data to SUMIFS and INDEX/MATCH summaries, verification cells, dashboards, and weekly reports (22 lessons in the basics); then adding new weekly data, XLOOKUP, dynamic arrays, pivot table checks, conditional formatting, analysis, and handover (42 lessons in the advanced section)—follow along with the starter and completed files for each lesson to build and maintain a dashboard whose numbers match the raw data.

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.

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

I will show you how to use Excel effectively in your work and how to create data that is easy to analyze.

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.

Use AI to build your own Excel macro-based stock analysis program. You will practice step by step how to retrieve data from the internet based on a stock ticker and date range, then record and organize the JSON data in an Excel sheet. Along with price changes, moving averages, trading volume, and changes in financial performance, you will analyze period returns, volatility, and maximum drawdown, completing everything from an individual stock analysis screen to a comprehensive dashboard for comparing multiple stocks of interest.

Even if you don't know coding, you can read data—everything about no-code AI analysis that makes work sense explode! From marketing to HR and quality management—we'll make your work sense explode with AI.

Are you wondering which tool to use for data analysis? Get started easily with Excel!

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.

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.

We transform distribution reports that merely list numbers into a single page that supports decision-making. Drawing on 24 years of experience in distribution operations and headquarters, we use Excel and AI to analyze changes in sales and contribution margin and examine hypotheses about their causes. By calculating simulated distribution data ourselves, we complete performance reports containing key conclusions, execution conditions, and approval requests.

Even complex data becomes clear at a glance with Tableau! From a single drag to a finished dashboard, master data visualization for real-world business.

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

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)

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.

Efficiently tackle the typical office tasks that keep employees working late—such as recurring monthly report writing and large-scale data organization—with the AI assistant Claude. Learn practical techniques for freely designing and enhancing long-form text visualizations and slides while preserving the unique formatting and layout of your company’s templates. Through this process, you can perfectly complete the manual documents that accumulate over time within the allotted deadline.

Going beyond explanations of basic Excel functions, this hands-on course teaches the full workflow of recurring tasks in real-world work—from data entry, organization, preprocessing, calculations, analysis, and visualization to report writing and automation. It covers responsive dashboards, data preprocessing, AI-assisted macro coding, the latest Excel functions and features, Copilot, and Python in Excel, expanding Excel use from traditional applications into the AI era.

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

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

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)