강의

멘토링

커뮤니티

Business & Marketing

/

Management

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

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 business management Excel templates that can be used immediately in your company. If you use Excel while watching the video, you can immediately use the business management TOOL necessary for company operation.

(3.7) 3 reviews

16 learners

  • dymanagementlab
Management
Financial Management
CFO
Accounting

Reviews from Early Learners

What you will gain after the course

  • Business management

  • Financial statements

  • Accounting procedures

  • BEP analysis

  • Financial Ratio Analysis

  • Cost analysis

  • Processing cost analysis

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 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?)




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?

  • Accounting Basics

Hello
This is

156

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환영합니다.

 

Curriculum

All

9 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 ends in 7 days

      $46,200.00

      30%

      $51.70

      dymanagementlab's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!