Copy-ready examples · formulas · code · workflows

Examples you can copy, understand and adapt.

A practical library for Excel formulas, Power BI DAX, SQL, Google Sheets, code snippets, dashboard ideas and everyday work examples.

Start with Excel Browse topics

📊 Excel 📈 Power BI DAX 🗄️ SQL 🟩 Google Sheets 🔄 Power Query 🐼 Python Pandas 🔍 Regex 🎨 CSS 🌐 HTML ⚙️ JavaScript

Main example libraries

Excel is complete for this version. The other topic hubs are already placed in the structure so each next folder can be added without redesigning the site.

Excel

Ready now with 53 detailed Excel pages.

Explore examples 📈

Power BI DAX

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🗄️

SQL

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🟩

Google Sheets

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🔄

Power Query

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🐼

Python Pandas

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🔍

Regex

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🎨

CSS

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🌐

HTML

Coming next: examples, workflows and copy-ready patterns.

View roadmap ⚙️

JavaScript

Coming next: examples, workflows and copy-ready patterns.

View roadmap 📝

Markdown

Coming next: examples, workflows and copy-ready patterns.

View roadmap 🌿

Git & GitHub

Coming next: examples, workflows and copy-ready patterns.

Featured Excel examples

Start with the most common lookup, logic, summary, text, date and workflow examples.

All Excel pages

XLOOKUP Examples in Excel

XLOOKUP searches for a value in one range and returns a related value from another range. It is usually the best modern ...

VLOOKUP Examples in Excel

VLOOKUP looks for a value in the first column of a table and returns a value from a column to the right....

HLOOKUP Examples in Excel

HLOOKUP searches across the first row of a table and returns a value from a lower row....

INDEX MATCH Examples in Excel

INDEX MATCH combines MATCH to find a position and INDEX to return a value from that position....

MATCH Examples in Excel

MATCH returns the position of a value inside a range....

XMATCH Examples in Excel

XMATCH is a modern version of MATCH with clearer options for exact matching and search direction....

IF Formula Examples in Excel

IF returns one value when a condition is true and another value when it is false....

IFS Examples in Excel

IFS checks multiple conditions in order and returns the result for the first true condition....

AND and OR Examples in Excel

AND returns TRUE only when every condition is true. OR returns TRUE when at least one condition is true....

💡 Useful resources

Here are some ideas for you

Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.

📘
Excel formula books
Practice formulas with structured examples you can keep beside your desk.
See ideas
⌨️
Excel shortcut guides
Build speed with keyboard shortcuts for selection, formatting and navigation.
See ideas
🔢
Numeric keypads
Helpful if you enter many numbers on a laptop or compact keyboard.
See ideas
🖥️
External monitors
Useful for viewing large worksheets, formulas and reference tables side by side.
See ideas
📒
Desk notebooks
Sketch formula logic, report ideas and table structures before building.
See ideas
💻
Laptop stands
Make long spreadsheet sessions more comfortable and ergonomic.
See ideas

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