The FP&A GUY Education Videos
(FP&A and Excel)
Best-Practice Budgeting Tips for FP&A Professionals
How you can build trust with business partners.
In this video I share some how to do the following using the Xlookup Function:
Write a nested Xlookup function to lookup both a row and column in one formula
Explain how to write a Nested Xlookup function using Excel tables
Demonstrate how to sum a range of data using the xlookup function
To download the file used in this video, click on the link below:
In this video, I demonstrate several uses cases for the ISNA() function and how you can use #N/A to improve the quality of your graphs in Excel.
In this video, I explain how to write a formula using Excel tables and why when you drag it across with your mouse using the fill handle, the formula does not update correctly, and how to solve that problem.
Learn all about the unique function and how easy it is in Excel 365 to create a unique list.
Download the file here:
In this video I demonstrate how to create a dynamic sensitivity table that automatically adjusts the size and numbers based on data inputs using dynamic arrays.
In this video I show two cool use cases for dynamic arrays and how they can change the way you will work in Excel.
In this video, I show what is possible with Dynamic Arrrays. Special thanks to Mike Girvin for helping me realize what is possible with the new HSTACK and VSTACK formulas.
In this video, I show you how to quickly convert your data to a proper table format using the Unpivot feature in Power Query.
In this video best-selling authors Bob Burg and Mark Sanborn talk about the Fred Factor and The Go-Giver and share some common life learnings.
Episode 1 Welcome to Budgeting Excel Hell
In this video Khaled Chowdury and I discuss many of the common challenges one faces using Excel for budgeting and Forecasting.