


Perfect hands-on practice examples provided.
Customized example files for each lesson.

From A to Z,
Building from the basics.
'Solid Basics' manual.

Why do you keep wandering in search of new lectures every time?
"Photoshop separately, Excel separately, video editing separately..."
Are you tired of ever-increasing tuition fees and fragmented knowledge?
Start first on Wadiz now!


"From planning to editing
All at once!
Graphic design &
Document office &
Video editing &
Motion graphics &
Even sound
15 types of content

For beginners,
'Zero learning barrier'
"For teachers creating class materials,ย
For students who want to improve the quality of their assignments,
Even for complete beginners who are unfamiliar with using a mouse,Anyone can"

All EduPick coursesLifetime pass,
Wadiz's first-ever50%
Exclusive launch!"


-------------------------------------------------------------------------------
๐ Click the video below
and watch a sample lecture first!
You need to see the true value of the lecture with your own eyes.

The very first program that most office workers open every day at work is'Excel'.
If you understand the basic structure of Excel,
no matter what data or error you encounter
Able to solve on your own
'Practical self-sufficiency' Is developed.
I am the CEO of Edufic Co., Ltd.
I am Shin Eui-hyun, a business MVP development expert with 15 years of experience.
In accordance with Wadiz's strict guidelines,
Instead of caricatures or AI-processed images,
I confidently present my actual portrait photo
And stand before our supporters.

Through conducting job training for executives and employees at global companies and major public institutions, I have accumulatedAll of my know-how Based on this,
I promise to provide reliable, high-quality educational content.

The time it takes to go from Excel beginner to practical master
โฑ๏ธ Just 7 hours and 30 minutes,
A total of 109 lectures
- ๐ Step 1. Beginner (Sessions 1~6): Mastering data fundamentals
- ๐ Step 2. Intermediate (Sessions 7~11): Optimizing functions & visualization
- ๐ Step 3. Advanced (Sessions 12~15): Data analysis & macro automation

๐ ๏ธ [Sessions 1 & 2] Building the framework of Excel and completing 1-second execution tools (Lectures 1~15)
Are you clicking your mouse dozens of times just to find hidden menus?
This is the stage where you understand the basic structure of Excel and build your own optimized environment. With custom settings that minimize mouse movement, you can reduce your work speed to 'zero seconds'.
- ๐ Structure Analysis (Lessons 1-4): Mastering UI/UX menu usage and the basic structure of workbooks.
- ๐ฑ๏ธ Workflow Optimization (Lessons 6-7): Secrets of the mouse pointer and using shortcut keys and the mini toolbar.
- ๐พ Editing Techniques (Lessons 10-14): AutoFill and efficient data editing skills.

โจ [Sessions 3 & 4] The Magic of Core Formulas and Formatting (Lessons 16~31)
Are you doing manual labor by coloring cells by hand and tapping away on a calculator?
This is the stage where you automate your sheets to generate insights from massive data according to rules. Organize text and numbers to lay the foundation for a well-structured report.
- ๐งฎ Formula Basics (Lessons 16-20): Perfectly master formulas for sum/average, year-to-date profit, and percentage increase.
- ๐ Layout Formatting (Lessons 24-30): Design cell height, text alignment, borders, and special formatting.
- ๐ Conditional Formatting (Lesson 31): Techniques to automatically detect hidden patterns and trends in data.

๐ [Sessions 5 & 6] Dynamic Data Control and Visual Objects (Lessons 32~43)
Are you constantly digging through narrow filter menus just to extract the information you want?
This is the advanced layout build-up stage where you structure massive data sheets and control all data in real time with a single button click.
- ๐งฎ Dynamic Data (Lessons 32-34): Creating dynamic tables and linking filter slicers.
- ๐ Visualization Layout (Lessons 35-36): Inserting visual objects such as shapes and arrows to enhance report completeness.
- ๐ Data Enhancement (Lessons 37-43): Advanced control of rows/columns and data find/replace.

