Stop wasting hours checking and re-checking a spreadsheet's inputs, calculations and outputs for errors and formula accuracy.
OAK features to help you understand, compare and de-risk Excel spreadsheet models
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.
Formula Explorer
A 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.
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
See how easy it is to audit formulas
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 OAK’s features help you work with worksheets, cells and range names
Worksheets
See how OAK’s spreadsheet 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 spreadsheet software makes working with cells in Excel 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 refences.
Range names
See how OAK’s spreadsheet software makes it easy to work with range names in Excel.
- Build database: 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.
