Your Cart Is Empty
Home > Desktop Applications > Excel > Excel Forecasting and What-If Analysis
Using Scenarios, Solver, and Data Tables, you will develop complex models that incorporate What-If Analysis, as well as project and customize forecasts and trend lines.
Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced feature allows you to access huge data sets within Excel.
Category
ID
Duration
Level
Price
Excel
13765
1 Day(s)
Advanced
$595.00
Objectives
Upon successful completion of the Power BI Introduction for Excel Users Training course, you will be able to:• Understand and use the Forecast Sheet• Use the Quick Analysis Tool• Use What-If Analysis with Scenarios, Data Tables and Goal Seek• Work with the Solver Tool• Gather Data using the Power Query Editor• Understand the Excel Data Model
ForecastingUsing the Forecast SheetModifying OptionsUsing Forecast FunctionsUsing the Quick Analysis ToolFormatting OptionsCreating ChartsApplying TotalsCreating TablesAdding SparklinesUsing What-If AnalysisWorking with ScenariosCreating Data TablesUsing Goal SeekUsing SolverAdding the Solver Add-inDefine a Problem Using SolverSolving a ProblemSolver for Capital BudgetingSolver for Financial PlanningSolver to determine Optimal Product MixPerform What-If Analysis with the Solver Tool
Gathering DataUsing the Power Query EditorAppending DataMerging DataTransforming DataUsing the Excel Data ModelViewing a Data ModelGetting DataLinking TablesUsing the ModelCreating Calculated ColumnsCreating MeasuresCreating KPI’s
Questions?
Microsoft Office Specialist (MOS) Certification - Excel AssociateMicrosoft Office Specialist (MOS) Certification - Excel Expert
Introduction to Excel class or equivalent skills and a general understanding of the issues related to forecasting and what-if analysis.
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com