Excel
VLOOKUP, HLOOKUP and XLOOKUP: one practical Excel example
A formula can return a number and still point to the wrong product. I walk through a small product lookup, then deliberately break the data to show what needs checking.
Category
Excel
KajoData articles about Excel. Practical knowledge about data analysis, tools and careers.
Articles: 4
Excel
Advanced Excel formulas: calculations, lookups and error checks
A useful formula produces a result you can explain and verify. I use six records to connect calculations, lookups and text processing in a readable worksheet.
Excel
Python in Excel: cloud calculations and a maintainable workflow
Understand where Python runs, how inputs reach it and what a recipient needs from the output. Build a small, understandable analysis before expanding the workbook.
Excel
Array formulas in Excel: from one cell to a complete list
One formula can calculate six values, select matching rows or create a list of categories. I explain how to predict its output and catch mistakes before they reach a report.