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
Have you ever been frustrated by the limitations of Excel's FIND function, and wished that you could use regular expressions (regex) in Excel? Or perhaps you've just been looking for a better way to filter your data table using a text column? 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

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

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

Can't Excel Do Division?

March 11, 2017 | Neil Talbott
The notoriously fiendish Listener Crossword, first published in 1930 and now printed weekly in the Saturday Times, includes four puzzles a year which are primarily or solely numerical. Three weeks ago the challenge was a puzzle called Can’t You Do Division? by a setter known pseudonymously as Oyler: Short version of this blog post! Read More

Microsoft Excel and BCBS 239 – 7 Steps to transform your End User Compute (EUC) capability

March 01, 2017 | Darren Harris
September 15th 2008, the day that Lehman Brothers Holdings Inc. filed for Chapter 11bankruptcy protection was another significant milestone in the global financial crisis that began in 2007. For those of us working at Credit Suisse during this entire period, fire drills [urgent business requests] were an hourly occurrence as we fought to respond to ad-hoc requests from the business in the face of swinging markets and creaking models (negative interest rates anyone?). Read More

Data Links, Viewer and a little bit of Magic brought to Microsoft Excel.

September 29, 2016 | Darren Harris
When introducing the Workbench to someone for the first time, we typically start by explaining two innovations that we’ve introduced into Excel called ‘Data Links’ and the ‘Viewer’. Grasping these concepts is..key to understanding the technology underpinning Schematiq and how it delivers new capabilities to users of Microsoft Excel. Read More