EXCEL Real time problems and solution
(Covering real time financial, accounting and day to day
office problems)
Shivprasad Koirala
Sham Sheikh
Visit us at http://www.questpond.com for more details.
This book is a sample book. For buying a hard copy
please contact shiv_koirala@yahoo.com or call at
9967590707. We conduct EXCLUSIVE excel classes in
Mumbai for working class people. After the course you
can solve your day to day cryptic office issues with ease.
Please call 9967590707 for more details.
Common Formulas....................................................................................................................... 3
How to find average of a given set of results?......................................................................... 3
What is the use of Goal seek command? ................................................................................. 3
How do we concatenate in excel?............................................................................................ 4
Investment, loan and Interest calculation..................................................................................... 5
How can we calculate compounding interest in excel? ........................................................... 5
How do we calculate future and present value for series of cash flow? .................................. 7
What are data tables and how can it helps us?......................................................................... 9
To achieve 61051 INR after 5 yrs at 10% interest rate what should be the yearly investment
amount?.................................................................................................................................. 18
How do we calculate number of years for given rate of interest and loan value? ................. 19
How do we calculate rate of interest? .................................................................................... 20
You have two models of investments you want to know which is the best?.......