bpmToolbox - Highlights

Base Workbook   Restructure Workbook   Update Table of Contents   Applying Styles   Inserting Controls   Formula Conditional Formatting
Inserting a base workbook   Restructuring a workbook   Table of contents   Applying styles   Inserting multiple controls   Formula conditional formatting
Start a new model by inserting a base workbook with a hyperlink-based table of contents.   Efficiently rename, re-title, move, delete, hide and unhide sheets.   Update the workbook table of contents, including printed page numbering.   Apply purpose-based styles, allowing for assumptions vs. outputs, with automated fill coloring.   Insert multiple controls sized to specified ranges, allowing for cell link styling and naming.   Apply conditional formatting based on the formula within cells.
From: Tutorial 2   From: Tutorial 2   From: Tutorial 12   From: Tutorial 4   From: Tutorial 5   From: Tutorial 5
 
Multi-Watch Windows   Creating Dashboard Outputs   Traverse Formula   View Formula Logic   Error Source Ranges   Insert Time Series Assumptions
Multi-watch windows   Creating dashboard outputs   Traversing a formula   Viewing formula logic   Locating error source ranges   Inserting time series assumptions
Use multiple watch windows to watch ranges and charts within a workbook whilst changing assumptions and analyzing outputs.   Efficiently create customized dashboard outputs containing perfectly presented tables and charts.   Quickly view and locate the precedents of a formula, and drill-down into the formulas within these precedent ranges.   View the logic within formula using a formula logic diagram displayed in a dialog box.   Locate the ranges within a workbook which are the source of errors within other ranges in the workbook.   Insert assumptions to be used as the basis for including time series analysis within a workbook.
From: Tutorial 6   From: Tutorial 7   From: Tutorial 8   From: Tutorial 8   From: Tutorial 8   From: Tutorial 10
 
Inserting a Time Series Sheet   Adding Error Checks   Protect Multiple Sheets            
Inserting a time series sheet   Adding error checks   Protecting multiple sheets            
Quickly and easily insert time series sheets to be used as a foundation for undertaking time series analysis.   Add error checks to worksheet ranges and have these checks automatically included within the workbook error checks summary.   Quickly protect all the sheets within a workbook, leaving assumption cells unprotected for model users to be able to change.            
From: Tutorial 10   From: Tutorial 11   From: Tutorial 14