Excel is an extraordinarily popular tool, but are we sure it’s the right tool for everything? — Introduction Excel born to organize data and typically is used to perform (sometimes not so) basic analysis and models. It is widely spread in offices across the globe, used in all working areas and in companies of all dimensions. …

How to use XLtoy to parse and extract formula semantics from an excel workbook, and analyze its topology with better instruments. — Every spreadsheet has its own syntax, and excel is not far behind. So implementing a model in a spreadsheet must consider two main aspects: syntax and topology. My purpose is to break down these, and of course others, aspects to get a complete picture, and implement it in XLtoy package…

This article explains how to use XLtoy as a change management tool to follow workbook changes. — Writing models in Excel nowadays is de facto a standard, but for many reasons can become very painful maintain the development cycle for a long time. …

Many times i found myself in front of big datasets stored in xlsx format. To be honest, open format is not designed to store lots of data, old binary file xls (Excel Binary Format) was more performing, from this point of view. Anyway, handling these kinds of files is a…