# Tips and Tutorials

## How to Build an Ecommerce Website Delivering More Profits?

Is your online business with a great website designing sucks? Well, it happens to most ecommerce owners in fact. If you really do have a beautifully designed website and high-quality products, and still the business sucks, then obviously you are missing some tricks to convert the leads to sales.

## How to take a screenshot on Google Nexus 7

In the past taking a screenshot from your Android device was a painful experience requiring you to root your device. Even today, many of the screenshot apps available on Google Play require root access. However, if you’re running Android Jelly Bean then you don’t need any special apps to take screenshots, since the OS comes inbuilt with support for them!

## How to quickly kill a program in Windows

During my regular work, I tend to face repeated issues of Excel hanging. This can be really frustrating because a stuck Excel means a painful wait for Windows to figure out what it wants to do with the process. Unfortunately, there isn’t much I can do about this because it is mainly due to addons that I have installed in Excel, which are required for me to do my job coupled with large files with tens of sheets and hundreds of rows with data.

Over the past few weeks I have been using Google Currents to read the latest news. Available for Android and iOS, Google Currents delivers beautiful magazine-like editions to your tablet and smartphone for high speed and offline reading. If you’re running your very own blog which publishes an RSS feed, then adding your blog to Google Currents is extremely simple.

## What to Do When Someone Steals Your Website Content

Creating content for the Internet is a challenge. On the one hand, without constant content creation, websites lose traffic and become irrelevant. On the other side of the equation, some unscrupulous webmasters and bloggers regularly seek fresh content from other sites, recycling it on their own pages.

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

## Fixing Windows 7 Disk Errors

Disk errors plague virtually every Windows user at one time or another. These errors can show up in just about any stage of usage. Sometimes this can be something as simple as a bad connection.

## How to enable 2 step verification on Dropbox

There have been concerns about the security of your files in Dropbox. Recently Dropbox added another layer of security similar to Google’s two step verification. When you enable two-step verification, whenever you want to login to Dropbox, you will need to use your password, and a security code that will either be texted to your mobile phone or generated by a mobile authenticator app (available for iOS, Android, Blackberry and Windows Phone 7).

## Stop your Mac from sleeping without an application

A few months back, we blogged about 7 applications for your Mac to prevent it from sleeping. While these programs make the process extremely simple, OSX Mountain Lion comes inbuilt with a ready command line tool that makes this process extremely easy. Fire up Terminal and run the following command: caffeinate -i -t 36000 & The command above will tell OS X to not sleep on idle (-i) and to keep running for 36,000 seconds or 10 hours (-t 36000).

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

If you haven’t had a chance yet, please go through the VLOOKUP tutorial. Alternatively, if you’re ready to jump right into INDEX/MATCH, then let’s get started.

Firstly, create the above table in Excel. I’ll be using Excel 2010 in my example. You can also download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet with the answers.

If you havenâ€™t had a chance to review the basic syntax of the functions, please do read this post before you continue.

Read More »Excel Tutorial: INDEX MATCH primer