More time to trial OAK!

We have now increased the trial period from 15 days to 30 days!

Try now!

OAK features to help you understand, compare and de-risk Excel spreadsheet models

Spreadsheet software tools

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.

Spreadsheet software to map in Excel

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.

Spreadsheet software with formula walker

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.

Spreadsheet software to compare worksheets

Compare

Get a foolproof way to find differences between two spreadsheets. Also the differences between worksheets within a single 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

OAK Excel formula optimize feature

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.

OAK Search Features

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.