پیشنهاد فرادرس

آموزش برنامه ریزی و تحلیل سناریو با Excel 

دسته بندی ها: آموزش اکسل ، آموزش های لیندا (Lynda) ، آموزش آفیس
به این نوشته امتیاز دهید 1 2 3 4 5 بدون امتیاز
Excel: Scenario Planning and Analysis Publisher:Lynda Author:Curt Frye Duration:2h 7m Level:Intermediate

Explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel.
Released: 11/28/2017

A multitude of factors can affect the trajectory of your business. Learning how to document, summarize, and present projected business scenarios can help provide a basis for insightful business analysis, and help you evaluate the impact of various choices on your organization. In this course, explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel. The course starts with a chapter on the art and craft of scenario planning before turning to the technical capabilities of Excel. Tools covered include row grouping to show and hide detail, PivotTables, and functions for using the normal distribution.

Topics include:
Designing a scenario-planning exercise
Estimating scenario plausibility and outcomes
Establishing parameter value ranges
Calculating the standard deviation of a dataset
Indicating the probability of a scenario value occurring
Walking through a scenario presentation
Performing retrospective analysis using a PivotTable
Changing PivotTable summary operations

Introduction
Welcome
1m 3s
Using the exercise files
46s
1. Introducing the Art of Scenario Planning
Describe scenarios and scenario planning
5m 24s
Explore the link between scenarios and storytelling
5m 22s
Design a scenario-planning exercise
3m 53s
Estimate scenario plausibility and outcomes
5m 57s
2. Manage Scenarios in Excel
Define scenarios using static values
7m 52s
Define scenarios using percentages of base values
6m 53s
Select scenarios using data validation rules
4m 20s
Show and hide details by grouping worksheet rows
4m 3s
Walk through a scenario presentation
4m 1s
3. Establish Parameter Value Ranges
Introduce the normal distribution
3m 50s
Calculate the standard deviation of a dataset
6m 57s
Indicate the probability of a scenario value occurring
6m 48s
Estimate values using the triangular distribution
11m 19s
Walk through a scenario presentation
3m 31s
4. Present Scenarios Using PivotTables
Define PivotTable dataset
6m 23s
Create and pivot a PivotTable
5m 30s
Summarize PivotTable data using subtotals and grand totals
4m 22s
Filter PivotTable data
5m 10s
Change the values area summary operation
5m 55s
Record a macro to recreate a PivotTable position
6m 37s
Link a macro to a shape
6m 27s
Walk through a scenario presentation
3m 46s
Conclusion
Next steps
1m 16s

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 228.0MB همراه با زیرنویس انگلیسی Lynda Excel Scenario Planning and Analysis_git.ir.rar