강의

멘토링

커뮤니티

Business & Marketing

/

Management

Practical Management Learned Through Excel! A-Z (Part-II)

A person with 20 years of experience in business management explains everything from A to Z of practical business management using Excel. We provide videos and Excel templates for business management that can be used immediately in your company. If you use Excel while watching the video, you can immediately use the business management tools necessary for company operation.

10 learners are taking this course

Level Basic

Course period Unlimited

  • dymanagementlab
Management
Management
Financial Management
Financial Management
CFO
CFO
Accounting
Accounting
Management
Management
Financial Management
Financial Management
CFO
CFO
Accounting
Accounting

What you will gain after the course

  • Cost management

  • Valuation

  • Investment Evaluation

  • Cost reduction

  • Processing cost analysis

  • Inventory management

  • Investment Feasibility Assessment

  • Business Valuation

  • Valuation

  • Management decision-making

DY Management Research Institute

(Director Ryu Dae-young, Ph.D. in Business Administration/Management Consultant (Finance))

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 management. If you want to collaborate on the lectures I've uploaded or in my areas of expertise, please contact me via email!


※ Area of Expertise:

  • 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.




This course was created by compiling Excel materials into instructional videos covering highly practical aspects needed for company operations or business tasks. This will likely be an essential resource package for working professionals and small to medium-sized business owners.


I divided it into two parts because there is a large amount of materials and lectures.

It consists of Practical Business Management with Excel Part-I & Part-II.





***** Practical Business Management with Excel Part-I ******


This course is divided into three parts.

One free video is provided for each part. Please be sure to refer to the free videos before making a purchase.



I. Understanding Business Processes Through Accounting Treatment


1. Process-1 (Raw Material Purchase > Manufacturing > Sales)


- Raw material purchase > Raw material input > Processing cost input > Cost → Work-in-process input > Product completion > Product shipment > Sales billing processing > Accounts receivable collection > SG&A expenses incurred

Through the above business operations, I will explain how the manufacturing cost flow, trial balance, income statement, and balance sheet are created.




2. Process-2 (Equipment Purchase, Interest Expense, Corporate Tax Added)

3. Process-3 (Startup, Dividend Addition)

4. Process-4 (Inventory, Receivables, etc. Receipts and Disbursements): Inventory Asset Receipt and Disbursement Statement


Many office workers often only know about the tasks they perform at their company.

Through this Excel data and lectures, if you understand how the entire company process flows, your perspective on corporate life will become much broader.

In particular, we help people in non-accounting positions such as sales, logistics, and production management develop a holistic perspective.



II. Business Analysis


We provide explanations of various management methods needed for practical company operations and offer Excel templates.

The Excel template can be used according to the buyer's company, which will easily improve the company's management level.


1. Break-Even Point Analysis (BEP Analysis)

2. Financial Ratio Analysis

3. Manufacturing Cost Analysis: Variable Cost Analysis (Quantity Variance, Unit Variance, Price Variance)

4. Unit Processing Cost Analysis




Due to the large amount of materials and lectures, I have divided them into two parts.

The content below is for the "Practical Business Management with Excel Part-II" product.


***** Practical Business Management with Excel Part-II ******



5. Support Department Cost Allocation

6. Overhead Allocation and Processing Costs by Product

7. Cost Reduction Indicators and Performance Aggregation

8. Inventory Management and Inventory Valuation




III. Management Decision Making


I will explain the business management approach to decision-making that needs to be made while running a company. As always, using the provided video and Excel templates, you will be able to easily apply them directly to your company right away.

By purchasing this material SET, your management know-how will be upgraded to the next level. I highly recommend this as essential material for financial managers such as CFOs and management team leaders.


1. Investment Feasibility Analysis

2. Estimating Cost of Equity and Weighted Average Cost of Capital

3. Corporate Valuation

4. Price-to-Earnings Ratio (PER), Price-to-Book Ratio (PBR)

5. Make or Buy (In-house Production or Outsourcing)

6. Sell or Not (To Sell or Not to Sell?)




Recommended for
these people

Who is this course right for?

  • Business management

  • Financial Management

  • Small business owner

  • Starting a business

Need to know before starting?

  • Basic Accounting

  • Practical Business Management with Excel! A-Z (Part-I)

Hello
This is

169

Learners

18

Reviews

5

Answers

4.5

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.

Curriculum

All

12 lectures ∙ (2hr 38min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$51.70

dymanagementlab's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!