top of page

Twice the Excel
Half the Time
Nick
- Aug 21, 2022
- 1 min
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...
48 views0 comments


Nick
- Jun 25, 2022
- 4 min
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...
23 views0 comments


Nick
- Jun 19, 2022
- 1 min
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...
27 views0 comments

Nick
- Jun 9, 2022
- 3 min
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,368 views0 comments

Nick
- Jun 6, 2022
- 7 min
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...
212 views0 comments
Subscribe Blog Page
bottom of page