강의

멘토링

커뮤니티

Business & Marketing

/

Management

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

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.

(3.7) 3 reviews

16 learners

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

Reviews from Early Learners

Reviews from Early Learners

3.7

5.0

lilica8002

67% enrolled

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!!!

What you will gain after the course

  • Business Management

  • Financial Statements

  • Accounting treatment

  • BEP analysis

  • Financial Ratio Analysis

  • Expense Analysis

  • Processing Cost Analysis

DY Management Research Institute

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

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!


※ Areas of Expertise:

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





***** 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 watch the free videos before making a purchase.



I. Business Processes Understood Through Accounting Treatment


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


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




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

3. Process-3 (Adding Startup, Dividends)

4. Process-4 (Receipts and disbursements of inventory, receivables, etc.): Inventory movement ledger


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.



II. Business Analysis


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.


1. Break-Even Point Analysis (BEP Analysis)

2. Financial Ratio Analysis

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

4. Processing Cost per Unit Analysis




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


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



5. Cost Accounting for Support Departments

6. Expense Allocation and Processing Costs by Product

7. Cost Reduction Indicators and Performance Tracking

8. Inventory Management and Inventory Valuation




III. Managerial Decision Making


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.


1. Investment Feasibility Analysis

2. Estimation of Cost of Equity and Weighted Average Cost of Capital (WACC)

3. Business Valuation

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

5. Make or Buy (In-house or Outsource)

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




Recommended for
these people

Who is this course right for?

  • Business Management

  • Financial Management

  • SME CEO

  • Preparing for a startup

Need to know before starting?

  • Basic Accounting

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

10 lectures ∙ (2hr 27min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

3.7

3 reviews

  • kmhoon896105님의 프로필 이미지
    kmhoon896105

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • lilica80027743님의 프로필 이미지
      lilica80027743

      Reviews 6

      Average Rating 5.0

      5

      67% enrolled

      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!!!

      • syj0103025035님의 프로필 이미지
        syj0103025035

        Reviews 1

        Average Rating 1.0

        1

        78% enrolled

        Class quality isn't good. Total waste of money, fr.

        • dymanagementlab
          Instructor

          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)

      Limited time deal

      $39.60

      23%

      $51.70

      dymanagementlab's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!