Handling Excel Formula Errors in Power Query
Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and...
Tag: Excel Audits
Convert “Column1” to “A”
I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI...
Excel Compare: Audit your workbooks
Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? We have just released our 10th app on AppSource that can...
