## How to calculate Payback Period in Excel

Payback period in capital budgeting refers to the period of time required for the return on an investment to "repay" the sum of the original investment. For example, a \$1000 investment which returned \$500 per year would have a two year payback period. The time value of money is not taken into account.

## How to divide two arrays with SUMPRODUCT in Excel

Way back in 2008, I wrote about using SUMPRODUCT to duplicate the functionality of SUMIFS which was introduced in Microsoft Excel 2007. SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays. Let's first understand the syntax of SUMPRODUCT.

## Excel Tutorial: INDEX MATCH primer

Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we'll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.

## Excel Tutorial: VLOOKUP primer

Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we'll use VLOOKUP to find a value from the table. Firstly, let's create the above table in Excel.

## Excel Tutorial: Introduction to VLOOKUP, INDEX and MATCH functions

Excel has severalĀ  lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.

## Share Collaborate Notes & Documents Online With Springnote

If you working on some project or presentation and what to share the work with your fellow buddy that very second for some corrects or proofreading, then what you do? Springnote is web 2.0 service which makes real-time collaboration on office documents and notes easy, here other users can comment, and add content as needed.

## Edit Your Documents Online with Shutterborg

I have just stumbled upon a very cool web application that allows you to use word processor with in your web browser. Shutterbrog lets you edit your documents online totally free of charge. It offers a very user friendly interface and makes every thing easy for you.

## Recover MS Word and MS Excel password Easily

If you have lost your password for any MS Word or Excel document and are unable to recover it, try using this Free Word / Excel Password Recovery application. It's a freeware product and all you need to do is install it, open the file that you need to recover. Choose the character set "a to z" and the expected lenght of your password and click GO.

## Label Merge with Microsoft Word 2007

A long time ago, I wrote a tutorial on creating custom labels in Microsoft Word. Creating a custom label is necessary only if you don't plan to use the many inbuilt label templates. The next step after creating a custom label is the actual label merge process.

## Compress PowerPoint and Word files without zipping software

How many times have you struggled to send PowerPoint Presentations and Word documents to your friends / colleagues only to be overwhelmed by their sheer size! You can choose to zip or rar these files and send them across, but this would require the user there to have a program to unzip or unrar the files. PPTminimizer for Word and PowerPoint compresses PowerPoint presentations and Word documents without changing the file formats.