Blog

Blog

Jordan, Messi and Superstar Tech Trends

April 03, 2018 | Guy Barnes
Let me run an idea past you. Consider two sports: basketball and football. In basketball an individual player can make a stark difference to the overall performance of a team. A star can single-handedly take charge of a game and frequently score with little help from others.  Read More

How Schematiq can help you work with CSV files

March 26, 2018 | Kevin Crooks
This blog post explains how to import a CSV file into Excel using Schematiq, and how this can help with data cleaning and re-formatting. Read More

Grouping Data in Excel and How Schematiq Can Help

January 15, 2018 | Marcus Nielsen
How do you extract meaningful insights from rows and rows (and rows) of data? The truth is, as humans we're not very good at dealing with lots of detail - the average person can only hold 7 items in their working memory at once - which spells trouble when you have to deal with datasets containing hundreds, even thousands, of items. Read More

Advanced Table Filtering in Excel: Using Regular Expressions and Schematiq to Filter Data

December 18, 2017 | Marcus Nielsen
Ever wished that you could use regular expressions (regex) in Excel? Or perhaps you've been looking for a better way to filter your tables? In this blog, we'll show how Schematiq can help, by bringing the power of regex to your Excel spreadsheets. Read More

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

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

Improving on Excel and Access

March 21, 2017 | Mark Jefford
As inseparable as Bonnie and Clyde, Microsoft Excel and Access are often found in cohorts together in the end-user computing world. Their use in any business typically evokes suspicion and fear in ITmanagers and often their exploits in the enterprise leads to a long rap sheet listing their crimes. Read More