The Journal
Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.
Excel Financial Functions: PMT, NPV, IRR Explained
Excel financial functions explained: PMT, FV, NPV, IRR, MIRR, IPMT, CUMIPMT, EFFECT, depreciation methods, and XNPV/XIRR, with real…
Excel Charts: Common Mistakes and How to Fix Them
Excel charts through the mistakes that go wrong: the header-row trap, series direction, hidden rows, axis scaling, pie…
Excel PivotTables Explained: Build, Group, Refresh
Excel PivotTables explained: building one, Show Values As, calculated fields and items, grouping dates, refreshing, and GETPIVOTDATA, with…
Excel Data Cleaning and Validation Explained
Excel data cleaning and validation: Text to Columns, Find and Replace, validation rules, list case sensitivity, and why…
Excel Tables, Sorting and Filtering Explained
Excel Tables, sorting and filtering explained: structured references, total rows, SUBTOTAL vs SUM, sort order, AutoFilter, Advanced Filter…
Excel Errors: #N/A, #VALUE!, #REF! and How to Fix
Excel errors explained: what #N/A, #VALUE!, #REF!, #NAME? and #DIV/0! mean, how to fix them, IFERROR vs IFNA…
Excel Dynamic Arrays: FILTER, SORT, UNIQUE, LET
Excel dynamic arrays explained: FILTER, SORT, UNIQUE, SEQUENCE and LET, how spilling works, AND and OR in FILTER,…
Excel VLOOKUP, XLOOKUP and INDEX MATCH Explained
Excel lookup functions explained: VLOOKUP, INDEX MATCH and XLOOKUP, exact vs approximate match, several criteria and why lookups…
Excel SUMIFS, COUNTIFS and AVERAGEIFS Explained
Excel SUMIFS, COUNTIFS and AVERAGEIFS explained with one sales table: criteria, dates, wildcards, OR conditions and the traps,…