Blog

Blog

tbl.Filter: An Introduction to Filtering With Schematiq

December 12, 2017 | Marcus Nielsen
Filtering is undoubtedly one of the most important tools available to an Excel user. Starting from an unruly mess of data, with just a few clicks you can hone in on exactly the items you want, hiding all the unnecessary information and leaving you free to concentrate on the things that really matter. Read More

Filtering Schematiq tables in Excel: allBut settled

December 07, 2017 | Marcus Nielsen
For anyone who works with large datasets, filtering is indispensable. When you are starting from a huge number of data rows, in order to draw any meaningful conclusions you need to carefully decide which items are useful (and should be included), and which are irrelevant. Read More

VLOOKUP – Thinking outside the box with Schematiq

December 01, 2017 | Kevin Crooks
VLOOKUP is a widely used Excel function. It is commonly found occupying entire columns of a spreadsheet, having been entered in that very first cell and copied down. In addition to the performance penalty that such spreadsheets pay, if the formula has been mis-copied, it can be difficult to see these errors. Schematiq offers a concise and efficient alternative to VLOOKUP, that applies to all rows of your table with a single formula. Sounds too good to be true? Read More

Ready for an Update (columns)?

November 28, 2017 | Kevin Crooks
Imagine a table of data; full of potential insights; but with poorly formatted columns (or at least, not as we would like). How might we tidy these, and prepare the table for analysis? Read More

Schematiq Release 4.0

November 20, 2017 | Darren Harris
What's new in Schematiq 4.0 Highlights Version 4.0 brings a new, cleaner look and feel to the viewer, with Back / Forward browser-style navigation as well as the ability to click on parts of a cell formula to understand a calculation, and to follow links back to the previous cells in the calculation tree. Read More

Schematiq Detailed Introduction

September 25, 2017 | Darren Harris
Transforming an Option Pricer spreadsheet using Schematiq.  Externalise data held in spreadsheets, simplify complex forumula, increase calculation performance and govern shared spreadsheet logic. Read More

Schematiq Workbench

September 07, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform the way you use Microsoft Excel. Read More

Schematiq converts your Excel Spreadsheets into dynamic API's

August 11, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform your existing Excel spreadsheets into dynamic API's. Read More

Novae Group plc improves their Capital Modelling Process in Microsoft Excel using Schematiq.

July 13, 2017 | Darren Harris
Read More

Schematiq solves the Top 4 Excel Challenges for Insurance Firms

May 25, 2017 | Darren Harris
  Microsoft Excel is pervasive across the insurance industry, particularly in areas such as capital modelling, forecasting, pricing optimisation, risk management and regulatory reporting. However, while Excel itself is robust, the error prone spreadsheets people create can be fragile. Errors are caused by manual data entry, cutting and pasting data and formula complexity can simply generate wrong numbers.  For insurers, this can lead to incorrect regulatory reporting (under GAAP, IFRS and Solvency II) and material misstatements resulting significant losses, fines and reputational damage. Read More