Data analysis and modelling are fundamental to generating valuable insights but are often painstakingly slow. ‘New’ lets you begin your analysis with a pre-built model, e.g., for discounted cash flow (DCF) and product line profitability (PLP), and gives direct access to your company’s model templates, while letting you easily manage and distribute them.
Understanding someone else’s model can be convoluted. Help your colleagues, clients, or future self with a model overview, where workbook structure, standards, and sheets are described. ‘Index’ lets you create an automated overview page for your model with forward and backwards links to model sheets.
A well formatted workbook reduces the risk for errors and makes it easier to grasp the essence of your analysis but setting it up can take a lot of time. With ‘Cycles’ and custom shortcuts, using your company standards couldn’t be faster – easily cycle through headers, cells, numbering formats, line styles, row shading, and more.
With complex modelling, understanding the structure and interconnection of a model can be difficult and time consuming. ‘Inspect formulas’ breaks down the workbook and formulas into atoms, and lets you journey through the model while explaining every step on the way. Unlimited navigation through dependencies or formula expressions.
Checking formulas for errors usually entails endless clicking through cells to discover inconsistencies. ‘Visualize’ provides a visual overlay for your workbook, displaying regular formulas and formulas with irregularities such as hardcoded numbers, ensuring error-free workbooks while reducing time and redundant efforts.
An error-free model output is of fundamental importance for providing accurate client recommendations. ‘Scan & Fix’ checks for the 30 most common modelling errors, including concealed problems such as pivot tables not reflecting the full table of data, and, when applicable, provides an automatic fix.