Publisher :an01digitalservices Date added : 14-Jun-2009 Rating : File size :
Unknown
Language :
English
License :
Shareware - Time Limit
Price : $ 15.00 OS :
Windows 98/NT/2000/ME/XP/VISTA
UpdateDate : 15-Jun-2009 Requirements :
No special requirements
NPV Caculator's Information
This, one sheet Excel workbook will let you understand and help you make an NPV model in Excel. It takes "Equipment" as an example to demonstrate NPV model, however this can be changed as per your needs.
This Template is accompanied by a PDF document which will help you undertand and implement NPV and IRR calculations in Excel.
After studying the document you will be able to
* Explain the concept of Time Value of Money
* Calculate the present value and future value of a stream of cash flows using excel
* Explain the types of cash flows encountered in financial analysis, and how to adjust for each type in making time value calculations in Excel.
* Differentiate between the alternative compounding periods, and use Excel to compare present and future values under different compounding schemes.
The template is unprotected, to make sure you can make appropriate changes.
The workbook and the document comes with a nominal cost of $15 and will work with Microsoft Excel Version 2002 onwards and any PDF reader.
Rating :
See How Easy it is to Learn Excel!!! <BR>
* Are you struggling to Learn Excel? <BR>
* Are you busy enough to not spend your time reading Excel books?<BR>
* Do you want to learn Excel to better contribute your existing job/work?<BR>
* Do you want to show your Excel skills like a pro in the next interview?<BR>
* Would you want to Learn Excel in a weekend?<BR>
If the answer to all/any of the question above is 'Yes' then this course is for you.
<BR>
<BR>
A series of 12 Lessons covering the most used Excel topics to make learning Excel very easy for you. These Video tutorials are a result of a 20 years of collective experience and covers all the topics here which should help you move on with Excel and become an intermediate level user of Excel.
<P>Video Contents Index
<P>(Those in Blue are sample Videos)
<P>Part 1. Basic Introduction
<P>1. What's new in 20072. The Ribbon Menu3. The Office Button 5. Keyboard Shortcuts
<P>Part 2: First Excel File
<P>1. Creating Excel Files2. Cells, Rows and Columns3. Entering Data4. Saving Files
<P>Part 3: Working with Worksheets
<P>1. Add, Delete and Rename2. Tab Colors3. Split Windows/Freeze Panes4. Hide and Unhide5. Protect and Un-Protect6. Working with Shapes
<P>Part 4: Cell Formats and Options
<P>1. Height and Width of Rows & Columns2. Types of data3. Align and Indent4. Font Options5. Hyperlinks6. Context Menu7. Insert, Delete and move columns, rows & Cells8. Cut, Copy and Paste9. Paste Special10. Clipboard11. Cell Borders12. Merge Cells13. Wrap Text
<P>Part 5: More on Formatting
<P>1. Conditional Formatting2. Data Validation3. Naming Ranges4. Special Characters5. Format Painter
<P>Part 6: Formulas and Functions
<P>1. Relative and Absolute Cell References2. Other Sheets references3. Functions4. Function Examples
<P>Part 7: Dealing with Data
<P>1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data
<P>Part 8: Finalizing the Workbook
<P>1. Check Spellings2. Cell Comments3. Hide Worksheets4. Find and Replace5. Lock and Unlock Cells
<P>Part 9: Printing Your Workbook
<P>1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks
<P>Part 10: Charts and Labels
<P>Part 11: Pivot Tables
<P>1. Build2. Options
Rating :
<P>This, one sheet Excel workbook will let you understand and help you make an NPV model in Excel. It takes "Equipment" as an example to demonstrate NPV model, however this can be changed as per your needs.
<P>
This Template is accompanied by a PDF document which will help you undertand and implement NPV and IRR calculations in Excel.
<P>
After studying the document you will be able to
<BR>
* Explain the concept of Time Value of Money
<BR>
* Calculate the present value and future value of a stream of cash flows using excel
<BR>
* Explain the types of cash flows encountered in financial analysis, and how to adjust for each type in making time value calculations in Excel.
<BR>
* Differentiate between the alternative compounding periods, and use Excel to compare present and future values under different compounding schemes.
<BR>
<P>
The template is unprotected, to make sure you can make appropriate changes.
<P>
The workbook and the document comes with a nominal cost of $15 and will work with Microsoft Excel Version 2002 onwards and any PDF reader.
Rating :
The Price Elasticity of Demand (commonly known as just price elasticity) measures the rate of response of quantity demanded due to a price change. The formula for the Price Elasticity of Demand (PEoD) is: PEoD = (% Change in Quantity Demanded)/(% Change in Price)
Rating :
This Add-in adds a Custom Function in your Excel® along with other built in functions which will help you easily translate text of strings from one language to other.
The function is very easy to use, and is used as any other Excel® function. There is a help file also available with this addin which details the various Languages that ca be converted using this add-in and the respective language codes.
This Add-in uses the Google Translate(TM) translation service API for translation.
This add-n is available to be downloaded for free. Give it a try and translate your workbook text into the language of your choice with ease.
Use this function as any other default function in MS Excel.
Rating :
Are you tired of complicated and expensive software that have too many settings to configure before you can produce a nice looking PDF from your Excel® files?
Easy Excel to PDF lets you convert Microsoft® Excel® Workbooks, individual Excel® Sheets and the selected ranges to PDF documents with a few simple clicks.
This Add-in for Excel® gets embedded into your Excel® so do not need to launch any other windows based software.
The Add-in works with the Active Workbook of you Excel® Application and all you need to do is to browse to the location where you like the PDF files to be generated.
The software automatically works out the PDF files names, the margins of the PDF files, the alignments, the orientation etc as per the content of your Excel® Workbook.
This add-in comes with a 15 day free trial for the functionality so so can try before you buy the software. Also, because the objective of things here is to make things easy, this addin is very reasonably priced so its easy on your pocket as well.
Also, you can check for regular updates through the software itself and all new updates will be automatically updated.
Please note that this application works with all versions of Excel® including Excel® 2010. The conversion happens only with .XLS files, however the software assists you to save your files to .XLS extensions before producing PDFs.
Features:
* Full font and text formatting: colors, face, size, bold, italic, underline, strike, superscript, subscript
* Export of spreadsheets with borders to PDF table preserving colors, line type and background
* Hyperlinks and ancors
* Special characters
* Multiple worksheets
* Various cell types: strings, numbers, dates, floating point
* Merged cells, row and cell width and height
* Formulas
* XLS files protected by password
* Export Excels files and streams to PDF files and streams
Copyright (c) 2007-2009 SharewareOrder.com Inc. All Right reserved.
Copyright (c) 2007-2009 SharewareOrder.com Inc. All Right reserved.
