---
slug: using-macros
title: Using Macros
section: Core Workflows
description: Create calculated columns with macro formulas and functions.
listed: true
navOrder: 9
---
# Using Macros

**Macros create calculated columns with formulas and functions, so you can derive new fields (cleaning, bucketing, or computing metrics) without ever touching the original data.**

## Create a Macro column

1. **Click** the **Macro** icon in the toolbar.
2. **Write** a formula:
   - Type `$` to list available column names.
   - Type `?` to list available functions.
3. **Press** `Ctrl + Enter` to execute.

## Examples

- `$Price * $Quantity`
- `?UPPER($Name)`
- `$Revenue - $Cost`

## Notes

- Macros create **new** columns. They do not modify existing columns or the source data.
- For anything more complex than a one-line formula, try [OrcAI](/docs/orcai) instead: describe the transformation in plain English and let OrcAI generate the Macro for you.
- For multi-step preprocessing that should produce a new analytics-ready sheet, use [AI SQL Editor](/docs/ai-sql-editor).

## Related pages

- [OrcAI](/docs/orcai)
- [AI SQL Editor](/docs/ai-sql-editor)
- [Pivot Tables](/docs/pivot-tables)
- [Creating Visualizations](/docs/creating-visualizations)
- [Column Statistics](/docs/column-statistics)
