وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel: Using Solver for Decision Analysis

سرفصل های دوره

You can use Excel's Solver function to find optimal solutions to a wide range of problems, from simple to complex. In this course, Excel power user Curt Frye shows you how, with a wide range of potential challenges. Curt explains the basics of working with Solver and gives you a chance to create a Solver model. He steps through how to tune investment portfolios, then goes over the specific approach that you need to use Solver for resource placement analysis. Plus, Curt covers the process of decision tree analysis in Excel.


01 - Introduction
  • 01 - Optimize your analysis in Excel
  • 02 - What you should know before starting

  • 02 - 1. Working with Solver
  • 01 - Find target values using Goal Seek
  • 02 - Introduce linear, nonlinear, and evolutionary programming
  • 03 - Install the Solver add-in on Windows
  • 04 - Organize a worksheet for use in Solver
  • 05 - Find a solution using Solver
  • 06 - Challenge Create a Solver model
  • 07 - Solution Create a Solver model

  • 03 - 2. Tuning Investment Portfolios
  • 01 - Introduce the problem
  • 02 - Organize the worksheet
  • 03 - Create objective and control formulas
  • 04 - Create and run the Solver model
  • 05 - Experiment with different constraints
  • 06 - Challenge Tune an investment portfolio
  • 07 - Solution Tune an investment portfolio

  • 04 - 3. Optimizing Resource Placement
  • 01 - Introduce the problem
  • 02 - Organize the worksheet
  • 03 - Map store and depot locations
  • 04 - Create objective and control formulas
  • 05 - Create and run the Solver model
  • 06 - Extend the model by adding population density
  • 07 - Challenge Optimize resource placement
  • 08 - Solution Optimize resource placement

  • 05 - 4. Defining Decision Trees
  • 01 - Introduce the problem
  • 02 - Organize the worksheet
  • 03 - Calculate the probability of reaching a node
  • 04 - Calculate the expected value for the tree
  • 05 - Challenge Define a decision tree
  • 06 - Solution Define a decision tree

  • 06 - Conclusion
  • 01 - Additional resources
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 2778
    حجم: 279 مگابایت
    مدت زمان: 114 دقیقه
    تاریخ انتشار: 28 دی 1401
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید