LYNDA UP AND RUNNING WITH EXCEL WHAT IF ANALYSIS 視頻教學 英文教學版

　



　
軟體簡介:
　
Makebetterdecisionsforyourbusinessbytakingadeeperdiveintoyour
datawithMicrosoftExcel'sanalysistools.Inthisadvancedcourse,Curt
Fryeshowshowtoanalyzehypotheticalbusinesscasesusingformulasand
variabledata.He'llshowyouhowtobuilddatatables,definealternative
datasetswithscenarios,findtargetvalueswithGoalSeek,andanalyze
complexproblemswithSolver.Thelasttwochaptersshowyouhowtocreate
aconfigurablemodelwithslidersandcheckboxesandhowtorunaMonte
Carlosimulation.

Topicsinclude:
‧Creatingascenario
‧Definingdatatables
‧FindingatargetvaluewithGoalSeek
‧DefiningconstraintsandrunningSolver
‧Creatingaconfigurablemodel
‧Manipulatingyourmodel
‧RunningaMonteCarlosimulation