Lets you create a report of simulation results by choosing from a gallery of predefined and custom report typesĬreates a report of only assumption resultsĬreates a report of only decision variable resultsĬreates a report of only forecast resultsĬreates a report of all simulation resultsĬreates a report of only Crystal Ball data cell names and locations Opens associated charts for selected cells Opens Predictor charts following a time series forecast If OptQuest is available, opens OptQuest charts following an optimization Opens the Scatter Charts dialog so you can display or manage scatter charts Opens the Trend Charts dialog so you can display existing or create new trend charts Opens the Overlay Charts dialog so you can display existing or create new overlay charts Opens the Sensitivity Charts dialog so you can display existing or create new sensitivity charts Opens the Forecast Charts dialog so you can display or manage forecast charts Opens the Assumption Charts dialog so you can display or manage assumption charts Offers a gallery of charts and chart window management commands use the Down arrow (Ø) to choose a specific chart Table 18. Crystal Ball Analyze Commands, Microsoft Excel 2007 or Later Opens the Cell Preferences dialog to change the appearance and other properties of Crystal Ball data cells Selects specified Crystal Ball data cellsĮxcludes specified Crystal Ball data cells from a simulation Selects all forecast cells on the active worksheet
Selects all decision variable cells on the active worksheet Selects all assumption cells on the active worksheet Offers the Select menu, to select assumption, decision variable, and forecast cells Removes Crystal Ball cell definitions from specified cells
Pastes copied Crystal Ball cell definitions into specified cells Opens the Define Forecast dialog to define a Crystal Ball forecast cellĬopies Crystal Ball cell definitions to specified cells
Opens the Define Decision Variable dialog to define a Crystal Ball decision variable cell Opens the Define Assumption dialog to define a Crystal Ball assumption cell The following table contains Excel shortcuts you might use daily to maintain records, perform calculations, and more.Table 16. Crystal Ball Define Commands, Microsoft Excel 2007 or Later Are there any keyboard shortcuts for Microsoft PowerPoint?įirst, let us have a look at the most frequently used Microsoft Excel shortcut keys. Will these keyboard shortcuts work in Microsoft Excel 2007?
Can I create a custom keyboard shortcut in Microsoft Excel?
0 kommentar(er)
