★ Get the example file ★ Sign up for our free Insiders program and get the example file: File Reference for this video: 0294 Functions values ★ JOIN THE FREE COURSE ★ Want to get the free Modern Excel Formulas course? Click here: ★ About this video ★ In this video, we explore a powerful, but little understood concept - functions as values. Which means that functions can be assigned to names, just like text, numbers and Booleans. This concept doesn't just impact Excel, we also show how it applies to Power Query. This is an advanced technique, so be prepared to have you mind blown. 0:00 Introduction 2:40 Basic calculation 3:29 Using functions as values 5:33 Applying eta reduction 6:26 Concept summary 7:04 Applying concept to Power Query 11:16 Wrap up ★ Want to automate Excel? Check out our training academy ★ ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ ★ Where to find Excel Off The Grid ★ Blog: Twitter: #Excel #DynamicArrays #SPILL #ExcelTips #ExcelOffTheGrid