The Journal
Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.
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…
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…
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…
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,…
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…
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…
Apps Script Deployment Types Explained
Apps Script deployment types explained: versions vs deployments, /dev vs /exec, web app access settings, libraries and updating…
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…
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…