Using Flexible Functions in Excel (only for advanced users).

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0251 Flexible functions.zip ★ About this video ★ In this video, we uncover a powerful yet unknown Excel feature that allows us to use dynamic functions and dynamic ranges in a single calculation. It provides users with the flexibility to select the calculations they wish to see. If you're ready, let's get started. 0:00 Introduction 0:18 Dynamic SUBTOTAL calculation 1:20 Dynamic ranges 3:13 Dynamic AGGREGATE calculation 5:08 Choose your own function calculation 8:49 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel