## 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.

## How to recover deleted messages in Outlook.com

Yesterday, we told you how to get your Outlook.com email. Outlook.

## 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.

## How to easily grab webpage embedded media in Firefox

First, a short disclaimer: This post merely shows you a method. You alone are entirely responsible for what you use it for. There are times when we need to grab media like images, audio and sometimes even embedded video files from various sites.

## Learn how to tie a tie

One thing that every guy wants to know (besides how to impress a girl) is how to tie a tie and the site 2tieatie.com hopes to answer this question. 2Tie a Tie gets into the history of various knots and teaches you how to tie them.

## Win a Membership to OnlineProfits.com

OnlineProfits.com launched this Monday with \$50 off on their monthly price of \$98. I decided to signup considering the big names and especially checking out the content they have on offer.

## Learning at the all new Dummies.com

For Dummies is one of the top selling series of books covering tonnes of topics under the sun. It’s usually one of the first purchases for people who want to start afresh anything from business, to computers and the Internet, electronics, finance etc. Now, For Dummies has relaunched Dummies.

## 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.