Please take the following steps to address this issue:
Introduces BPM, the Best Practice Spreadsheet Modeling Standards, bpmToolbox, Modular Spreadsheet Development and bpmModules.
Learn how to implement the Best Practice Spreadsheet Modeling Standards using bpmToolbox by undertaking comprehensive, interactive training tutorials.
Watch highlights of bpmToolbox in action.
Learn how to implement Modular Spreadsheet Development using bpmModules by undertaking the Getting Started tutorials.
Watch advanced tutorials to learn how to create, manage and share your own bpmModules content.
Learn how to build and maintain historical and forecast dynamic financial models using bpmModules by undertaking the financial modeling tutorials.
Import historical income statement and balance sheet data and enter forecast and budget assumptions as part of a rolling business planning process.
Provides an overview of spreadsheet best practice, and an introduction to a best practice Excel workbook.
Introduces the bpmToolbox base workbook, including a hyperlink-based table of contents for structuring and navigation, and demonstrates the insertion of base sheets.
Demonstrates the use of the tools within the bpmToolbox Styles and Formats tabs to efficiently implement purpose-based formats and styling and a best practice model.
Introduces the use of centralized, automated checks systems by bpmToolbox, allowing for error, sensitivity and alert checks in accordance with the Standards.
Introduces some of the bpmToolbox tools used to accelerate the model development process, including accessories, controls, hyperlinks, names, schematics and charting tools.
Introduces some of the key bpmToolbox tools used to review the content within a best practice model and ensure that it prints and views consistently in accordance with the Standards.
Overview of the Best Practice Modelling System and the embedded interactive training system.
Fundamental concepts including workbook, sheet and cell purpose and content.
Workbook structure, sections, table of contents and navigation.
Sheet types, structure, consistency, titles and content.
Format and style purpose, consistency, identification, explanation and appearance.
Assumption entry interface structure, rules, consistency, location and formats. Interface control tools, including purpose-based styles, controls, data validation and checks.
Sensitivity analysis structure, location, rules and identification. Common sensitivity analysis methods, including single and dual output sensitivity analysis examples.
Output links, rules, separation and sections. Presentation outputs creation, including dashboards and charting.
Calculation formulae consistency, rules, diagrams and complexities. Formula analysis and review, including error detection and location.
Workbook, sheet and range naming consistency, identification, rules and application.
Time series analysis, assumptions, consistency, structure, periodicity, rules and output. Historical and forecast time series analysis tools and techniques.
Error checks, sensitivity checks and alert checks structure, rules, location, formats and identification. Automated and integrated checks system creation and maintenance.
Printing and viewing consistency, rules, margins, page numbers and information. Table of contents page numbering, printed page identifiers and printing and viewing efficiency tools.
Multiple workbook links, structure, location, rules and diagrams. Efficiently linking workbooks using model import and model export sheets.
Workbook, sheet and cell protection and control. Purpose-based styles and tools for efficiently protecting a workbook prior to distribution.
The use of visual basic programming in spreadsheet models. Fundamental tips and tricks for writing VBA macros within workbooks.
Various other areas, including workbook calculation setting, model developer identification and the creation of model help files and user guides.