 | Extending Time Series (Modano 8)Automatic shortening, extending and rolling all time series sheets in your financial model. | |
 | Historical & Forecast Model - All Periods Financial Statements (Modano 8)Review of the all periods income statement, balance sheet and cash flow statement in the Wall Street Promotions annual historical & forecast financial model and discussion of the relationships between these financial statements and the other areas of the financial model. | |
 | Historical & Forecast Model - Corporate Taxation (Modano 8)Entry of the corporate taxation forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how corporate taxation flow through the financial model into the all periods financial statements. | |
 | Historical & Forecast Model - Debt & Ordinary Equity (Modano 8)Entry of the debt and ordinary equity forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how debt and ordinary equity flow through the financial model into the all periods financial statements. | |
 | Historical & Forecast Model - Debtors & Creditors (Modano 8)Entry of the debtors and creditors forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how debtors and creditors flow through the financial model into the all periods financial statements. | |
 | Historical & Forecast Model - Financial Model Creation (Modano 8)Development of the annual historical & forecast financial model of Wall Street Promotions including the importation and mapping of historical financial statements data. | |
 | Historical & Forecast Model - Fixed Assets (Modano 8)Entry of the capital expenditure and fixed assets forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how fixed assets flow through the financial model into the all periods financial statements. | |
 | Historical & Forecast Model - Historical Financial Statements (Modano 8)Provides an overview of the historical income statement and balance sheet used in an historical & forecast financial model to collect and reconcile historical financial statement data. | |
 | Historical & Forecast Model - Introduction (Modano 8)Introduction and overview of the Modano basic annual historical & forecast model practical learning exercise. | |
 | Historical & Forecast Model - Other Financial Statement Items (Modano 8)Entry of the interest on cash and other balance sheet items forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how these other financial statement items flow through the financial model into the all periods financial statements. | |
 | Historical & Forecast Model - Revenue & Expenses (Modano 8)Entry of the revenue and expenses forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how revenue and expenses flow through the financial model into the all periods financial statements. | |
 | Inserting Hyperlinks (Modano 8)Demonstrates how to insert custom hyperlinks into module components to facilitate quick and easy navigating between the components within a module. | |
 | Inserting Modules (Modano 8)Inserting modules from file or web. | |
 | Inserting Subtotals (Modano 8)Automatically inserting and deleting category sub-totals within your financial model. | |
 | Managing Modules (Modano 8)Introducing the Project Manager as a tool for visualizing, managing and editing the content within a modular financial model. | |
 | Modano Magic (Modano 8)Provides an overview of the ways in which the Modano financial modeling platform extends Microsoft Excel to include modular content management and sharing. | |
 | Model Roll-Forward (Modano 8)Demonstrates the rolling-forward of an historical & forecast budgeting & planning model to allow for newly-available historical data. | |
 | Module Components (Modano 8)Introducing module components, module component ranges, assumptions vs. outputs. | |
 | Opening & Saving Modules (Modano 8)Opening module (*.modm) files from file or web, versioning, saving. | |
 | Outputs Categories Addition (Modano 8)Demonstrates how category blocks are added to to existing categories groups to create related blocks of categories within modules. | |
 | Reforecasting (Modano 8)Provides a simple example of the amendment of forecast assumptions following model roll-forward. | |
 | Renaming Modules (Modano 8)Renaming modules, flow on effects, module management. | |
 | Replacing Modules (Modano 8)Replacing a module with a module with different functionalities. | |
 | Reusing & Sharing (Modano 8)Demonstrates the testing and validation of a newly-created module (*.modm) file via Inserting, assumptions entry, and module links verification. | |
 | Reviewing Module Content (Modano 8)Identifying likely issues, errors and non-best practice content. | |
 | Reviewing Module Content - Creating Modules (Modano 8)Pre-save reviewing module content, searching & repairing. | |
 | Specifying Module Properties (Modano 8)Explains how to view and edit module properties, and discusses the relevance of each property when the module is reused and shared. | |
 | Standardize & Review Mode (Modano 8)Provides an overview of Standardize & Review Mode vs. Automate Mode when using Modano, and the optional Tools tab. | |
 | Styles & Formats (Modano 8)Importance of styles and formats when creating and editing cell blocks within module components, assumptions vs. outputs styles, applying, shortcuts. | |
 | Styles & Formats - Standardization (Modano 8)Explains and demonstrates the use of purpose-based formatting when creating standardized spreadsheets, including cell content and cell purpose identification. Also covers data alignment tools. | |
 | Time Series Analysis (Modano 8)Provides an overview of the time series infrastructure provided by Modano to assist in efficiently creating standardized, best practice time series-based spreadsheets, including time series assumptions, lookup tables and sheets. | |
 | Updated Data Importation (Modano 8)Demonstrates the importation, mapping and reconciliation of newly-available financial data following model roll-forward. | |
 | Version Monitoring (Modano 8)Demonstrates the activation and use of version monitoring and saving files with names containing versions. | |
 | Work In Progress (Modano 8)Demonstrates the use of work in progress fill color to mark up ranges within spreadsheets requiring review and then quickly find them later. | |
 | Workbook Structure (Modano 8)Provides an overview of the Modano base sheets system, including the creation of a new standardized workbook with a cover and contents sheet. Also demonstrates adding sheets and manually updating the table of contents with page numbers. | |
 | Workbook Viewing (Modano 8)Demonstrates the consistency and time savings achieved when using the Modano workbook view tools to implement spreadsheet wide viewing and outlining levels. |