How to Install and Play Pokemon Go in India

Are you looking for a way to download Pokemon Go on your Android or iOS phone in India?

Since this game is only available in few countries and India not being one of them, you might get disappointed that you can’t play this game. Well, don’t get disappointing, here ‘s how you can download, install and play this game in India, both in iOS and Android.

How to download, install and Play Pokemon Go in Android

  1. Visit this link
  2. Download the APK file
  3. Go to your settings>Security and check “installation of apps from unknown sources”
  4. Once downloaded. click on it to visit the APK file
  5. Click on Install and you are set to play Pokemon Go on your android phone in India

How to download, install and Play Pokemon Go in iOS

For iOS the installation is slightly different but good god its still possible and nowhere near as hard as the roblox hack. So you can do it in two ways, the first is to borrow an Apple id and the second one is creating a new apple id alogether

Borrow Apple ID

  1. Ask a friend to share his Apple id and password who lives in a country where Pokemon Go is available
  2. Log out from your Apple id and enter his ID and password
  3. Now search for the Pokemon Go game on App store and download and install it
  4. Since its not your ID,  you ill have to sign out and sign in again with your own ID
  5. Reinstall again Pokemon Go from your saved files from cloud

Create a new Apple ID

Here’s the process is almost same, the only difference is instead of borrowing an ID, you create one by yourself

  1. Sign out from your Apple ID
  2. Go to setting and select General>Language and Region>Change region to US or Australia and or Canada
  3. Open App store
  4. Create a new Apple ID
  5. Add billing as None and select an Address of the country which you mentioned earlier
  6. Now search and download Pokemon Go
  7. Install Pokemon Go and sign out from this fake Apple ID and sign in to your original Apple ID
  8. Your installation will be lost but since your data is saved on cloud, you can install the game again.

Hope this helps, do play the game and let us know how you enjoy this.

How To Download Facebook Videos

These days we tend to watch more videos on Facebook over Youtube. Mostly, they are shared by our friends or are related to our interest area. Many times, we come across videos that we would like to keep it for future use. One way of doing that is saving the link or sharing it in our own timeline. However, what if, we would like to share outside the Facebook universe? For that, we do have various phone apps and websites which helps to download these videos. One such website which works well for downloading Facebook video is FBDown.net.

Steps to Download Facebook Videos

Step 1# You need the URL or link of the video. How to get that?

Right click on the date or time of the video and copy the link.

how-to-download-facebook-videos-link

Step 2# Go to fbdown.net and Download

Enter the copied video URL or link in the input space provided in site and hit download

Select the video quality by clicking it and you are done.

how-to-download-facebook-videos

How To Unblock Yourself on WhatsApp If Someone Has Blocked You

In last post I mentioned about how to find if someone has blocked you on WhatsApp. Today, lets find out how to unblock yourself. It’s a simple trick that can come handy if you want to reach out to someone to clarify any sort of misunderstandings.

Following steps will unblock you, if someone has blocked you –

  • Go to WhatsApp settings
  • Click account and then click on delete my account
  • Go ahead deleting your account by entering your phone number and delete your account.
  • Afterwards, uninstall WhatsApp from your mobile.
  • Then, restart your phone.
  • Now, again install WhatsApp with same old number.
  • Once installed, you’ll get unblocked from all other accounts.
  • However, you’ll be removed from all your existing groups. So choose this method sparingly.

Interactive Excel Graph – How to create?

This article will be very useful for people who work on excel and create a lot of reports and wants to create interactive excel graph. Often your clients or boss asks for details on a graph and then you have to go back and make changes and appear in front of them just to be asked for another change.

Story Behind Interactive Excel Graph

Very recently a client of mine was asking me to prepare few reports and every time I prepared something, she was asking for some other and it was taking a lot of time. So basically I was trying to find a solution to this and I came across this interactive excel graph which can present data on multiple levels and as you change your parameters or range, the graph will change simultaneously. The fun part is you don’t have to go back to your data and make changes there, you can make those changes right in the graph.

Process

  1. Select your data set, Interactive Excel Graph
  2. Go to Insert tabInteractive Excel Graph
  3. Click on Pivot tableInteractive Excel Graph
  4. You will get a pivot table like this. Now select parameters that you want to show in your graph Interactive Excel Graph
  5. You should get a pivot table like this. Now select this pivot tableInteractive Excel Graph
  6. Go to insert tab and choose the graph you prefer. I have chosen column graph here Interactive Excel Graph
  7. You should get a graph like this Interactive Excel Graph
  8. But wait, the catch is here. At the left bottom side of the graph, do you see few tabs? Yes, these are your parameters of your graph which you can adjust right there. For example I have changed the parameter Category here and I have only taken Office supplies and the graph responds to that automatically Interactive Excel Graph

This is pretty fun. This tabs works like filters and you can filter out anything you want right there in the graph and there’s no need to come back to your data. So if you boss asks to show graph for a particular month and for a particular region and only sales number, you have a solution, your  interactive excel graph.

Hope this helps.

How to clear all chats on whatsapp without clearing the special ones?

On Whatsapp if you clear chat, everything gets cleared and sometime you have to do it in order to save phone memory. But sometimes you also want to keep some special chats but clear other. Thanks to new update on Whatsapp, its possible now. If you don’t have an updated Whatsapp, go to playstore and update.  The process of clearing chat but keeping special ones is mentioned below

  1. Go to the chat you want to keep
  2. Touch and hold on the chat
  3. Keep touching as many as you want on that specific group or personal chat
  4. On the top you should see a starred sign, touch on that

whatsapp-clar-chat-keeping-specific-chat

5. If you want to clear chat for your entire whatsapp, follow the same process for all groups and individual chats. If you want to clear chat only for this group/person you are done.

6. Now there are two ways of clearing chats depending you want to clear your entire whatsapp or just for some specific groups or individual chats.

For entire whatsapp clearance

  1. Go to settings>Chats>Chat History>Clear all chats
  2. Check Keep starred messages and clear

whatsapp-clar-chat-keeping-specific-chat

 

For specific groups, individual chats

  1. Go to that specific chat
  2. Now touch on that 3 vertical dots on the top right corner
  3. Touch on more
  4. Clear Chat
  5. Check Keep starred messages and clear
  6. Follow the same process for other groups/individuals

 

How to read Whatsapp messages without showing Whatsapp blue tick

Whatsapp blue tick is a heck of a problem, right? Have you ever received a message on Whatsapp which you wanted to read so much but did not want to let the person know that you had read it. Have you ever cursed the Whatsapp blue tick ? So I have been researching about it lately for some reason and the most common solution I came across was Airplane mode or Flight mode. But I checked it by myself and to my surprise it doesn’t work at all. Even if you watch the message in Airplane mode and close Whatsapp completely before turning off Airplane mode, as soon as you connect to Internet, the sender sees the Whatsapp blue tick, hence not useful. So here’s my solution

  1. Go to Playstore and update your Whatsapp
  2. Now come back to Whatsapp and go to settings>Account>Privacy
  3. Uncheck the “Read receipts” option and you are all done.
whatsapp-blue-tick
Hide Whatsapp Blue Tick

 

Now even if you read any messages on Whatsapp , your sender won’t see any Whatsapp blue tick. The problem with this process is, its a two way process. So you will also not be allowed to see the blue tick. If that is not the solution you want, here’s one more solution for you. With this solution you will be able to see the Whatsapp message without showing the blue tick to your sender but you can see the blue tick as soon as someone reads your whatsapp message.

Just simply download another app from PlayStore, there are many apps , some of them are

  1. Shh, No Last seen or Read
  2. Blue tick, last seen hider

So just download any of this app, activate and follow instruction and you are all set.

Keep Whatsapping, secretly.

How To Easily Copy Excel Sheet Table With Rows And Column Headings In Word Document?

Here is a short video tutorial on how to easily copy Excel sheet table with rows and columns in word document.

If you have any further query or any other problem related to word and excel spreadsheet please feel free to drop your question in comment section.

How to Silent Whatsapp Group

Now a days Whatsapp has become the hub for all sorts of chatting, be it among school chatting, business chatting or whatever. So people keep adding their friends, colleagues, relatives randomly. Sometimes it becomes annoying when whatsapp keeps singing for every single update on the group and if the group is really big, it can be a terrible pain. But there’s an option to silent whatsapp group, read below

  1. Go to the group
  2. Touch the three vertical dots
  3. Touch Mute
  4. You can mute it starting from 8 hours to as long as 1 year
  5. You can also opt out from getting notification and once you visit the group, then only you will be able to see all new updates
  6. If the group is open already, it will still make the notification sound, don’t get confused, it won’t once you close the group.

Its pretty easy, right?

 

Image source: www.itprobs.com

How To Convert CR2 Image File To JPEG?

I was recently going through the pictures of my photoshoot and wanted to email a few of them as attachment.

While a 25 MB CR2 (Canon Raw) image attachment was out of the question, my brain immediately told me to convert it into a JPEG and then attach the compressed version.

The only problem???

Neither, Windows Photo Manager nor Adobe Photoshop 7 (Yes, I’m old school) would open it.

I found a lot of online converters but I ain’t no Creative Commons material.

A wise man said,

  Do What You Can With What You Have!

By default, I was left with Windows Live Photo Gallery to browse my CR2 file images.

Thus, I decided to find a way to convert the CR2 image file to JPEG using what I had.

A little digging around the Microsoft forums and I found the codec pack that would do the job.

How To Convert CR2 Image File To JPEG?

1] Download and install this Microsoft Camera Codec Pack (6.3.9721.0).

Psst…. The above link is tried and tested by us!

2] Open your CR2 image file using Windows Live Photo Gallery and click on Edit, Organize or Share.

3] Double Click and open your image file once again inside the editing tool.

4] Click on ‘Make a Copy’ and when it asks you to save the file, save it as .JPG format.

This is the simplest way to convert your CR2 image file to jpg or other low sized versions.

I’m pretty sure, this wouldn’t be a big issue for photographers but for a layman with minimal specs desktop or laptop setup, you can’t go wrong with the above steps.

Let us know if this was helpful to you in the comments section.

Cheers!

(Image source: t3.com

How To Share Map With Your Friend?

It might be the most common problem we have come across. Often we find it difficult to make our friends understand our locations or the location of meeting and we end up sharing some stupid map images, scanned images or depend completely upon landmarks and localities. Enough is enough, this can’t be the way.

Ever wondered how would that be if you can share map, location with your friend online, that too you can direct on the map, update the map online and your friend is updated at the same time, will not that be amazing?

Thanks to Google, now we have a solution to share map.

How To Share Map With Your Friend?

  1. Go to drive.google.com.
  2. Click on New>>More>>Google My Maps.
  3. Add a marker where you want to meet.
  4. You can add direction to this mark.
  5. You can add multiple layers if you have multiple purpose.
  6. You can also measure online the actual distance.
  7. You can also draw line manually to highlight the road if direction isn’t working for you.
  8. Once you are done, you can share the map with your friend, all you need to do is to share the map with your friend’s email id, you can share this with as many friends as you want, perfect for a hangout.
  9. You can edit the map online, so change of plan? No problem, just edit this.

Hope this saves some time of yours 🙂

Image Source: deviantart

Claim Your 100GB Of Free Cloud Storage In OneDrive Right Now

The cloud storage war seems to have heated up between Microsoft and Dropbox this time. The Seattle based company is giving away 100GB of free cloud storage in OneDrive for all Dropbox users.

Yes, if you have a Dropbox account, then you are eligible for 100GB of free cloud storage in OneDrive.

I’ve made this simple for you. Just follow these steps and get rewarded with 100GB of free cloud storage. Instantly!!!

Steps To Claim Your 100GB Of Free Cloud Storage In OneDrive:

1] Go to this Microsoft link

Microsoft OneDrive Free 100 GB storage invitation

 

2] Click ‘Verify and get my storage’. You will be asked to login to your Windows Live account. Login with your correct live credentials and then give permission to the OneDrive app to access your account.

Login to your live account

3] Save the file to your Dropbox account. After you allow the OneDrive app to access your account, it’ll prompt you to login to your Dropbox account. And then, it’ll requests you to save a file to your dropbox account.

100 GB free OneDrive storage success

 

4] Pat yourself on the back. If you didn’t skip any of the steps above, you now have 100GB of free cloud storage in OneDrive.

Free 100 gb storage in Dropbox

You can login to your onedrive account and confirm your extra free storage. The 100 GB of free storage is available for one year, listed as “Enthusiast bonus”.

100 GB Free storage in OneDrive for dropbox users

 

Enjoy the extra 100GB of cloud storage. Make the best of it; take backups, save your high-def photographs.

Isn’t this cool? So why won’t you share this with your friends.

Psst… What do you use your cloud storage for? Comment below.

How To ‘EASILY and QUICKLY’ Take Screenshots With Samsung Galaxy S4 Or Any Other Similar Android Phone

how-to-take-screenshot-in-samsung-android-phone-galaxy-s4Hey there, this is a quick post on how to take screenshots with Samsung Galaxy S4 or any other similar kind of Android phone like S3 and S5.

In post title, I have put ‘EASILY and QUICKLY’ in uppercase, and there is a good reason for that. I recently shifted from iPhone to Android phone and it took me a while to figure out “How to easily and quickly take screenshots’.

In iPhone, it is damn simple, with just one gentle press of power button (or hold button) and home button we can take screenshots. But in Samsung, I tried pressing standby button (or power button) and home button together, but every time either home button gets pressed earlier or standby button.

Also, with thick protective cover on phone, taking screenshot become even more difficult. Then with lots of trial, I learnt the trick.

How To ‘EASILY and QUICKLY’ Take Screenshots With Samsung Galaxy S4 Or Any Other Similar Android Phone?

To take screenshot easily and quickly all you have to do is following steps –

  1. Open the screen that you want to capture.
  2. Press standby button and home button together.
  3. Then keep HOLDING both the buttons till you get your screenshot.

HOLDING for a while is the trick, which no one told me.

Probably, you already knew this trick but as a iPhone user, it took me a while to learn it, so I thought I should share with you just-in-case if you struggle.

There are other ways like swiping with gesture but I prefer this method over that.

Image Credits: Samsung/Galaxy S4