Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
119 articles in Tutorial · Page 4 of 14
Conditional Formatting in Excel: Highlight Rows & Rules
Master conditional formatting in Excel to highlight entire rows based on cell values or formulas. Learn =$A2 locks, SEARCH rules, and key 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.
FILTER Formula in Excel: Dynamic Filtered Lists (with Examples)
FILTER formula in Excel explained: =FILTER(array, include) builds live filtered lists. Multiple criteria, troubleshooting #CALC!, and analyst examples inside.