Intermediate Excel Training Lesson 5 Module 2 - Using References in Formulas
Автор: Dr Ben
Загружено: 2026-01-06
Просмотров: 17
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: