Main Profile

At A Glance

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

Contact

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

Want more info about Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question