Intermediate Excel Training Lesson 5 Module 2 - Using References in Formulas

In this module, the instructor discusses the types of cell references used in Excel such as relative reference, absolute reference, and mixed references. A conversation about using named references and worksheet references, as well as workbook references, is also had along with demonstrations. Table of Content 00:00 Introduction 01:13 Use Relative Cell Reference in a Formula 02:41 Relative Cell Reference 06:12 Absolute Cell Reference 08:40 Formula Example for Absolute Cell Reference 11:14 Mixed Cell References 17:49 Named Ranges and Formulas 22:45 Paste Names Options 23:41 Worksheet References 26:35 Workbook References 29:40 Knowledge Check 31:07 What Did we Learn 31:30 End of Module 2