How to Use VLOOKUP in Microsoft Excel (Free PDF Guide Inside)

Microsoft Excel vlookup function

What is VLOOKUP function? You can use the VLOOKUP function to search the first column of a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees’ ID numbers are stored in the first column of the range. See example below. If you know the employee’s ID…

Read More

How to Link Aadhaar Number with Mobile Number

Link Aadhaar number to mobile number

In order to further strengthen the national security measures, the Supreme Court of India has asked all cellular service providers to re-KYC all its subscribers with UIDAI Aadhaar (link Aadhaar number with mobile number. This order is applicable to all new and existing subscribers and for all cellular service providers in India. Both prepaid and post paid subscribers need to get their SIM verified with their Aadhaar number. This order is in effect now and Govt. has set deadline for this to 6 February 2018. All mobile which are not…

Read More

Slow Android Phone? One Easy Fix

slow android phone

Android has many interesting features and is everyone’s favorite. Are you facing slow Android phone performance? There are so many reasons for your smartphone to run sluggish i.e. too many applications, crowded cache, low RAM, infection due to malware etc. There are thousands of apps available on play store which promise to speed up the slow android phone. I personally tried many such apps and never spotted any major differences except that some cache can be cleaned automatically. Apart from promise to fix the slow android phone, most of these…

Read More

How to Recover Deleted Contacts on iPhone

deleted contacts iphone

One of the common thing that occurs when using your iPhone is losing contacts by accident. Have you ever lost iPhone contacts after upgrading your device to the new iOS 10? Many reasons can be attributed to the loss of iPhone contacts, for example, iOS upgrade, failed jailbreal, system crash, accidental deletion, etc. It is never fun to lose such important data on your iPhone. But no need to be depressed, this article will cover 4 straight forward ways to recover deleted contacts on iPhone 7/7 Plus/6S/6S Plus/6/6 Plus/5S/5/4S/4. Option…

Read More

How to Capture Screenshot on Macbook, Windows PC, Chromebook, Android and iphone Devices

capture screenshot

In this article we are covering easy methods to capture screenshots on Windows, Apple, Android and Chrome devices. How to Capture Screenshot on a Macbook There are two easy ways to capture screenshots on Macbook – Capturing Entire Screen – Hit Shift and command 3 buttons, the screenshot will be automatically saved to desktop in a .png format. Default name will be ScreenshotDateTime.png. Capturing screenshot of a selected area – Hit Shift and command 4 buttons. The pointer will turn into a crosshair. Drag the crosshair as per your need…

Read More

Ideal Facebook Page Cover Photo Size

Facebook page cover photo size

So you have an idea for a Facebook page and thinking about a eye-catching cover photo? An inappropriate Facebook page cover photo size can spoil the game and could result in negative impact on your page performance. Here below we explain you the all about proper Facebook page cover photo size: According to Facebook– Facebook Page Cover Photo Size: Minimum allowed size for Facebook page cover photo is 399 pixels wide and 150 pixels in height The best size of Facebook page cover photo is 851 pixels wide and 315 pixels…

Read More

How to Recharge Jio Sim (3 easy ways)

recharge jio sim

Its been a long time that you enjoyed the free services of Jio sim. Now Jio has kind of stopped giving free goodies and asking users to make a recharge Jio sim with dhan dhana dhan offer. This offer is available to customers who have already subscribed to Jio prime. There are two plans; Plan 309 which gives 28gb data for 28 days (upgraded to 84 gb data for 84 days) and 509 plan which gives 56 gb data for 28 days (upgraded to 168gb data for 84 days). There…

Read More

How to Set Free Caller Tune on Jio Sim

jio caller tune

By the time you might be already enjoying the services of Jio network on your device. Jio has extended its free services for 3 more months with one time recharge and a subscription to Jio prime. With this you entitle yourself to free and unlimited internet, calls, sms and access to lots of paid apps. With Jio everything is free (within the subscription), yes even the caller tunes. There are 3 ways you can set free caller tune on your device without spending a penny. So here are 3 ways…

Read More

Cool Android Features You Should be Aware of

cool android features

Android is not a thing of today. Billions of people around the globe are using the android interface and enjoying the great features of it. But still millions of folks are joining the joy ride of android on daily basis. Most the things are new for them and sometimes they find it hard to understand some of the cool android features. So I thought of sharing some of the features of android which can help you lot and save great deal of time. 1. Shortcuts You can set shortcuts of…

Read More

5 Interesting Google Hacks and Tricks

Google has many hidden functions which are mostly unknown to general public. If you are a tech savvy guy then you probably will be already knowing most these hidden hacks and tricks. Lets start with top 5 interesting tricks of Google: 1. Index Search Are you looking for high quality movies, exclusive pdf or ebooks, software, music files, but find it difficult to search things in various websites. The restriction over torrents has made it extremely difficult to find the desired content on internet.

Read More