# 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.

## Related pages

- [OrcAI](/docs/orcai)
- [Pivot Tables](/docs/pivot-tables)
- [Creating Visualizations](/docs/creating-visualizations)
- [Column Statistics](/docs/column-statistics)