A must-have for office workers! Master Excel from A to Z, covering versions 2019 to the latest 2026.
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.
Perfect mastery of all core menus and manuals from Excel 2019 to the latest 2026 version
Essential function application and data processing skills for practical work that reduce simple repetitive tasks by 10 times.
⏱️ From tedious overtime to a top-tier Excel expert who finishes work in just 3 minutes!
"The ultimate Excel practical cheat key that covers everything from basics to macro automation in a single course"
Are you still working late in front of your monitor, struggling with mysterious formula errors every time? It's time to put an end to meaningless time wasting.
We have compressed 14 years of field-proven know-how from a Business MVP, verified by global corporations and major public institutions, into one single course.
- 📊 A comprehensive manual with 109 lectures - 🗺️ A systematic build-up curriculum across 15 sessions - ⏱️ An overwhelmingly condensed guide finished in just 7 hours and 30 minutes
From users of older Excel versions (2019) to those who want to master the cheat keys of the latest 2026 version, we instill a powerful 'practical self-sufficiency' to solve problems on your own in any environment. Now, experience the confidence of leaving work on time!
🎓 The one and only master to save your time, Edupick CEO Shin Eui-hyun
"Who you learn from determines your self-sufficiency in Excel."
Check out the know-how of a true expert who has educated countless professionals and majors in proven fields such as global corporations, public institutions, and university lecture halls.
- 🌐 Internationally Certified Trainer: Apple Authorized Trainer / Avid Certified Instructor - 🏛️ Public Institution & Major Corporation Lectures: KBS Training Center, Korea Creative Content Agency (KOCCA), POSCO ICT, Hyundai Home Shopping, RAPA, KOBACO, etc. - 🏫 Prestigious University Education History: Practical lectures at Sejong University, Woosong University, Ajou University, Sangmyung University, Dongguk University Media Act, Chonbuk National University, Hanshin University, etc. - 📚 Field Experience & Bestselling Author: DI Team Leader for the movie 'Glove', Drama Technology Team Leader at OBS / Bestselling author of business content
We deliver only 'truly useful practical techniques' refined through numerous field experiences and employee training, rather than lectures biased toward theory.
⏱️ Just 7 hours and 30 minutes, the time it takes to go from an Excel beginner to a practical master
We have designed the most efficient build-up roadmap for busy professionals. Instead of long, tedious lectures, we condense the core essentials into just 15 sessions and a total of 109 lessons (averaging 30 minutes) to help you perfectly master practical tasks.
Just follow this systematic 3-step curriculum. We will wide open the high, firmly locked walls of Excel for you.
🛠️ [Sessions 1 & 2] Building the Foundation of Excel and Completing 1-Second Execution Tools (Lectures 1~15)
"Are you still clicking your mouse dozens of times every time just to find a hidden menu?"
This is the stage where you understand the basic structure of Excel and build your own optimized environment. Through custom settings that minimize mouse movement, you will reduce your work speed to the '0-second' range.
- 📁 Understanding the Structure (Lectures 1-4): Mastering UI/UX menu usage and the basic structure of workbooks - 🖱️ Optimizing Movement (Lectures 6-7): Secrets of the mouse pointer and utilizing shortcut mini toolbars - 💾 Editing Techniques (Lectures 10-14): AutoFill and efficient data editing skills
[Before ➡️ After] End the days of rummaging through top tabs every time. Create a smart routine by pinning essential, frequently used functions to the top and accessing them instantly through Quick Access Toolbar (QAT) customization.
✨ [Session 3 & 4] The Magic of Core Formulas and Formatting (Lectures 16–31)
"Are you still doing manual labor, coloring cells by hand and tapping away at a calculator?"
This is the stage where you automate your sheets so they automatically generate insights from vast amounts of data based on rules. Organize text and numbers to complete the foundation of a well-structured report.
- 🧮 Formula Basics (Lectures 16-20): Perfect mastery of formulas from sums/averages to year-to-date profit and percentage increases - 📐 Layout Formatting (Lectures 24-30): Designing cell heights, text alignment, borders, and special formatting - 🔍 Conditional Formatting (Lecture 31): Techniques to automatically read hidden patterns and flows in data
[Before ➡️ After] Don't just 'read' numbers. The magic of data visualization begins here, allowing you to 'see' the highs and lows of data at a glance using rule-based formatting and copied formulas.
📊 [Session 5 & 6] Dynamic Data Control and Visual Objects (Lectures 32–43)
"Are you still rummaging through narrow filter menus every time just to pick out the information you want?"
This is the advanced layout build-up stage where you structure vast data sheets and control all data in real-time with a single button click.
- 🧮 Dynamic Data (Lectures 32-34): Creating dynamic tables and linking filter slicers - 📐 Visualization Layout (Lectures 35-36): Inserting visual objects like shapes and arrows to enhance report quality - 🔍 Data Advancement (Lectures 37-43): Mastering row/column control and advanced find/replace techniques
[Before ➡️ After] Don't get lost in your data. You will be able to build a smart dashboard environment where the entire table's data filters and reacts in real-time with a single intuitive slicer button.
"Have you ever been flustered because your tables were cut off or broken every time you hit the print button?"
This is the stage where you implement the perfect data seen on screen 100% identically on paper or in PDF reports without errors, while adding visual persuasiveness.
- 🖨️ Output Optimization (Lectures 44-48): A complete guide to Page Layout View and Print Preview settings - 📊 Advanced Charting (Lectures 49-55): Creating charts suitable for your data, selecting types, and advanced formatting of axes/labels - 📉 Micro-trends (Lectures 56-57): Utilizing Sparklines that are neatly inserted into cells to show trends
[Before ➡️ After] No more regrets after hitting the print button. A neatly organized print layout and cell-level Sparkline trends will elevate the quality of your reports to the next level.
⚡ [Session 9 & 10] Controlling Large Sheets and Essential Practical Functions (Lectures 58-73)
"Are you getting lost while scrolling through tens of thousands of rows of data, or manually comparing data with your own eyes?"
This is the stage where you will perfectly connect vast workbooks and master the three core practical functions to automatically merge scattered data all at once.
- ⚙️ Sheet Control (Lectures 58-61): Ensure readability of large sheets using Freeze Panes and Outlining features - 🔗 Data Linking (Lectures 66-68): Seamlessly link multiple worksheets/workbooks as one using formulas and expressions - ⚡ Essential Practical Functions (Lectures 69-73): The trinity of practical functions! Master IF, VLOOKUP, and COUNTIF
[Before ➡️ After] Stop straining your eyes and fingers. Experience the amazing transformation where countless scattered data points are automatically merged into a single master sheet without a single error through VLOOKUP and Freeze Panes.
🔒 [Lessons 11 & 12] Ironclad Security Settings and Advanced Data Filtering (Lectures 74~87)
"Have you ever had a formula you worked hard on get deleted or broken by someone else's mistake?"
This stage is about perfectly protecting your precious data during collaboration and neatly filtering out unnecessary duplicates from vast raw data in just one second.
- 🛡️ Ironclad Security (Lectures 74-78): Defending data formulas by unlocking cells, protecting worksheets/workbooks, and setting passwords - 👥 Safe Collaboration (Lectures 79-80): The Track Changes feature that shines when working with colleagues - 🔍 Advanced Filtering (Lectures 81-87): Advanced data sorting, subtotals, custom auto-filters, and removing duplicate data
[Key Points] Perfectly protect your precious formulas from colleagues' mistakes! By mastering sorting and subtotal techniques, you can smoothly pick out only the insights you want from tens of thousands of data points.
🗂️ [Session 13] The Ultimate Guide to Data Analysis: A Complete Breakdown of Pivot Tables (Lectures 88-97)
"Transform hundreds of thousands of rows of raw data into multi-dimensional reports without using a single function."
This stage allows you to summarize vast amounts of data with just a few mouse clicks and drags—no complex formula coding required—and generate the perfect cross-reports requested by executives in just 3 seconds.
- 🏗️ Understanding the Structure (Lectures 88-91): Mastering the creation of pivot tables and the complete mechanism of field structures - 📆 Group Optimization (Lectures 92-95): Modifying pivot data and handling date/time/other grouping settings - 📊 Chart Visualization (Lectures 96-97): Inserting pivot-exclusive slicers and creating intuitive pivot chart visualizations
[Key Points] Don't get lost in a pile of raw data. Once you master the pivot dashboard features, hundreds of thousands of rows of data will be reborn as multi-dimensional cross-reports that automatically radiate insights.
🎯 [Session 14] Virtual Analysis and Data Scenarios for Predicting the Future (Lectures 98~104)
"Equip yourself with the planner's weapon to derive optimal business solutions beyond simple statistics."
This stage involves back-calculating variables to achieve specific goals, such as 'achieving a 20% profit margin,' and simulating predictive data according to various business situations (Scenarios A, B, and C).
- 🔍 The Magic of Back-calculation (Lectures 98-99): Goal Seek to find the input value needed to obtain a desired result - 🎛️ Variable Control (Lectures 100-101): Using the Solver to control complex constraints and variables - 📊 Predictive Simulation (Lectures 102-104): How to use Scenario Manager and Virtual Analysis Data Tables
[Key Points] Don't write proposals based on vague guesses. By mastering virtual analysis tools, you will become a top-tier planner who derives accurate target data even amidst diverse business variables.
⚙️ [Session 15] The 1-Second Miracle: Perfect Control of Macros and Automation (Lectures 105–109)
"How much longer will you manually handle the repetitive formatting tasks that take 30 minutes every morning?"
This stage is about completely automating tedious routine tasks through a single recording and shortcut assignment. You will clearly master the differences between adding toolbar icons and inserting buttons within a sheet.
- ⚙️ Automation Mechanism (Lectures 105-106): Understanding the principles of macros and safe recording methods without errors - 🖱️ Customized Execution (Lectures 107-109): Creating simple macros and mastering the optimal execution methods for any situation
[Before ➡️ After] Experience the amazing miracle of finishing your work before you even take a sip of coffee, all with a single shortcut or shape button. Equip yourself with the automation cheat code to perfectly control everything from personal files to sheets shared with colleagues.
👑 Edupick's overwhelming course satisfaction, already proven by countless professionals
Edupick aims for optimal practical education that goes beyond simple functional delivery, enabling students to achieve immediate results in the field.
In addition to this [Top-tier Exceller] course presented on Inflearn, various business practical contents provided by Edupick have already received overwhelming satisfaction and praise from numerous junior employees and managers.
- 📈 Field-closely related examples: A 100% practical curriculum that you can use directly in your real work, not just a list of theories - ⏱️ Incomparable efficiency: A clear and compact compressed guide that saves the time of busy professionals - 💬 Real endorsements from seniors: Reliability proven by verified student reviews, from new employees leaving work on time to managers passing reports
The 'miracle of clocking out time' and work efficiency routines experienced by countless professionals will now be transplanted directly into your environment. Become a top-tier professional with Edupick's proven education!
Recommended for these people
Who is this course right for?
An office worker who wants to systematically master every manual, starting from the basic menu.
Those who want to handle documents freely regardless of the Excel version.