Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
109 articles in Tutorial · Page 2 of 13
DML Commands in SQL: INSERT, UPDATE, DELETE, and MERGE (with Examples)
Master dml commands in sql: learn syntax for INSERT, UPDATE, DELETE, and MERGE, avoid catastrophic updates without WHERE, and compare DML vs DDL.
Conditional Formatting in Excel: Highlight Rows, Formulas, and Visual Rules
Master conditional formatting in excel: highlight entire rows based on cell value or formula. Learn =$A2 locks, SEARCH+ISNUMBER rules, and daily analyst fixes.
Data Cleaning in Excel: How to Remove Blank Rows, Spaces & Duplicates
Master data cleaning in Excel: learn how to remove blank rows in excel, strip stray spaces with TRIM, fix casing, and delete duplicates safely.
Excel Formula List: The Top 30 Functions Every Analyst Uses (with Examples)
The complete excel formula list for data analysts: 30 essential functions across Lookups, Math, Logical, Text, and Date categories with syntax and examples.
Excel Formulas: The Complete Guide for Data Analysts (2026)
Master essential excel formulas in this complete guide: lookup, math, dynamic arrays, text, financial modeling, and 30+ core functions for analysts.
Excel Formulas Shortcut Keys: The 15 Must-Know Shortcuts for Analysts
Master excel formulas shortcut keys: AutoSum Alt + =, lock references with F4, audit with Ctrl + `, fill with Ctrl + D, and calculate 10x faster.
Excel Formula vs Function: Key Differences, Formula Bar & Syntax
Understand the difference between an excel formula and a function. Master MS Excel formulas syntax, formula bar auditing, and data cleaning workflows.
Pivot Table in Excel: The Step-by-Step Data Summarization Guide
Master how to create a pivot table in excel: step-by-step tutorial on Rows, Columns, Values, Filters, Calculated Fields, and fast data summarization.
VLOOKUP vs XLOOKUP in Excel: When to Use Each (with TRANSPOSE)
VLOOKUP vs XLOOKUP in Excel: compare the vlookup formula in excel against XLOOKUP, avoid column index bugs, and reshape dynamic array spills.