Upload

Loading...

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

490,518 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Nov 5, 2009

Download file: http://people.highline.edu/mgirvin/ex...
This 50 minute video shows 15 examples of how to use Cell References:
1) Relative Cell References
2) Absolute Cell References
3) Mixed Cell References With Column Locked
4) Mixed Cell References With Row Locked
5) Formula for Commissions
6) Formula for Deduction Calculation
7) Multiplying Table for Memorization Trick
8) Financial Forecast Formula (Budget Formula) 4 examples
9) Markup On Cost and Profit Formula
10) Running Total Formula
11) Conditional Summing Formula SUMIFS and SUMPRODUCT Formulas
12) Conditional Averaging Formula AVERAGEIF and SUMPRODUCT Formulas
13) Conditional Formatting Formula for Row In Bank Reconciliation Table
14) Conditional Formatting Formula for Highlighting Duplicates
15) Data Validation Formula for Preventing Duplicates

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...