Function Vault
Your functions, ready when you are.
Everything you need at your fingertips.
Function Vault is an Excel add-in that allows you to store and quickly insert custom functions for Excel and Power Query into any workbook
No more hunting through old workbooks or losing track of powerful formulas. Whether it is your own custom functions or from our Quick Calc and Quick Steps libraries, everything you need will be ready to use at any moment.
We understand the frustration of knowing you have an existing solution, but just can’t remember where it is. That’s why we built Function Vault.
Function Vault brings order to the chaos.
It’s your personal library of custom functions, sitting right in the ribbon.
✓ Instant access: All your custom functions are ready to be inserted with a single click.
✓ Powerful search: Find what you need with keywords and tags.
✓ Centralized storage: Keep your LAMBDA and Power Query functions in one place.
✓ Customizable library: Easily add, remove, and rename functions to suit your needs.
Your functions when you need them
Function Vault sits in your Excel ribbon and provides the tools you need to store, insert, and edit custom functions.
- Separate LAMBDA and Power Query libraries
- Search by name or search tag
- Insert individual functions or the entire library
- Import functions from existing workbooks
- Edit existing functions within the library
Start using Function Vault Today.
Join the Excel Academy
Enrol today to get instant access to Function Vault.
Install the Add-in
Follow our simple step-by-step guide to add Function Vault to your Excel ribbon.
Populate your library
Add your own custom functions, or simply install our Library of powerful LAMBDA and Power Query functions.
Access with ease
Search and insert your custom formulas into any workbook with 1-click.
Function Vault is only available within the Excel Academy.
Why do you need Function Vault?
✓ End the frustration of not being able to find the solution you already know exists.
✓ Spend less time searching and more time building impactful analysis and automation.
✓ Your complete library of solutions is just a click away.
System requirements
Windows PC Only | VBA macros enabled.
- Use with Power Query functions: Excel 2016 or later (including Excel 365)
- Use with LAMBDA functions: Excel 2024 or later (including Excel 365)
As an Excel Academy member, you will also gain access to:
Dynamic Formulas Unleashed
The complete course to master modern Excel formulas and custom functions.
Quick Calc
An extensive library of pre-built, easy-to-apply, LAMBDA functions that solve common scenarios that Excel users face every day.
Quick Steps
An extensive function library for Power Query, filled with easy transformations for tricky scenarios.
Get all your LAMBDA and Power Query functions in one place, ready to use.
Function Vault is only available within the Excel Academy.