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.
View this page on OrcaSheets