Systematic description of what Excel can do from beginning to end. In this video you will see: How to use the 4 types of Cell References in Formulas. Create your formulas 144 times as fast! See how to use Absolute, Relative and Mixed Cell References.
One of the most overlooked concepts in Excel, yet extremely powerful, the 4 types of Cell References in Formulas will allow you to create formulas much more quickly and will allow you to utilize advanced features like Conditional Formatting, Advanced Filter, Named Formulas, and Data Validation more efficiently.