22 Aug 2014

Few time saving Excel tips and tricks

Here are a few Excel tips and tricks that will save lot of time.

1) Change unformatted dates like 20090808 to readable format.
This is a small trick to quickly convert unformatted dates in Exel.



Steps to do
1. Selct the column of data you wish to change. Go to Data > Text to column

2. Select Delimted, and click next twice to reach to third stage



3. Select Date option and choose YMD or YDM as per the data you have.
4. Lets select YMD and choose a different destination cell and click Finish

5. You will see the date formatted in new destination cell


2. Return back to where you left from.
Say, you were working on a set of cells, which you have selected and then scrolled away to some other sheet or place. To get back to the selected cells very quickly, all you have to do is press Ctrl+Backspace


3. Inputing multiple lines of text in  Excel
Inorder to have multiple lines of text in Excel, all you need to do is press Ctrl+Enter and start writing away on the next new line

4.Quickly skip through your worksheets using shortcut keys
To move one worksheet to the right press CTRL+PAGE DOWN
To move one worksheet to the left press
CTRL+PAGE UP

5. Display Formulas Instead of Results
You can use a single keystroke to view formulas instead of results. Just press Ctrl + '

6. Adding a drop list
There are two ways to do that. I will mention both options here

Option A
Step 1:  Data validation
Go to Data tab and click Data validation

Step 2: Under Settings, select List
Step 3: Select the cels to be included in the list in the Source
After selecting the cells to be listed, you are done.

Option B
The other option is to type in directly. You need to follow the first two steps in option A.
And in the Source, just type the text you want to be listed e.g Option1, Option2, Option3 separated by commas.



Quickly find merged cells in Excel

You are in a hurry and want to prepare some data in a minute, but unable to sort, filter or use pivot table. You are left wondering what and where went wrong, until you see the error.



Imagine you have a thousands of rows, it would be a huge tasks to find out where the meged cell is.
Here is a simple tip to find it immediately.

1) Open Find option by pressing Ctrl+F


2) Click Format. You wiill see Formatting options.
3)  Go to Alignment tab and select "Merge Cells"

4) Click Ok to close the option. Go to the Find option and click "Find all"

5) You will see all the merged cells listed.


29 Jul 2014

Hack energy, money and coins in Kardashian (Android)

"Kim Kardashian: Hollywood game" is an addictive game, where you are introduced as a struggling actor initially. It is like a game based on real life, and as you advance more stages, you can have fan followers, buy homes, date your friends etc. Here I will provide you some tips, cheats and a simple hack for scores and energy.

Caution: This post is for educational purpose only. You only will be responsible for any action taken on your device, following the steps mentioned in this blog.

24 Jul 2014

Hack power in "Bad Roads" using GameKiller

Using Game Killer, a memory hack tool; you can hack power or stats in Bad Roads.
Watch video and enjoy... Should you have any queries, please comment

Hack power in "Ninja Jump"

Using Freedom tool on Rooted device, you an remove Ads and buy unlimited power at no cost for Ninja Jump.

Hack coins and stats in "Striker Soccer 2"

In order to do this hack, your Android device needs to be rooted and have Freedom tool installed. Watch and enjoy