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.


Latest Excel Updates Worth Trying: Canvas, Lists & More
A hands-on guide to Excel Canvas, table naming, Center Across Selection, and in-cell lists, with clear rollout notes and a safe test workflow.

MirVel
8 hours ago8 min read


Power BI Full-Text Search with DAX: TEXTCONTAINS and TEXTSIMILARITY
Learn how Power BI’s September 2026 full-text search preview works. Configure a persisted column index, find matching feedback with TEXTCONTAINS, rank it with TEXTSIMILARITY, and avoid common setup and scoring mistakes.

MirVel
Oct 107 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


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


Hidden PivotTable Tips & Tricks You’ll Actually Use (Excel)
Most people use PivotTables but few use them well. These high-impact tricks cover custom sorting, calculated fields, grouping, and more — with a free European snacks dataset to practice on.

MirVel
Feb 123 min read
bottom of page
