Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
109 articles in Tutorial · Page 3 of 13
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.
How to Hide Columns in Excel: Shortcuts, Grouping, and Best Use
How to hide columns in Excel: right-click Hide, Ctrl+0, grouping outlines for reports, and what hiding does to formulas, printing, and shared workbooks.
How to Combine Two Columns in Excel: Ampersand, TEXTJOIN, and Flash Fill
Learn how to combine two columns in excel using the ampersand (&), TEXTJOIN, CONCAT, and Flash Fill. Add spaces, format dates, and preserve data.
How to Freeze Rows in Excel: Top Row, Multiple Rows, and Panes
Learn how to freeze rows in excel: lock the top row, freeze multiple rows, lock rows and columns simultaneously, and use the Alt + W + F + F shortcut.
How to Remove Duplicates in Excel: Built-in Tools, UNIQUE, and Fixes
Learn how to remove duplicates in excel using the Data tab tool, UNIQUE formula, and Advanced Filter. Step-by-step methods, edge cases, and analyst fixes.
INDEX MATCH Function in Excel: Flexible Lookups (with Examples)
INDEX MATCH function in Excel explained: =INDEX(return, MATCH(lookup, range, 0)). Left lookups, two-way matches, and XLOOKUP migration tips for analysts.
How to Insert Checkbox in Excel: Developer Tab + COUNTIF Uses
How to insert checkbox in Excel: enable Developer tab, link cells to TRUE/FALSE, count checked boxes, and build interactive task trackers step by step.
How to Merge Two Cells in Excel: Merge vs CONCAT vs TEXTJOIN
How to merge two cells in Excel: Merge & Center, the & operator, CONCAT and TEXTJOIN. Keep values safe, fix sorting issues, and choose the right method.
Normalization in SQL: 1NF, 2NF, 3NF & BCNF Explained with Examples
Learn normalization in sql with step-by-step table examples from unnormalized data to 1NF, 2NF, 3NF, and BCNF to eliminate data anomalies.