### Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

Download file: http://people.highline.edu/mgirvin/excelisfun.htmThis 50 minute video shows 15 examples of how to use Cell References:1)Relative Cell References2)Absolute Cell References3)Mixed Cell References With Column Locked4)Mixed Cell References With Row Locked5)Formula for Commissions6)Formula for Deduction Calculation7)Multiplying Table for Memorization Trick8)Financial Forecast Formula (Budget Formula) 4 examples9)Markup On Cost and Profit Formula10)Running Total Formula11)Conditional Summing Formula SUMIFS and SUMPRODUCT Formulas12)Conditional Averaging Formula AVERAGEIF and SUMPRODUCT Formulas13)Conditional Formatting Formula for Row In Bank Reconciliation Table14)Conditional Formatting Formula for Highlighting Duplicates15)Data Validation Formula for Preventing Duplicates

Length:
49:42