Mastering Excel for Business: The Complete Course!
dymanagementlab
We are conducting a practical Excel course for workplace use. This is a fully hands-on, business-oriented Excel training.
Basic
Excel
A professional with 20 years of experience in business management explains everything from A to Z about practical management using Excel. We provide videos along with business management Excel templates that can be used immediately in the workplace. By using Excel while watching the videos, you can instantly implement the essential management tools required for running a company.
22 learners
Level Basic
Course period Unlimited


Reviews from Early Learners
5.0
lilica8002
This is truly helpful material for actual company work. You mentioned having over 20 years of experience... You really explained company management and administration practices from A to Z using Excel comprehensively. With just this one material, it seems like you could easily start everything from cost flow, expense analysis, financial ratio analysis, break-even point analysis, to valuation. This is absolutely excellent!!!
5.0
Brian Lee
It was very helpful for my practical work as it allowed me to effectively review things I already knew all at once, helping me organize them systematically.
5.0
tokio7979
They say a thirsty person is the one to dig the well, but I feel like I've discovered a vast lake. I believe anyone who isn't in the finance department but has encountered management accounting out of necessity will agree that you put a tremendous amount of thought into making everything—from the lectures to the condensed materials—easy to understand. I was particularly struggling with how to express cost reduction in accounting terms, and this was truly a huge help. Thank you!!
Business Management
Financial Statements
Accounting treatment
BEP analysis
Financial Ratio Analysis
Expense Analysis
Processing Cost Analysis
(Director Dae-young Lyu, Ph.D. in Business Administration / Certified Management Consultant (Finance))
YouTube : www.youtube.com/@dy-4714
N Blog: https://blog.naver.com/udae025
Email : daeyoung.lyu@gmail.com
I am Daeyoung Lyu, and I run 'DY Management Research Institute' on YouTube and N Blog.
Based on my corporate experience and studies in business administration, I aim to provide practical assistance to professionals in related fields. I offer highly practical approaches that can be applied immediately across costing, management, accounting, financial business planning, investment attraction, and general management. If you are interested in my lectures or wish to collaborate within my areas of expertise, please contact me via email!
Management/cost consulting, feasibility studies, financial business planning, management simulation, and financial projections for fundraising.
Practical Excel training, data visualization using Excel, and business efficiency through Excel. We will cut your work time in half.
I welcome inquiries regarding lectures, project requests, and Q&A related to my areas of expertise and YouTube videos.
This course consists of lecture videos created by digitizing highly practical elements essential for company operations and business tasks into Excel. It will likely serve as an indispensable resource package for working professionals and SME (Small and Medium Enterprise) owners.
Due to the large volume of materials and lectures, I have divided them into two parts.
It consists of Practical Business Management Learned through Excel Part-I & Part-II.
This course is divided into three parts.
One free video is provided for each part. Please be sure to watch the free videos before making a purchase.
- Purchase of Raw Materials > Input of Raw Materials > Input of Processing Costs > Costs → Input to Work-in-Process > Completion of Finished Goods > Goods Issue > Sales Billing > Collection of Receivables > Incurrence of SG&A Expenses
I will explain how the manufacturing cost flow, adjusted trial balance, income statement, and balance sheet are created through the business processes mentioned above.
Many office workers often only know about the specific tasks they handle within the company.
If you gain an understanding of how the company's overall processes flow through these Excel materials and lectures, your perspective on corporate life will broaden significantly.
In particular, we help individuals in non-accounting roles—such as sales, logistics, and production management—develop a holistic perspective of the entire business.
We provide explanations and Excel templates for various management methods practically required for company operations.
By adapting the Excel templates to suit your company's specific needs, you will be able to easily improve your organization's management standards.
Due to the large volume of materials and lectures, I have divided them into two parts.
The following is the content for the product "Practical Business Management Learned through Excel Part-II."
We explain business management approaches to the decision-making processes required in running a company. By using the provided videos and Excel templates, you will be able to easily apply these methods to your own company immediately.
By purchasing this set of materials, your management know-how will instantly level up. I highly recommend this as essential material for financial managers, such as CFOs and heads of management planning teams.
Who is this course right for?
Business Management
Financial Management
SME CEO
Preparing for a startup
Need to know before starting?
Basic Accounting
260
Learners
31
Reviews
5
Answers
4.6
Rating
16
Courses
I am Daeyoung Ryu, and I run 'DY Management Research Institute' on YouTube and Naver Blog.
Based on my professional experience and studies, I aim to provide practical assistance to those working in related fields. I offer highly hands-on approaches that can be immediately applied across various areas, including costing, management, accounting, financial business planning, investment attraction, and overall business management.
I am here to help. I provide highly practical and immediate solutions across cost accounting, management, accounting, financial business planning, investment attraction, and overall business management.
YouTube DY Management Research Institute: www.youtube.com/@dy-4714
Naver Blog DY Management Research Institute: https://blog.naver.com/udae025
※ Areas of Expertise:
Management/cost consulting, feasibility studies, financial business planning, management simulation, and financial projections for investment attraction.
Practical Excel training, data visualization using Excel, and improving work efficiency through Excel. I will cut your working time in half.
I welcome inquiries regarding lectures, project requests, and Q&A related to my areas of expertise and YouTube videos.
Data visualization and business efficiency using Excel. I will cut your work time in half. I welcome requests for lectures, projects, and Q&A regarding my areas of expertise and YouTube videos.
All
10 lectures ∙ (2hr 27min)
Course Materials:
1. Introduction
03:16
All
5 reviews
4.2
5 reviews
Reviews 2
∙
Average Rating 5.0
5
They say a thirsty person is the one to dig the well, but I feel like I've discovered a vast lake. I believe anyone who isn't in the finance department but has encountered management accounting out of necessity will agree that you put a tremendous amount of thought into making everything—from the lectures to the condensed materials—easy to understand. I was particularly struggling with how to express cost reduction in accounting terms, and this was truly a huge help. Thank you!!
I feel a deep sense of fulfillment and responsibility at the same time from your generous praise, comparing my work to "a thirsty person finding a vast lake." I am truly glad that my lectures and materials could quench your thirst for understanding how to reflect cost reduction from an accounting perspective, especially since you are not a finance major. In practical work, developing a managerial accounting mindset is like gaining a map after sailing the sea without a lighthouse. I sincerely hope that the intensive materials I have carefully prepared will serve as a powerful weapon in your professional field. Please feel free to leave any questions you may have while studying. Thank you!
Reviews 6
∙
Average Rating 5.0
5
This is truly helpful material for actual company work. You mentioned having over 20 years of experience... You really explained company management and administration practices from A to Z using Excel comprehensively. With just this one material, it seems like you could easily start everything from cost flow, expense analysis, financial ratio analysis, break-even point analysis, to valuation. This is absolutely excellent!!!
Hello, **[Student Name]**. I am Director Daeyoung from the DY Management Research Institute, the instructor for this course. I would like to express my deepest gratitude for recognizing my 20 years of practical experience and for highly valuing the Excel materials I painstakingly designed. It is incredibly rewarding to feel that my sincerity in trying to capture the 'A to Z' of practical business—from cost flow to break-even points and valuation—has become a reliable compass for lilica8002's work in the field. Beyond being a simple tool, I sincerely hope these materials become a powerful weapon for you to lead key organizational decision-making in the future. Please feel free to ask any questions you may have during your studies. Thank you!
Reviews 1
∙
Average Rating 5.0
Edited
5
It was very helpful for my practical work as it allowed me to effectively review things I already knew all at once, helping me organize them systematically.
These are materials and videos I created to explain practical work easily based on my studies and experience. I hope they will be helpful for your work. Thank you.
Reviews 1
∙
Average Rating 5.0
5
Hello. Thank you for taking my course. If you have any questions while studying, please leave them here and I will provide you with an answer.
Reviews 1
∙
Average Rating 1.0
1
Class quality isn't good. Total waste of money, fr.
Jena, hello. It is very regrettable that the material I compiled from my experience and know-how didn't meet your expectations. It seems that the product, which I carefully crafted and sell, might not be a good fit for you. It would be best if you could request a refund. If, for various reasons, a refund is difficult, please contact me separately, and I will assist you. (010-5815-1425)
Check out other courses by the instructor!
Explore other courses in the same field!