Master Microsoft Excel

Basic Pivot Report

noreply@blogger.com (Unknown) — Thu, 12 Aug 2010 22:09:00 -0700

http://www.youtube.com/watch?v=hxmv8y643dwendofvid
[starttext]

[endtext]

Basic Pivot Report

noreply@blogger.com (Unknown) — Thu, 12 Aug 2010 05:17:00 -0700

http://www.youtube.com/watch?v=B3Wd50F3vgcendofvid
[starttext]

[endtext]

Sort & Filter

noreply@blogger.com (Unknown) — Thu, 12 Aug 2010 03:50:00 -0700

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]

Computing Multiple IRR

noreply@blogger.com (Unknown) — Wed, 9 Jun 2010 03:12:00 -0700

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 retirement_problem_using Excel Formula

noreply@blogger.com (Unknown) — Wed, 9 Jun 2010 02:39:00 -0700

http://www.youtube.com/watch?v=vxghBCbvHhQendofvid
[starttext]
We can also use Excel's Function to calculate the retirement problem.
[endtext]

Computing retirement_problem

noreply@blogger.com (Unknown) — Wed, 9 Jun 2010 01:05:00 -0700

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 Irr_with_RATE

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 18:44:00 -0700

http://www.youtube.com/watch?v=3QVDjak-N7gendofvid
[starttext]

[endtext]

computing IRR_by_loan_table

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 11:03:00 -0700

http://www.youtube.com/watch?v=Cj_eohUpMr8endofvid
[starttext]

[endtext]

Computing Irr_loan_table

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 10:44:00 -0700

http://www.youtube.com/watch?v=11QEEnZinDEendofvid
[starttext]

[endtext]

computing IRR_trial_err

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 09:54:00 -0700

http://www.youtube.com/watch?v=X06w1rrrMMkendofvid
[starttext]
[endtext]

Computing Growing Infinite Annuity

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 08:58:00 -0700

http://www.youtube.com/watch?v=CxBmzml3h0Eendofvid
[starttext]

[endtext]

Computing_Growing_Finite_Annuity

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 05:51:00 -0700

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 infinite annuity

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 02:42:00 -0700

http://www.youtube.com/watch?v=UwefdwiJsO8endofvid
[starttext]

[endtext]

computing finite annuity

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 01:34:00 -0700

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 Net Present Value

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 01:21:00 -0700

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 Present Value with inconstant cash flow

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 00:52:00 -0700

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

noreply@blogger.com (Unknown) — Tue, 8 Jun 2010 00:02:00 -0700

http://www.youtube.com/watch?v=ahVB3wQM8tIendofvid
[starttext]
To get one dollar today, or tomorrow ? one dollar today is worth than one dollar tomorrow. This will guide you about how to calculate the present value of constant cash flow in next five year. To make decision about will you accpet the offer or not you have to understand about its present value. to download file practice click_here
[endtext]

Histogram

noreply@blogger.com (Unknown) — Wed, 2 Jun 2010 02:59:00 -0700

http://www.youtube.com/watch?v=-SbmPA1Yp1gendofvid
[starttext]
Image means thousand words. Truly, we can represent the sample data with picture, the descriptive statistics with histogram. Histogram graph used with quantitative data, not with qualitative data. ....To download the file click here
[endtext]

Descriptive Statistics

noreply@blogger.com (Unknown) — Wed, 2 Jun 2010 01:58:00 -0700

http://www.youtube.com/watch?v=FxVc8aeZbY4endofvid
[starttext]
To descriptive the statistics, sample, we use different type of calculation depended on the data types: quantitative, measurement like weights, salary, time of waiting line; qualitative, category, label like sex, number of baby. We will learn here about to sum up the sample, mean or average, the variation of data, known as standard deviation....
download the file click here
[endtext]

Graph-001

noreply@blogger.com (Unknown) — Tue, 1 Jun 2010 10:22:00 -0700

http://www.youtube.com/watch?v=nYGc_z4z0kMendofvid
[starttext]
To build the graph to analyze the trend of earning per share, and the relationship of earning per share and price per stock. to download the file_practice
[endtext]

IRR- internal rate return

noreply@blogger.com (Unknown) — Tue, 1 Jun 2010 03:24:00 -0700

http://www.youtube.com/watch?v=S-y3sme-m_wendofvid
[starttext]
As previous lesson, NVP which is the difference between sum of present value of all expected cash flow and initial investment. To know NVP is not enough. To make the investment decision more effective, we need to calculate the
[endtext]

lookup vs. index(match(

noreply@blogger.com (Unknown) — Tue, 25 May 2010 20:20:00 -0700

http://www.youtube.com/watch?v=fFA0PfsQxCoendofvid
[starttext]
This is most popular function and also misuse of these function. Now you have a chance to make yourself understand clearly about these function. to download practice_file_click_here
[endtext]

Match../002

noreply@blogger.com (Unknown) — Sun, 23 May 2010 03:26:00 -0700

http://www.youtube.com/watch?v=Rw65VGjmCo8endofvid
[starttext]
This will detail about match-type: exact match, less than, and greater than. This is so popular to use with other function like "Index". to download the file_of_lesson_click_here.
[endtext]

index(match(

noreply@blogger.com (Unknown) — Sat, 22 May 2010 23:39:00 -0700

http://www.youtube.com/watch?v=3RCbB_RQdTYendofvid
[starttext]
It's an alternative of "vlookup" function.
[endtext]

match...

noreply@blogger.com (Unknown) — Sat, 22 May 2010 20:52:00 -0700

http://www.youtube.com/watch?v=45f0GVtA0ksendofvid
[starttext]

[endtext]