Master Decision making with Excel

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

Unleash Advanced Excel for Business decision making. Master Sensitivity analysis, scenario comparisons & Excel solver.

0 - Goal seek calculate the Value needed to Achieve the Goal

1 - Goal seek calculate the Value needed to Achieve the Goal

1 - Goal-Seek.xlsx

1 - Excel WhatIf analysis data tables compare possible outcomes with variables

2 - Data-for-single-input-table.xlsx

2 - Understand Excel whatif analysis Data Table set up and Variable

3 - Excel whatif analysis data table with single Input and single output

3 - Single-input-table.xlsx

4 - Excel whatif analysis data table with single Input and multiple outputs

4 - single-input-table-Multiple-output.xlsx

5 - Analyze interest and down payment with Excel whatif analysis data table

5 - Double-input-table.xlsx

6 - Double-Input-table-example.xlsx

6 - Get desired profit with correct combination of price and sale using data table

2 - excel whatif analysis scenario manager How to choose the best scenario

7 - Scenario.xlsx

7 - Understand Excel whatif analysis scenario manager & How to create scenarios

8 - Use excel whatif analysis scenario manager to generate various alternatives

9 - Summary report using excel whatif analysis scenario manager for Comparison

3 - Understand Powerful Excel Solver in Excel whatif analysis

10 - Excel-Solver.xlsx

10 - Introduction to extremely powerful tool Excel solver in whatif Analysis

11 - How to use constraints to Achieve goals Excel WhatIf Analysis Excel Solver

12 - Data Analysis and Decision making using Excel WhatIf Analysis Excel Solver

4 - Excel Solver for Portfolio Management Profit maximization and Optimization

13 - How to find optimized solution Transport Optimization problem with Excel Solver

13 - Transportation-Optimization-1.xlsx

13 - Transportation-Optimization-2.xlsx

14 - Book1-1.xlsx

14 - Profit maximization using Excel WhatIf Analysis Excel solver

15 - Portfolio Managementfunds allocation using Excel WhatIf Analysis Excel solver

15 - Portfolio-Management-excel-solver.xlsx

5 - Bonus Section

16 - Powerful Excel Gantt charts Effortless Project Management

16 - Powerful Excel Gantt charts Effortless Project Management.txt

16 - excel-gantt-chart-2.zip

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy