MM0026 - 25/05/20 - The Power Of Excel INDIRECT 1

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 - Concept
  •  | RANDBETWEEN
  •  | Create A Dropdown Menu
  •  | INDIRECT - Worksheet Setup
  •  | INDIRECT - Formula Setup
  •  | INDIRECT For Dynamic Sum
  •  | Chris's Favourite Windows Shortcut
  •  | SUBSTITUTE
  •  | OFFSET - Drawbacks
  •  | Best Screen Recorder
  •  | Dynamic Dropdown Using INDIRECT
  •  | COUNTA
1 Lesson