Blog | Double Excel

OpenAI Power Query Tool

Dynamic Drop Down Lists

Start from scratch: Finished file: If you've ever created a dashboard in Excel, you've probably added Data Validation drop down lists for...

INDIRECT: The Dark side of Excel

Has your manager ever told you the tragedy of Darth Indirect the wise? I thought not. It's not a story the CPAs would tell you... At the...

Intro to Power Query

File and folder companion for the video. Make sure to unzip the files into a folder before starting! Interested in Power Query but not...

Dollar Cost Average (DCA) Formula in Excel

What is Dollar-Cost Average? Investors sometimes like to use the Dollar-Cost Average (or Dollar-Cost Averaging, DCA) buying strategy when...

1,073 views0 comments

Custom Amortization Function in Excel Using LAMBDA

File download: The first ever financial model I can remember making was an amortization schedule, and I'd venture a guess that you've...

Subscribe Blog Page