top of page

KNOWLEDGE HUB
Practical explanations for better data work
Articles on Excel, Power BI, Power Query, dashboards, and automation—kept focused enough to use in your next project.


ETC Toll-Card Executive Dashboard in Excel
Turn raw ETC toll-card logs into a dark executive dashboard and a synchronized A4 report with Power Query, PivotTables, native slicers and PDF export.

MirVel
Sep 233 min read


Welcome to Excelized
Excelized helps turn messy data into clear dashboards and better decisions with Excel, Power BI, Power Query, Power Automate, practical training, templates, and free tools.

MirVel
Aug 291 min read


Humble tools - big impact
Over the years, I've used my fair share of these little online tools — converting currencies, turning files or images from one format into another. And always with the same hope: free, no spam, no ads, no subscription wall. Do you know the feeling? I bet you do. We've all been there at least once. So I decided to build my own. With my teammate Claude, I generated a set of HTML apps that work flawlessly and do exactly what they promise — for free, with no spam and no subscript

MirVel
Aug 213 min read


Build a Dynamic FIFA World Cup 2026 Dashboard in Excel
Spain, 308 goals and 6.8 million fans. Turn the 2026 World Cup into a dark, pitch-green Excel dashboard using XLOOKUP, FILTER, LET, GROUPBY, LAMBDA and the spill operator. Full workbook included.

MirVel
Aug 1610 min read
bottom of page
