|
| |
|
|
|
|
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
|
|
|
Rating :
Data Cleanser for Microsoft® Excel® is utility that works with Excel files and helps you to clean your data.
With various operations like Delete, Copy, Clear, Clear Content, Trim, Clean, Remove spaces so you can easily filter and cleanse your Excel data lists using various selection criteria. This is a huge time saver for you.
Features:
Various operations with you can perform on your Excel® Data/lists are like Delete, copy, select, clear, trim, clean, remove spaces and so on.
And you can perform these operations on a filtered list in Excel based on the following criteria with one click.
Available criteria - Contain, Do not contain, Are Blanks, Are only Text, Are only Numeric, Have Errors, Are Equal to, Are not Equal to, Are Greater than, Are Greater than or Equal to, Are Less than, Are Less than or Equal to, Begin with, Do not Begin with, End with, Do not End with and so on.
This Add-in works with the selected range of any active Excel Workbook and performs the filter criteria using the first column of the selected range.
Also, unlike other VBA and Macro operations you have the flexibility to Undo the last operation performed by the add-in.
This is to ensure you do not lose your data while working with this add-in for Excel®. Life time free updates available with more new features to be updated in this software.
Try it now for Free and you will love it.
|
|
|
Rating :
"Lost your Password?
<BR>
<P>
Cracking Passwords has never been easier than this.
<BR>
<P>
Losing Excel password is like losing a lot of work and an inability to make changes to your spreadsheet. There are normally many instances where employees work on your workbook protect them with passwords and leave, and you are left with a spreadsheet that can not be modified. A lot of times we simply forget passwords and later curse ourselves for not writing it down while protecting the spreadsheet.
<BR>
<P>
After putting in a lot of effort and time in creating a spreadhseet, it is extremely frustrating, that no matter how hard you scratch your mind you just won't recall the password.
<BR>
<P>
A simple solution to this common problem is the EDPasswordRecovery Addin which lets you Crack Password/s in minutes. With help of EDPasswordRecovery addin you will be quickly able to make your Worksheet and Workbook password free so you can give them new password/ or keep them password free.
<BR>
<P>
There are various similar Windows based tools which claim to remove passwords, but unfortunately they are nothing but waste of time and a lot of money. The addin EDPasswordRecovery is the password cracker which is made in excel and does not require any installation etc. All that you need to do is to click a button and wait for 1 minute at the maximum.
<BR>
<P>
The objective of this addin help you on remove passwords of your sheets/workbooks and save a lot of possible duplicate effort while working with Spreadsheets.
Instructions <BR>
1) Double Click the Addin file (.xla extension) 2) You would see an additional Menu appearing in the Excel Menu 3) Make your selection 4) Relax
<BR>
<P>
Removing passwords has never been any simpler before.
<BR>
|
|
|
|
|
|
|
 Copyright (c) 2007-2010 SharewareOrder.com Inc. All rights reserved. |
|
|
