XLOOKUP vs VLOOKUP: what actually changes in your work
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
Practical writing on the same subjects as our courses: Excel technique, Power Query, Power BI, dashboard design, metric definitions and using AI assistants for analytical work without getting burned.
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
The single highest-return change most Excel users can make. A worked example, the mistakes that make queries fragile, and how to build one that survives next month.
Sales says 4,120 active customers. Finance says 3,880. Both are right. The problem is not the data — it is that nobody wrote down what "active" means.
Most dashboards fail for design reasons, not technical ones. These six account for the majority of the ones nobody opens twice.
AI assistants are genuinely useful for analytical work and confidently wrong on a regular basis. The verification routine matters more than the prompt.
The real test of a spreadsheet is not whether it works today, but whether a colleague can open it in eight months and change it without breaking it.
Nine structured courses with exercise files, from Excel fundamentals to published Power BI reports.