3
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/08/basic-pivot-report_12.html[/postlink]http://www.youtube.com/watch?v=hxmv8y643dwendofvid
[starttext]

[endtext]

Basic Pivot Report

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/08/basic-pivot-report.html[/postlink]http://www.youtube.com/watch?v=B3Wd50F3vgcendofvid
[starttext]

[endtext]

Basic Pivot Report

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/08/httpwww.html[/postlink]http://www.youtube.com/watch?v=pt1h1yZBsQoendofvid
[starttext]
data is meaningless unless it was sorted, filter, or summed as the expected result. this you will learn about how to sort and filter the complex data into useful information.
[endtext]

Sort & Filter

Labels:
2
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-multiple-irr.html[/postlink]http://www.youtube.com/watch?v=r03QQ7yW_jEendofvid
[starttext]
In this case there are two IRR. IRR is the internal rate of return where the NPV is equal to zero. Excel provides easy to the calculate of IRR....to download practice file click_here
[endtext]

Computing Multiple IRR

Labels:
1
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-retirementproblemusing-excel.html[/postlink]http://www.youtube.com/watch?v=vxghBCbvHhQendofvid
[starttext]
We can also use Excel's Function to calculate the retirement problem.
[endtext]

Computing retirement_problem_using Excel Formula

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-retirementproblem.html[/postlink]http://www.youtube.com/watch?v=Tldz3A7NW6wendofvid
[starttext]
Mr.Kevin plans to retire at 60 years old. He calculates his annual expense equal to 4500USD, which will get for 8 years. He is now 53, he want to deposit in the bank saving account, annual interest 8%. The question is he doesn't know how much should he put him money in the bank?..
..to download file click_here
[endtext]

Computing retirement_problem

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-irrwithrate.html[/postlink]http://www.youtube.com/watch?v=3QVDjak-N7gendofvid
[starttext]

[endtext]

Computing Irr_with_RATE

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-irrbyloantable.html[/postlink]http://www.youtube.com/watch?v=Cj_eohUpMr8endofvid
[starttext]

[endtext]

computing IRR_by_loan_table

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-irrloantable.html[/postlink]http://www.youtube.com/watch?v=11QEEnZinDEendofvid
[starttext]

[endtext]

Computing Irr_loan_table

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-irrtrialerr.html[/postlink]http://www.youtube.com/watch?v=X06w1rrrMMkendofvid
[starttext]
[endtext]

computing IRR_trial_err

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-growing-infinite-annuity.html[/postlink]http://www.youtube.com/watch?v=CxBmzml3h0Eendofvid
[starttext]

[endtext]

Computing Growing Infinite Annuity

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computinggrowingfiniteannuity.html[/postlink]http://www.youtube.com/watch?v=-wa9QDgqtawendofvid
[starttext]
Tary works for one company for 5 years, each year she will earn 1000 USD. And she estimates that 6% growth per years., at the second year she can earn 1060...
[endtext]

Computing_Growing_Finite_Annuity

Labels:
1
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-infinite-annuity.html[/postlink]http://www.youtube.com/watch?v=UwefdwiJsO8endofvid
[starttext]

[endtext]

computing infinite annuity

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-finite-annuity.html[/postlink]http://www.youtube.com/watch?v=DqH8hKY5zAUendofvid
[starttext]
Dara want to know what is today present value of constant cashflow 1000USD which he will receive for five years. .to download click_here
[endtext]

computing finite annuity

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-net-present-value.html[/postlink]http://www.youtube.com/watch?v=SdHw7UTjwX4endofvid
[starttext]
Sarun invested 500 USD today. and expected to earn at the end of each year 200 USD for five year. As known that the discount rate is 12%, would Sarun decide to invest ?
if NPV is greater than zero. he should invest. otherwise don't. ....how to calculate NPV? ..to download click_here
[endtext]

computing Net Present Value

Labels:
0
[postlink]http://mastermicrosoftexcel.blogspot.com/2010/06/computing-present-value-with-unstable.html[/postlink]http://www.youtube.com/watch?v=52Jo0Yq3Kjoendofvid
[starttext]
As estimated cashflow will be 100,200,300,450,500 at year 1,2,3,4,5, respectively. What is the present value of this series of inconstant cashflow? check it out,,to download the file click_here
[endtext]

Computing Present Value with inconstant cash flow

Labels:
Subscribe to: Posts (Atom)