๐ [Sessions 7 & 8] Perfect Report Printing and Chart Visualization (Lessons 44~57)
Have you ever been frustrated by tables getting cut off or broken every time you hit the print button?
This is the stage where you reproduce perfect on-screen data on paper or in PDF reports with 100% accuracy, adding visual persuasiveness.
- ๐จ๏ธ Print Optimization (Lessons 44-48): A complete guide to page layout view and print preview settings.
- ๐ Advanced Charting (Lessons 49-55): Creating charts suitable for your data, choosing types, and advanced formatting for axes/labels.
- ๐ Miniature Trends (Lessons 56-57): Using Sparklines that are neatly inserted into cells to show trends.

โก [Lessons 9 & 10] Managing Large Sheets and Essential Practical Functions (Lessons 58-73)
"Have you ever lost your way while scrolling through tens of thousands of rows, or compared data manually with your eyes?"
This is the stage where you perfectly connect massive workbooks and master the three core practical functions to automatically merge scattered data at once.
- โ๏ธ Sheet Control (Lessons 58-61): Securing readability of large sheets with Freeze and Outlining features.
- ๐ Data Linking (Lessons 66-68): Perfectly linking multiple worksheets/workbooks into one using formulas and functions.
- โก Essential Practical Functions (Lessons 69-73): The trinity of practical functions! Mastering IF, VLOOKUP, and COUNTIF.

๐ [Lessons 11 & 12] Ironclad Security Settings and Advanced Data Filtering (Lessons 74-87)
"Have your carefully crafted formulas ever been deleted or broken by someone else's mistake?"
This is the stage where you perfectly protect valuable data during collaboration and filter out unnecessary duplicates from massive raw data in just one second.
- ๐ก๏ธ Ironclad Security (Lessons 74-78): Safeguarding data formulas by unlocking cells, protecting worksheets/workbooks, and setting passwords.
- ๐ฅ Secure Collaboration (Lessons 79-80): The Track Changes feature that shines when working with colleagues.
- ๐ Advanced Filtering (Lessons 81-87): Advanced data sorting, subtotals, custom auto filters, and removing duplicate data.

๐๏ธ [Lesson 13] The Ultimate in Data Analysis: A Complete Dissection of Pivot Tables (Lessons 88-97)
"You can convert hundreds of thousands of rows of data into multidimensional reports without using a single function."
This is the stage where you summarize massive data with just a few mouse clicks and drags, and generate perfect cross reports required by executives in just three seconds, all without complex formula coding.
- ๐๏ธ Understanding the Structure (Lessons 88-91): Grasping the complete mechanism of creating pivot tables and their field structures.
- ๐ Group Optimization (Lessons 92-95): Handling pivot data editing and setting up grouping for dates, times, and others.
- ๐ Chart Visualization (Lectures 96-97): Insert pivot-specific slicers and create intuitive pivot chart visualizations.

๐ฏ [Session 14] Virtual Analysis and Data Scenarios for Predicting the Future (Lectures 98~104)
"Equip yourself with the planner's tools 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 for various management scenarios (Scenario A, B, C).
- ๐ The Magic of Back Calculation (Lectures 98-99): Goal Seek to find input values for desired results.
- ๐๏ธ Variable Control (Lectures 100-101): Find solutions that control complex constraints and variables (Solver).
- ๐ Predictive Simulation (Lectures 102-104): How to use Scenario Manager and Data Tables for virtual analysis.

โ๏ธ [Session 15] The Miracle of One Second: Perfect Control of Macros and Automation (Lectures 105~109)
"How long will you keep doing repetitive formatting tasks for 30 minutes every morning by hand?"
This stage fully automates tedious routine tasks with a single recording and shortcut assignment. You will master the differences between adding toolbar icons and inserting buttons within sheets.
- โ๏ธ Automation Mechanism (Lectures 105-106): Understand the principles of macros and safe, error-free recording methods.
- ๐ฑ๏ธ Customized Execution (Lectures 107-109): Perfectly master simple macro creation and optimal execution methods for each situation.





๐ Course satisfaction already proven by countless professionals.
EduPick goes beyond simply delivering functions,
so that students can achieve immediate results in the workplace,
with the optimalpractical trainingas our goal.

During the project period,
try participating in the events/support pledges below.
EVENT 1.Support Signature & Notify Me Event
After completing [Notify Me] and [Support Signature] for this project,
all supporters who leave a verification comment in the community will receive a practical copy-paste-ready
[Essential Shortcuts & Cheat Sheet PDF Guidebook for Office Workers] free of charge along with the Reward.




EDUPIC
