Excel’s default drill-through for pivottables connected to a datamodel or Power BI dataset is often not very helpful. The add-in PowerDrill for Excel replaces Excel’s drill-through and gives you full control over the drill details.
[Read more…] about Replace drill-through for Power Pivot and Power BI pivottables in ExcelExcel apps
AuditfileValidator for Excel: validate and inspect Xml auditfiles
AuditfileValidator is an Excel addin that validates the most common auditfile formats and versions (XAF, XAS, XAA, SAF-T, etc) against their schema, and presents an overview of the most important properties of the auditfile.
[Read more…] about AuditfileValidator for Excel: validate and inspect Xml auditfilesIBAN validation with BBAN format check
In this post I describe Excel/VBA functions for IBAN validation that not only perform a Mod 97 calculation but also validate the format of the country-specific Basic Bank Account Number (BBAN). [Read more…] about IBAN validation with BBAN format check
Mastermind in Excel
In this post an Excel worksheet implementation of the well known Mastermind game. I developed the Mastermind part of this workbook several years ago. For this showcase app I added a scoreboard, and turned it into a so called dictator application. [Read more…] about Mastermind in Excel