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 ROUND, MOD, RANK and AVERAGE Functions

Excel math and statistics functions explained: order of calculation, ROUND, MOD, AVERAGE, MEDIAN, RANK, STDEV and SUBTOTAL, with…

September 27, 2026 13 min read
Excel

Excel Dates and Times: DATEDIF, EDATE, WORKDAY

Excel dates and times explained: serial numbers, DATE, DATEDIF, EDATE, EOMONTH, WORKDAY and NETWORKDAYS, week numbers and time…

September 27, 2026 13 min read
Excel

Excel Text Functions: LEFT, MID, TEXTJOIN, TRIM

Excel text functions explained: LEFT, MID, RIGHT, FIND, SUBSTITUTE, TRIM and TEXTJOIN, how to split a name or…

September 27, 2026 12 min read
Excel

Excel IF, AND, OR and IFS Functions Explained

Excel logical functions explained: IF, nested IF, AND, OR, IFS and SWITCH, how to combine AND with OR,…

September 27, 2026 12 min read
Excel

Excel Data Types and Number Formats Explained

Excel data types and number formats explained: numbers, text, dates, numbers stored as text, custom formats and the…

September 27, 2026 13 min read
Excel

Excel Cell References: Relative, Absolute, Mixed

Excel cell references explained: relative, absolute ($A$1) and mixed ($A1, A$1) references, the F4 key, ranges, other sheets…

September 27, 2026 15 min read
Automations

Apps Script Deployment Types Explained

Apps Script deployment types explained: versions vs deployments, /dev vs /exec, web app access settings, libraries and updating…

September 26, 2026 13 min read
Automations

Build a Web App Frontend With Apps Script

Build a web app frontend with Apps Script: HtmlService pages, google.script.run, include() files and a working task list…

September 26, 2026 13 min read
Automations

What Is doGet in Apps Script? Explained

What is doGet in Apps Script? How web app URLs call doGet(e), read query parameters, return JSON or…

September 26, 2026 13 min read
Scroll to Top