|
|
|
|
|
by DavidPeiffer
972 days ago
|
|
>I think one challenge is that the variable names in Excel (B3, B2-10 for a list) are not easily converted to descriptive names. It takes some getting used to, but you can pretty easily create a named range for an individual cell by modifying the value immediately left of the formula bar. You can also setup a table to hold data (insert -> table). Tables can be renamed and allow formulas like =sum(tbl_salaries[salary]). With named ranges, your formula can look like =purchase_price*sales_tax |
|