| Getting started with OAK |
| Welcome to OAK |
 | What's new in OAK 4 |
| General caution |
| OAK help |
| Three ways to get help |
| Updating OAK help |
| Example spreadsheets |
| International spelling |
| Applications for OAK |
| Simple spreadsheets |
| Developing spreadsheet models |
| Understanding other people's models |
| Formally auditing spreadsheets |
| Parallel reconstruction |
| Code inspection |
| Reconciling to a template model |
| Installing OAK |
| Getting the OAK software |
| Simple installation |
| In case of problems |
| The Add-Ins Manager |
| If you are running Excel 2003 |
| Buying OAK |
| Checking for updates |
| Files available from operisanalysiskit.com |
| Using OAK |
| OAK menus |
| Main menus |
| Context menu |
| Accelerator Key and Keytips |
| OAK commands |
| Map |
| Compare | Workbooks |
| Compare | Worksheets |
| Compare | Ranges |
| Compare | Remove Compare Modifications |
| Names | Redefine names |
| Names | Recreate names |
| Names | Apply names |
| Names | Deapply names |
| Names | Remove #REF! names |
| Names | Delete names in cells |
| Names | Localize names in cells |
| Names | Build name database |
| Formula | Reconstruct |
| Formula | Optimize |
| Formula | Prune inactive path |
| Formula | Analyze Discrepancies |
| Search Overview |
| Search | Arrays |
| Search | Merged cells |
| Search | Primary error cells |
| Search | Hardwired constants |
| Search | Constant formula cells |
| Search | Unreferenced cells |
| Search | Conditional search |
| Search | References to blank cell |
| Summarize |
| Columns and Rows | Insert |
| Columns and Rows | Delete |
| Transpose |
| Copy Address |
| Copy Literal |
| Remove Color Formatting |
| Unhide rows and columns |
| Operis Financial Modelling Book |
| Options |
| Scripting OAK |
| Getting started in scripting |
| Making scripting faster |
| OAK methods in the object browser |
| Script example: Finding redundant spreadsheets |
| Reference material |
| Basic concepts in Excel |
| Multi-area ranges |
| Cell precedents |
| Used range |
| One-Cell Rule |
| Merged cells |
| Arrays |
| Excel Names |
| If you use Excel names |
| If you avoid Excel names |
| Names tutorial A: Getting started |
| Names tutorial B: Defining names |
| Names tutorial C: Using names in formulas |
| Names tutorial D: Names adjustment |
| Names tutorial E: Apply names |
| Names tutorial F: Names that identify several cells |
| Names tutorial G: Create names |
| Names tutorial H: Useful conventions |
| Names tutorial I: Row and column matching |
| Names tutorial J: Aggregation |
| Names tutorial K: Controlling aggregation |
| Names tutorial L: Naming constants |
| Names tutorial M: Advanced tricks |
| Names tutorial N: Fine print |
| Names tutorial O: Summary |
| Basic concepts in OAK |
| Expression Simplification |
| What's safe in simplification |
| Simplification rules |
| Expression Pruning |
| Pruning rules |
| Difference between simplifying and pruning formulas |
| Discrepancy Analysis |
| Fan out |
| Constraining discrepancy analysis |
| Expression pruning in discrepancy analysis |
| Large ranges |
| Associating references or values |
| Supressing unmatched subtrees |
| Formula reconstruction |
| Reconstructing multi-sheet formulas |
| The context of a reconstruction |
| Reconstructing whole calculations |
| Timelines in reconstructions |
| Frozen rows and columns |
| Reconstructing formulas that use names |
| Levels of Reconstruction |
| Lots of levels |
| Mixed levels |
| Left-right consistency |
| Simplifying reconstructions |
| Pruning reconstructions |
| Reconstructing SUMs |
| Selections suitable for reconstruction |
| Long formulas |
| Uses for reconstructions |
| Difference between reconstruction and discrepancy analysis |
| Formula denaming |
| OAK object reference |
| AnalyzeDiscrepancies |
| ApplyNames |
| BuildNameDatabase |
| Compare |
| CompareRanges |
| CompareRangesWithColors |
| CompareWithColors |
| CompareWorkbooks |
| CompareWorksheets |
| CopyAddress |
| CopyLiteral |
| DeapplyNames |
| DeleteNamesInCells |
| DeleteRowsOrColumns |
| FormatAddress |
| FormatAddressDelimiter |
| GetVersion |
| ICompareResult |
| IDeapplyNamesResult |
| InsertRowsOrColumns |
| IOAKAddIn |
| IOAKAPI |
| IRenameFailure |
| IRenameResult |
| LocalizeNamesInCells |
| Map |
| MapComponents |
| MapOutput |
| OAKResult |
| Operis_OAK |
| Optimize |
| Prune |
| PruningMode |
| Reconstruction |
| Reformulate |
| RecreateNames |
| RedefineName |
| RemoveColorFormatting |
| RemoveHashRefNames |
| SearchFor |
| SearchForArrays |
| SearchForConstantFormula |
| SearchForHardwiredConstant |
| SearchForMerged |
| SearchForPrimaryError |
| SearchForReferencesToBlankCells |
| SearchForUnreferencedCells |
| SearchForValue |
| Summarize |
| Transpose |
| UndoCompareModifications |
| UnhideCells |
| Known limitations |
| 3-D references |
| Structured references |
| Doubly prefixed references |
| Format limits |
| Deleting corrupt names |
| Problem solving |
| Forcing preinstallation testing |
| Common problems |
| Reporting bugs |
| Finding where OAK is installed |
| Resources |
| Eusprig |
| Ray Panko's spreadsheet research website |
| Microsoft Excel blog |
| Version histories |
| OAK version history |
| Version history for this help |
© 1997-2010 Operis Group plc