Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
109 articles in Tutorial · Page 1 of 13
SQL CTE (WITH Clause): Syntax, Chaining, Recursive CTEs & Real Examples (2026)
Master SQL CTEs (Common Table Expressions) using the WITH clause. Learn exact syntax, execution lifecycle, chaining CTEs, recursive CTEs for org hierarchies, and CTEs vs subqueries vs temp tables.
Basic Excel Formulas: The Top 10 Formulas Every Analyst Needs to Know
Learn essential basic excel formulas: master SUM, AVERAGE, COUNT, IF, VLOOKUP, and conditional functions with syntax, examples, and practical fixes.
CAGR Formula in Excel: Growth Rate with RRI and Power Method
CAGR formula Excel guide: compute annualised growth with =(End/Start)^(1/n)-1 and =RRI(). Investor examples, negative bases, and CAGR vs XIRR explained.
How to Compare Two Columns in Excel: 5 Methods (with Formulas)
How to compare two columns in Excel: equality checks, IF flags, COUNTIF matching, conditional formatting highlights, and VLOOKUP reconciliation steps.
Compound Interest Formula in Excel: FV, Growth, and SIP Examples
Compound interest formula Excel guide: grow savings faster with =FV(rate, nper, pmt), the power-operator method, SIP math, and yearly compounding examples.
CREATE TABLE in MySQL: Syntax, Data Types & Constraints Guide
Master CREATE TABLE in MySQL with syntax examples, primary keys, foreign keys, AUTO_INCREMENT, constraints, and InnoDB engine best practices.
DDL SQL Commands: Complete Guide to Data Definition Language
Master DDL SQL commands: CREATE, ALTER, DROP, TRUNCATE, and RENAME with practical syntax, schema constraints, and DDL vs DML comparisons.
How to Delete Blank Rows in Excel: 4 Safe Methods (with Checks)
How to delete blank rows in Excel safely: Go To Special Blanks, AutoFilter blanks, helper COUNTBLANK flags, and backup checks every analyst must run first.
Delete Duplicate Records in SQL: 3 Proven Methods with Examples
Learn how to delete duplicate records in SQL using ROW_NUMBER() CTEs, self-joins with MIN/MAX IDs, and safe transaction workflows across dialects.