Career & business
5 reasons Excel still belongs in an analyst's toolkit
I use one small example to show where Excel helps, what to check after a refresh and how to deliver a workbook someone else can understand.
Tag
excel formulas
KajoData articles about excel formulas. Practical knowledge about data analysis, tools and careers.
Articles: 4
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.
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
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.