ExamplesFor You
Copy-ready examples · formulas · code · workflows

Examples you can copy, understand and adapt.

A practical examples library for spreadsheet formulas, DAX measures, SQL queries, Power Query steps, Python Pandas code, web snippets, dashboards, KPIs and business templates.

Start with Excel Browse all topics

💡 Ideas for You

Learning resources for formulas, data skills, code snippets and reporting.

4 useful links

Some links in this section may be affiliate links. Choose only what is useful for your own work.

📊 Excel 📈 DAX 🗄️ SQL 🟩 Sheets 🔄 Power Query 🐼 Pandas 🤖 VBA 🌐 HTML 🎨 CSS ⚙️ JavaScript 🔍 Regex 🌿 Git

Browse example libraries

Each topic is organized as a searchable hub with copy-ready examples, practical explanations, common mistakes, FAQs and related links.

📊

Excel

Formulas, lookups, logical tests, summaries, text cleanup, dates, dynamic arrays and workbook workflows.

53 pages 📈

Power BI DAX

Measures, filter context, iterators, time intelligence, relationships, rankings and business KPIs.

65 pages 🗄️

SQL

SELECT, WHERE, JOIN, GROUP BY, CTEs, window functions, data checks and reporting queries.

76 pages 🟩

Google Sheets

QUERY, IMPORTRANGE, ARRAYFORMULA, FILTER, regex formulas, trackers, dashboards and workflows.

77 pages 🔄

Power Query

Clean, reshape, merge, append, unpivot, group and transform data for Excel and Power BI.

50 pages 🐼

Python Pandas

Read files, filter rows, group data, merge tables, clean columns, pivot data and export reports.

62 pages 🤖

VBA & Office Scripts

Excel automation examples for macros, workbook tasks, Outlook workflows and Office Scripts.

60 pages 🌐

HTML

Forms, tables, links, images, semantic layout, metadata and page structure examples.

35 pages 🎨

CSS

Buttons, cards, grids, flexbox, responsive layouts, forms, animations and visual components.

55 pages ⚙️

JavaScript

Arrays, DOM, forms, events, search filters, local storage, dates, JSON and useful UI patterns.

58 pages 🔍

Regex

Patterns for emails, phones, dates, URLs, extraction, replacement, validation and text cleanup.

35 pages 📝

Markdown

Tables, checklists, README files, links, images, code blocks, badges and GitHub Markdown.

24 pages 🌿

Git & GitHub

Commits, branches, merges, pull requests, .gitignore, README files and common workflows.

35 pages 📌

Dashboards & KPI

Dashboard layouts, KPI formulas, executive summaries, reporting pages and business metrics.

50 pages 📊

Data Visualization

Chart examples, visual choices, color use, comparison layouts and dashboard storytelling.

40 pages 🧾

Business Templates

Status reports, meeting notes, project updates, follow-up messages, checklists and summaries.

40 pages

Popular starting points

Useful pages to open first if you are learning formulas, queries, dashboards or code examples.

Excel

XLOOKUP examples

Find prices, departments, missing items and two-way lookup results with copy-ready formulas.

 Excel

SUMIFS examples

Sum values by date, customer, category, status and multiple reporting conditions.

 DAX

CALCULATE examples

Change filter context and build practical Power BI business measures.

 DAX

Running total examples

Create cumulative sales, orders, revenue and trend measures in Power BI.

 SQL

JOIN examples

Combine tables, explain match logic and avoid duplicate-row join mistakes.

 SQL

Window function examples

Rank rows, calculate running totals and compare values without collapsing detail.

 Sheets

QUERY examples

Filter, group, sort and summarize data with Google Sheets QUERY formulas.

 Power Query

Merge queries examples

Join tables in Power Query using practical business and reporting cases.

 Pandas

groupby examples

Summarize data by customer, product, date, category and region in Python Pandas.