Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing
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
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. If you’re impatient,
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.
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. So whip up the installation of Excel you have. You can use either of Excel 2003,
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. Usually INDEX and MATCH
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
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.
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
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.