Tips and Tutorials

Screenshot on Nexus 7

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!

taskkill

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.

Techtites on Google Currents

How to add your blog to Google Currents

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.

Dropbox two step verification

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

caffeinate

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

INDEX MATCH Step 1

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.

Source table

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