Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation
Loading...
Loading...
5,759
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (13)
-
Thank you for all your videos.
How can I create an amortization schedule to compare pay off times and interest savings by making payments on a bi weekly basis rather than monthly basis?
-
Try asking Excel questions at the best Excel question site around:
mrexcel[dot]com/forum
It is easier to post Excel solutions at this site (YouTube Comments don't allow us to do much)
-
What if You were pay a different payment every month and also have lump sum payments here and there?
-
You are welcome!!
Loading...
3:12
Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell Referencesby ExcelIsFun2,735 views- 5:00
Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods)by ExcelIsFun11,485 views
- 8:42
Excel Magic Trick 517: Vendor Name For Low Bid & % Cheaper Than Next Lowest Bid Formulaby ExcelIsFun1,086 views
- 7:57
Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changedby ExcelIsFun3,009 views
- 3:41
Excel 2010: Conditional Formattingby gcflearnfree23,834 views
- 1:38
How to Payoff your mortgage in 7 years without using your money.by MrAlanKendall20,784 views
- 5:14
Pay Off Mortgage Earlyby JimMitchellGuidance5,993 views
- 8:33
Excel Magic Trick 564: Daily Gantt Chartby ExcelIsFun15,500 views
- 2:08
Dave Ramsey, "Pay Off Mortgage" Money Makeover - 7/10by 100huntley65,534 views
- 11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Throughby ExcelIsFun11,544 views
- 6:48
Loan interest amortization caLcuLator Loan interest rate formuLaby Emotion888988935 views
- 1:11
Let Your Mortgage Make You Rich - An Introby PollyWallyWoo1,709 views
- 1:18
The Very Best Amortization Table Schedule - MS Excelby VeryQuickTuts1,904 views
- 0:35
How to Make an Amortization Scheduleby ofurkindin3,162 views
- 9:02
Excel 2010 Training-Loan Amortization Table by BusinessDictionary.usby BusinessDictionary445 views
- 8:55
Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functionsby ExcelIsFun10,587 views
- 3:46
Suze Orman Paying Off Your Mortgage Earlyby anagramfinancial28,355 views
- 11:14
Excel Magic Trick 565: Excel 2010 Daily Gantt Chartby ExcelIsFun20,768 views
- 8:04
Excel Magic Trick 255: Data Table 2 Variable What If Analysisby ExcelIsFun30,748 views
IS THAT A DOLLAR SIGN?? PLEASE TELL ME
kizunakenzo 11 months ago
Your question is not clear.
ExcelIsFun 11 months ago
@ExcelIsFun because sir i noticed that when you are typing the formulas. instead of D1 but D$1
and i dont get it.....i dont know how to make formula in excel
but happily i am the one who got the highest score among my classmates in ammortizations. haha. but i am still a first year commerce student.it is still basic...
kizunakenzo 11 months ago
If you wnat to learn more about cell references, search for "Excel Mixed Cell References" and you will see i have many videos on this topic...
ExcelIsFun 11 months ago
@ExcelIsFun thanks !!!!
kizunakenzo 11 months ago
You are welcome!
ExcelIsFun 11 months ago