Lambda The Game Changer in Excel Financial Modelling || Practical Examples in Cost Analysis

Published: 13 May 2022
on channel: Lighthouse Analytix

923

Real life examples of Lambda in practice - making it easier for to perform complex calculation & historical analysis, create what if analysis and create cost calculator....

Lambda is a game changer in Excel financial modelling as it allows you to create your own Excel Formula... or more precisely, your own Excel Function.

Lambda will give you more options in performing scenario & what if analysis.
You no longer have to rely on data table.
With Lambda, the option in endless.

You can also use Lambda to create a cost calculator... without revealing your IP or calculation method.... You can keep sensitive information private from your audience !!!

This video is part 1 of my two series Lambda video.
In my next video I will show you how to create Lambda from scratch as well as introduce you to Lambda best practice method as recommended by Microsoft....
Stay tune....

Cheers,
Isabella Susilowati
#LighthouseAnalytix
#ExcelTutorial, #excel, #exceltips

Timelines:
00:00 Introduction
01:23 What is Lamda
02:41 Benefit #1 Historical Analysis made quick and easy
03:09 Benefit #2 What-If Analysis made quick and easy
03:57 Benefit #3 Cost Calculator made quick and easy

LA49a