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

DY Management Research Institute

(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 professionals working in related fields. I provide very practical approaches 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!

※ Areas 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 > Selling and administrative expenses incurred

Through the above business operations, I will explain how the manufacturing cost flow, trial balance, income statement, balance sheet, and other financial statements 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.

If you understand how the entire company process flows through this Excel data and lectures, your perspective on corporate life will broaden significantly afterward.

It especially helps people in non-accounting positions such as sales, logistics, and production management develop a perspective to see the big picture.

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

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

The content below is from 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 video and the provided Excel template, you will be able to easily apply it directly to the buyer's company.

Purchasing this material SET will simultaneously upgrade your management know-how 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?)