|
|
|
 |
|
Introduction |
|
Overview of the Best Practice Modelling System and the embedded interactive training system. |
| |
Duration: |
8:27 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
1. General Concepts |
| |
Fundamental concepts including workbook, sheet and cell purpose and content. |
| |
Duration: |
9:58 |
Examples: |
1 |
Exercises: |
0 |
Watch: |
Small | Large |
|
|
|
 |
|
2. Workbook Structure |
| |
Workbook structure, sections, table of contents and navigation. |
| |
Duration: |
21:03 |
Examples: |
1 |
Exercises: |
2 |
Watch: |
Small | Large |
|
|
|
 |
|
3. Sheet Structure |
| |
Sheet types, structure, consistency, titles and content. |
| |
Duration: |
10:08 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
4. Formats & Styles |
| |
Format and style purpose, consistency, identification, explanation and appearance. |
| |
Duration: |
13:55 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
5. Assumption Entry Interfaces |
| |
Assumption entry interface structure, rules, consistency, location and formats. Interface control tools, including purpose-based styles, controls, data validation and checks. |
| |
Duration: |
50:54 |
Examples: |
1 |
Exercises: |
2 |
Watch: |
Small | Large |
|
|
|
 |
|
6. Sensitivity Analysis |
| |
Sensitivity analysis structure, location, rules and identification. Common sensitivity analysis methods, including single and dual output sensitivity analysis examples. |
| |
Duration: |
10:14 |
Examples: |
1 |
Exercises: |
0 |
Watch: |
Small | Large |
|
|
|
 |
|
7. Outputs & Presentations |
| |
Output links, rules, separation and sections. Presentation outputs creation, including dashboards and charting. |
| |
Duration: |
13:25 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
8. Calculation Formulae |
| |
Calculation formulae consistency, rules, diagrams and complexities. Formula analysis and review, including error detection and location. |
| |
Duration: |
9:39 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
9. Naming Principles |
| |
Workbook, sheet and range naming consistency, identification, rules and application. |
| |
Duration: |
26:26 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
10. Time Series Analysis |
| |
Time series analysis, assumptions, consistency, structure, periodicity, rules and output. Historical and forecast time series analysis tools and techniques. |
| |
Duration: |
41:40 |
Examples: |
2 |
Exercises: |
3 |
Watch: |
Small | Large |
|
|
|
 |
|
11. Checks |
| |
Error checks, sensitivity checks and alert checks structure, rules, location, formats and identification. Automated and integrated checks system creation and maintenace. |
| |
Duration: |
18:20 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
12. Printing & Viewing |
| |
Printing and viewing consistency, rules, margins, page numbers and information. Table of contents page numbering, printed page identifiers and printing and viewing efficiency tools. |
| |
Duration: |
18:23 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
13. Multiple Workbooks |
| |
Multiple workbook links, structure, location, rules and diagrams. Efficiently linking workbooks using model import and model export sheets. |
| |
Duration: |
14:13 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
14. Security & Protection |
| |
Workbook, sheet and cell protection and control. Purpose-based styles and tools for efficiently protecting a workbook prior to distribution. |
| |
Duration: |
7:20 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
15. Visual Basic Programming |
| |
The use of Visual Basic programming in spreadsheet models. Fundamental tips and tricks for writing VBA macros within workbooks. |
| |
Duration: |
10:05 |
Examples: |
1 |
Exercises: |
1 |
Watch: |
Small | Large |
|
|
|
 |
|
16. Miscellaneous |
| |
Various other areas, including workbook calculation setting, model developer identification and the creation of model help files and user guides. |
| |
Duration: |
3:57 |
Examples: |
1 |
Exercises: |
0 |
Watch: |
Small | Large |
|
|
