What our Spreadsheet Analysis Software does for you
30+ tools helping you with each step of the spreadsheet modelling process
OAK features to help you understand, compare and de-risk Excel spreadsheet models
Stop wasting hours checking and re-checking a spreadsheet's inputs, calculations and outputs for errors and formula accuracy.
Determine a model's structure and use of formulas at a click of a button. Make sure you don’t miss important information. Also, compare spreadsheet versions.
Mitigate risk with our Excel spreadsheet software. Confidence in the model means confident decisions.
Summarize
Get a summary of your entire workbook. If you’re building a spreadsheet, reduce the risk of error before releasing your model. If you’re reviewing or reading and interpreting a spreadsheet, get an overview of the logic behind the structure, layout and formulas. Also detect errors.
Model summary: identify critical contents such as the number of formulas, constants, errors and very hidden sheets.
Summary of distinct formulas: extract a list of all formulas, the number of times they occur and their complexity.
Summary of referred constants: easily locate constant cells used in formulas.
Summary for cross-reference: visualise the number of links between worksheets.
Risk analysis report: efficiently identify more error-prone formulas with a list of formulas scored by risk.
Map
Need a quick and efficient way to audit a spreadsheet? With a graphical map of the structure of the sheets in your workbook, you can quickly understand the logic behind a worksheet and check for errors and inconsistencies.
Formula Explorer
Our microsoft excel spreadsheet software includes an UI-based tool that makes navigation and formula auditing faster and easier. Some new features included in the Formula Explorer are:
Navigation across all precedents and branches just using fully customised keyboard shortcuts.
The Split functionality allows users to review multiple precedents with a single tool.
Automatic updates across the row when editing a formula.
Pruning a formula on a preview mode; see the potential impacts before applying the pruning version.
Compare
Our financial spreadsheet software offers a fail-safe method for identifying variances between two spreadsheets, as well as discrepancies among worksheets within a singular spreadsheet.
Easily distinguish concrete changes from those that occur as a result of items changing position.
Review Tool
Streamline Your Spreadsheet Reviews with the Review Tool:
Keep all review information organized within the spreadsheet
Export and re-import ‘issues’ with ease for efficient tracking
Edit issues directly with the review tools or on the report worksheet
Improve collaboration with team members or colleagues
Understand, examine and debug formulas in a model.
Reconstruct a formula: deep dive into a formula and see its construction from root level.
Prune inactive cells: make it easy to understand calculations. Filter out inactive elements. As a result focus on active elements.
Fan out precedents: quickly figure out the differences between two formulas with a feature that lets you trace precedents of both.
Optimize formula performance: get recommendations for reconfiguring formulas so that they are clear and concise. With OAK, you can apply a series of 50 simplification rules to any formula.
Search
Easily locate cells with specific attributes. Especially those that do not comply with best practices. You can search for:
Primary error cells – quickly identify the cells from where am error originates.
Dynamic arrays – find the new default type of formulas in Excel – dynamic array formulas and the corresponding spilled formulas.
Constant formulas cells – find formulas which make no reference to other cells as precedents.
Arrays
Merged cells
Hardcoded values in formulas
References to blank cells
Unreferenced cells
Conditional search
How Our spreadsheet analysis software features help you work with worksheets, cells and range names
Worksheets
See how OAK’s spreadsheet analysis software makes it easy to work with multiple worksheets in Excel.
Worksheet manager: get a handle on a spreadsheet’s multiple worksheets. Select and group sheets based on your desired criteria: update protection, calculations and visibility in just one click. Also, find and replace sheet names.
Insert/delete columns and rows: no need to build new data tables or arrays. Add or remove columns and rows to an existing table. At the same time, retain left-to-right consistency and avoid errors.
Remove colour formatting: remove the colour from all cells in either a single worksheet or an entire workbook in one click. As a result, reduce file size.
Unhide cells: expose hidden cells in a specified worksheet or workbook. Make hidden rows or columns visible.
Cells
See how OAK’s Excel spreadsheet software makes working with cells easy.
Copy literal: copy one or more formula(s) from a source range to the target range for testing, without the need to adjust cell coordinates.
Copy address: need to document and communicate issues found in a spreadsheet review? Easily copy the entire path to a cell.
Transpose: transpose cells from one area of an active worksheet to another, rotating orientation from rows to columns while preserving cell references.
Range names
See how OAK’s spreadsheet analysis software makes it easy to work with range names in Excel.
Summarize – Range names report: generate a report of all range names in a workbook.
Apply/De-apply: convert cell references to range names and vice versa.
Redefine names: update a range name across an entire workbook – even range names already referenced in formulas.
Recreate names: change several range names in just one click.
Localize: find and easily convert global range names into names that are local to an active worksheet.
Remove #REF!: find and remove #REF! errors that occur when a formula references a range name that no longer exists.
