Further Details
Basic modelling concepts
· good practice guidelines
· financial framework
· designing output
WORKBOOK NAMES
· creating and defining workbook names
· using names in formulas and functions
· establishing a naming convention
PRESENTATION TECHNIQUES
· using charts to explore relationships and illustrate results
· number formats
· automating links and link management
· reports and printed output
MAKING DECISIONS
· Techniques for financial calculations
· methods of approach
· logical functions
· lookup and reference functions
· cross-cast and error traps
· calculation of interest
WHAT-IF ANALYSIS
· sensitivity tables
· using form controls on a worksheet
· using Solver
· Goal seek and Scenario manager
CASE STUDY
· structuring a business model
· including profit and loss statement
· application of scenarios, data tables, charts and other output
· reaching a conclusion - decision making
Guide price
£250 |
