New: 6 free SQL practice datasets with 300+ questions — try the SQL Compiler →
Free · No signup needed

The Journal

Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.

Excel

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…

September 27, 2026 13 min read
Excel

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…

September 27, 2026 11 min read
Excel

Excel PivotTables Explained: Build, Group, Refresh

Excel PivotTables explained: building one, Show Values As, calculated fields and items, grouping dates, refreshing, and GETPIVOTDATA, with…

September 27, 2026 10 min read
Excel

Excel Data Cleaning and Validation Explained

Excel data cleaning and validation: Text to Columns, Find and Replace, validation rules, list case sensitivity, and why…

September 27, 2026 10 min read
Excel

Excel Tables, Sorting and Filtering Explained

Excel Tables, sorting and filtering explained: structured references, total rows, SUBTOTAL vs SUM, sort order, AutoFilter, Advanced Filter…

September 27, 2026 12 min read
Excel

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…

September 27, 2026 12 min read
Excel

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,…

September 27, 2026 13 min read
Excel

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…

September 27, 2026 14 min read
Excel

Excel SUMIFS, COUNTIFS and AVERAGEIFS Explained

Excel SUMIFS, COUNTIFS and AVERAGEIFS explained with one sales table: criteria, dates, wildcards, OR conditions and the traps,…

September 27, 2026 9 min read
Scroll to Top