MM0027 - 01/06/20 - The Power Of Excel INDIRECT 2

INDIRECT is an Excel formula with special powers; in this livestream, I show you how I have been harnessing INDIRECT to create cool dynamic functions in Excel files

Topics

  •  | INDIRECT - Dynamic Explanation
  •  | Dropdown Menu Setup
  •  | Discussion: INDIRECT vs. Pivot Tables
  •  | Insert A Chart
  •  | Delete A Series From A Chart
  •  | Dynamic Chart Using INDIRECT
  •  | Create A Named Range
  •  | Check A Dynamic Named Range
  •  | Dynamically Define A Data Range
  •  | MATCH
  •  | COUNTIF
  •  | & To Create A Text String
1 Lesson