The ultimate Excel course for mastering real-world business skills!
dymanagementlab
This is about practical Excel training for use at work. It's completely focused on practical Excel skills for the workplace.
초급
Excel
For those who work in cost accounting at a company, those who are preparing to start a business, or those who run a small or medium-sized business, I will easily explain the concept of cost.
23 learners


cost price
Break-even point
Performance evaluation
Business plan
Cost accounting
(Director Ryu Dae-young, Ph.D. in Business Administration/Management Consultant (Finance))
YouTube: www.youtube.com/@dy-4714
N Blog : https://blog.naver.com/udae025
Email: daeyoung.lyu@gmail.com
I am Ryu Dae-young, who operates 'DY Management Research Institute' on YouTube and Naver Blog.
Based on my company experience and business administration studies, I want to help those working in related fields. I provide a very practical approach that can immediately help with cost accounting, management, accounting, finance, business planning, investment attraction, and overall business management. If you want to collaborate on the courses I've uploaded or in my areas of expertise, please contact me via email!
Management/cost consulting, business feasibility review, financial business plan development, management simulation, financial projection development for investment attraction.
Excel practical training, Excel data visualization, work efficiency improvement using Excel. We'll cut your work time in half.
I welcome lecture requests, work requests, and Q&A related to specialized fields and YouTube videos.
I recommend this course to those who have started related work at a company or want to expand their work scope through study. The reality is that you're given tasks at work, but no one teaches you and there's no proper place to learn.
If you're working but didn't major in cost/management accounting, you may have vague difficulties with this field. Even if you studied business administration, many of you probably have hazy memories of it.
Just by watching this one course, it will be very helpful for you to understand the overall management of a company to some extent. It covers everything from the basics of cost accounting to cost calculation, business planning, and performance evaluation.
I have been working in the fields of cost accounting, finance, management, and planning in corporations for 20 years. As a practitioner and manager in manufacturing cost management, I would like to share my experience and expertise with those who need it.
I will conduct a lecture on the matters that corporate cost management personnel should know.
1. What is Cost Management Accounting? : Definition of cost management accounting, differences between financial accounting and management accounting
2. Cost Concepts: Cost and Expense, Manufacturing Cost and Selling & Administrative Expenses, Three Elements of Cost, Flow of Manufacturing Costs, Manufacturing Cost Statement, Types of Cost and Profit
3. Cost Calculation: Types of cost calculation, indirect cost allocation, predetermined cost vs. actual cost calculation, cost calculation flow (Excel examples)
4. Estimation and Analysis of Costs and Profits: Fixed and Variable Costs, CVP Analysis (Cost-Volume-Profit Analysis), Volume-Contribution Margin Analysis
5. Business Plan : What is a Business Plan?, Business Plan Process, Role of Business Plan, Business Plan Examples (Excel Examples)
6. Performance Evaluation: Management Cycle, What is Performance Evaluation?, Purpose of Performance Evaluation, Strategic Goals and KPIs, Balanced Scorecard (BSC), KPI Selection Principles
7. Profitability Analysis: Profitability Analysis Process, Profitability Analysis Request Form, Profitability Analysis Calculation Standards, Profitability Analysis Results
※ When you purchase this course, you will receive the course materials (PDF) along with the Cost Flow (Excel) and business plan examples (Excel). The Excel files will be very helpful for practical work.
- Manufacturing company employees: All staff including finance department, sales, marketing, production management, etc.
- Those working in sales/marketing who need to understand cost concepts
- Those who have management responsibility for the overall company operations in small and medium-sized enterprises
- For finance department employees who need cost knowledge: Cost closing process
- Those who are studying cost accounting
- Those curious about cost accounting practices
Through this course, you can learn what cost is and how actual companies calculate costs.
Cost calculation methods differ according to the characteristics of companies, and you can learn about each cost calculation method.
You can also learn about methods for business planning, performance evaluation, and profitability analysis.
※ The following shows an excerpt from part of the curriculum.
Who is this course right for?
Cost Accounting Manager
Someone preparing to start a business
SME Manager
150
Learners
17
Reviews
5
Answers
4.7
Rating
16
Courses
유튜브와 N블로그에서 'DY경영연구소'를 운영하고 있는 류대영입니다.
제가 회사에서 경험한 것과 공부한 것을 바탕으로 관련 실무하시는 분들께 도움을 드리고자 합니다. 원가, 관리, 회계, 재무 사업계획, 투자유치, 경영 전반에 걸쳐 굉장히 실무적으로 바로 도움드릴 수 있는 접근을 해드립니다.
유튜브 DY경영연구소 : www.youtube.com/@dy-4714
네이버블로그 DY경영연구소 : https://blog.naver.com/udae025
※ 전문분야 :
경영/원가컨설팅, 사업성검토, 재무 사업계획 수립, 경영 시뮬레이션, 투자유치 위한 재무프로젝션 수립.
엑셀 실무교육, 엑셀 활용 데이터 시각화, 엑셀을 활용한 업무효율화. 작업시간을 반으로 줄여드립니다.
전문분야 및 유튜브 영상 관련하여 강의/.작업요청/Q&A환영합니다.
All
8 lectures ∙ (3hr 10min)
Course Materials:
1. Course Introduction
02:03
All
2 reviews
5.0
2 reviews
Reviews 4
∙
Average Rating 5.0
Edited
5
This was a very beneficial lecture that covers the overall flow of cost management accounting practices and also includes how to create Excel business plans! It's a lecture that contains both theory and actual practical work, and it serves as a good guide for those who are not familiar with cost management accounting. Thank you so much for kindly answering my questions!
Thank you for the good evaluation and review. I hope my lecture helped you grasp the concepts of cost management accounting. The Excel materials provided together will be very helpful for practical application. Thank you very much for taking the course.
Reviews 6
∙
Average Rating 5.0
5
I was really overwhelmed when I was put in charge of cost management accounting at my company.. But after taking this lecture, I was definitely able to get a good grasp of it. The instructor seems to have a lot of practical experience and does a great job of pinpointing the key points and explaining them well to fit practical work. The Excel materials provided were also very helpful in understanding complex cost flows. The business plan Excel materials were also very helpful in understanding and establishing business plans. Thank you so much. This is truly the best lecture for this price.
Thank you for the evaluation and review. Cost management accounting plays a very important role in companies. I hope my lectures and materials have been helpful for your work at the company. Thank you.
$26.40
Check out other courses by the instructor!
Explore other courses in the same field!