Video scenes shots:
Watch the video:
| URL: | |
| Embed: |
Display Video Comments | Hide Video Comments | Add Comment
Other videos by this author:
 |
How to Perform Time Period Calculations in Excel Posted by: DannyRocksExcels
Video duration: 475 seconds Related: N/A Display Video Comments | Hide Video Comments | Add Comment |
Latest comments made on this video:
By: DannyRocksExcels. on 04 Oct 11, 09:56:28
With Goal Seek, you can only change one variable at a time. So, in this case, I copied the cells to create 3 scenarios - changing, 1 at a time the Interest Rate, the amount borrowed and the number of payments. In Excel, you can use the SCENARIO Manager to create a multiple variable Report. Typically, with Scenario Manager, you would create a "Best Case, Worst Case,? Case Most Likely" Report. I have a few videos here that demonstrate Scenarios. Danny Rocks The Company Rocks
By: zxcvbnmmasdfghjkl. on 04 Oct 11, 04:32:37
you did it three different times, is there a way to do it all in one or would you have to do all? three separately like you did?!?!?!
By: DannyRocksExcels. on 12 Sep 11, 19:25:26
Thank you! I am pleased that you liked? the video tutorial. Danny Rocks The Company Rocks
By: DannyRocksExcels. on 12 Sep 11, 19:24:33
I apologize for the late response. Solver is one of the videos that I am planning to produce in the near future. Danny? Rocks The Company Rocks
By: DannyRocksExcels. on 12 Sep 11, 19:23:06
Thank you! I am? pleased that you liked the video tutorial. Danny Rocks The Company Rocks
By: nita098. on 12 Sep 11, 19:17:20
great example! thanks a lot :)?
By: gammaphoton. on 07 Jan 11, 21:04:15
Danny I find your videos very helpful. You have not made a video for Solver. I? have a suggestion that I think your viewers will find helpful. I have a small spread sheet of my credit cards balance, % interest and payments. The Solver finds the minimum interest total from all the accounts to get all balances to zero. What I found is that paying off the highest interest rate card off first does not give you the smallest total interest paid. I am eager to see what you come up with.
By: DannyRocksExcels. on 28 Aug 10, 17:59:40
Thank you for letting me know that this helped you. Please spread the word to your friends and colleagues. I invite you to visit my website - thecompanyrocks - to view? all of my training resources. Danny Rocks The Company Rocks
By: ericdmann. on 28 Aug 10, 17:46:41
Another great? tutorial!
By: MaksKelemina. on 19 Jun 09, 04:19:35
Awsome! Can you post PMT function? in reverse for retirement monthly income
By: 77mazinger. on 25 Dec 08, 04:23:26
Your instruction is very easy to follow. Thanks so much.?
By: wa82001. on 09 Oct 08, 20:54:47
Great Tutorial, Helped me out a lot Thank? You!
By: DannyRocksExcels. on 20 Aug 08, 12:29:40
Thank you? for your feedback. I try my best to include relevant examples in my teaching. It is not sufficient to just understand "how" to use an Excel technique. You must understand "when" to use it and "why" it matters - to your audience. I'm pleased that this lesson has helped you.
By: tirathmistry. on 20 Aug 08, 12:19:07
Excellent tutorial Very well use of Goal Seek function and awesome explanation with? awesome example.