# Visual-level formulas

<table data-header-hidden><thead><tr><th width="325"></th><th></th></tr></thead><tbody><tr><td><a href="visual-level-formulas/excel-like-cell-editing">Excel-like cell editing </a>(04:36)</td><td>Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells</td></tr><tr><td><a href="visual-level-formulas/quick-formula-options">Quick formula options</a> (03:00)</td><td>Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group​</td></tr><tr><td><a href="visual-level-formulas/smart-analysis">Smart analysis</a> (03:01)</td><td>Perform one-click contribution and variance analysis without using DAX</td></tr><tr><td><a href="visual-level-formulas/excel-like-formula-editor">Excel-like formula editor</a> (04:21)</td><td>Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers</td></tr><tr><td><a href="visual-level-formulas/calculated-measures-and-columns">Calculated measures and columns</a> (02:31)</td><td>Add custom calculations as columns and measures  without having to create new DAX measures or calculated columns in the data table</td></tr><tr><td><a href="visual-level-formulas/4-ways-of-inserting-rows">4 ways of inserting rows</a> (06:09)</td><td>Insert static, calculated, contribution and template rows in Power BI</td></tr><tr><td><a href="visual-level-formulas/evaluate-columns-before-rows">Evaluate column before rows</a> (01:49)</td><td>Configure the column total and subtotal calculations when inserting calculated rows</td></tr><tr><td><a href="visual-level-formulas/manage-aggregations">Manage aggregations</a> (4:00)</td><td>Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation</td></tr><tr><td><a href="visual-level-formulas/automatic-variance-calculations">Automatic variance calculations (1:44)</a></td><td>View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields</td></tr></tbody></table>