OnePlus One Tips & Tricks - Part Two

This is in continuation to my first part [read here]
OnePlus do continue to amaze me with each passing day. There are lot of customization, features that can be explored. Listing down some of the best ones among them.

OnePlus One Tips & Tricks - Part one

Thanks to CynoGenmod 11 for bringing in a lot more customizations in OnePlus One users, as compared to other premium phones. Earlier, such customizations could be done one rooted phones having CWM or TWM ROM and other premium apps available on Google Play.

OnePlus One phone (India) Review

When OnePlus One was launched initially, there was a lot of speculations about the specs that Indian users would be getting. It was expected to launch in India anywhere between INR 25,000- 28,000. But when it was launched formally on 2-Dec  though Amazon.in, I was one of the users who was left
dumbstruck at the launch price INR 21,999.

Earning from Affiliate Marketing – Part 1

Affiliate Marketing is the fastest growing industry on the Internet today. Extra Income made through this one channel runs into billions of dollars yearly. Many people get involved at it without a solid plan for the triumph. Indeed, many want to earn extra income using affiliate marketing, albeit without a real base plan, which is the most important reason for most being unsuccessful at it. Do you really look at any earning without understanding or planning the future of any business, be it at work or at earning extra income?

Shopping on eBay - risks and benefits

If you have never shopped on eBay, there is a really chance that you already know exactly what it is. eBay can be an online auction website that allows internet customers to sell items that they own, but not longer need or want to have. This is what makes eBay the largest online market place, as just concerning anyone can buy or sell there. However, with just up to anything else you find online, shopping on eBay has its pros and it cons.

Basic Android apps for students

I have been looking forward to write this post for a long time now. Here are a few apps which i have used and feel would aid students in their daily learning process.

Tools to conduct online class - Part two

This is the second part to the post; if you have missed the first part, please read it here.
In continuation to the first part, where we have discovered some interesting tools for voice, video and meeting; lets continue further with other tools.

Tools to conduct online classes - Part one

Have you ever thought of teaching online or reach out through online classes, but have no idea how or where to start? With a little understanding of technology and free tools available today, we can easily conduct an online class easily. Below are few of the tools and methods, with which we can reach out to the students or audience.

Introduction to Affiliate Marketing

Affiliate marketing is a huge business idea on the web, that has been around for quite so many years. I wonder why i recently got attracted to it !! Its a cooperative effort between retailers and an affiliate’s website. For many years now, affiliate marketing has proved to be a very cost-efficient, measurable approach to delivering long-tern results.

Whatsapp blue tick hack

You might have noticed the recent change in WhatsApp which added another unnecessary information in the form of blue check marks, indicating that the recipient has indeed read the message.

Expand unlimited land in Township hack

I could hack almost anything in the game Township for Android. However I was still not able to expand the land, as there was a population cap and i could not expand it. Until I came up with a small plan to hack it as well. To do the hack, you need to have a rooted phone and GameKiller installed.

How to use Event Viewer (Windows 7)

I know Windows 7 has been here for some years ago, and I should have written this post some years backup. Nevertheless, I thought it would help many of my other less-techie friends. When Microsoft designed Windows 7's Event Viewer , it was meant to provide the user with more insightful, meaningful, and well-documented events to help better in troubleshooting. For some weeks, my laptop has been taking a long time than usual to boot and hence I take this opportunity to write this post, to test out Event Viewer.

Note: Technical inputs / help taken from Wiki, Google and Microsoft.

Use Android phone as Wifi repeater

Have you often felt that you are out of wifi range, when you decide to take your laptop in the following area or garden? Maybe their router doesn't cover the whole of your home, and you feel the need to extend the range. There are lots of ways to extend the Routers range, however one way you can extend is by making use of your Android device as one Wi-Fi repeater, also known as a Wi-Fi extender.

Some less known smart tools / gadgets

I am a gadget freak, always ready to try out new things in the market. Off late i have been using some of them, which i like and would like to share. Below are few of the tools, which i use regularly.

Install incompatible‘ apps in Android

Occasionally, you may have for sure known or seen that; despite having a new, powerful phone running the latest version of Android, some of the high end games are not compatible with your device !!

Not only games, you find that some of the apps provided in Google Play are not compatible to be installed on your phone. To circumvent that, we can force the incompatible app to operate on Android by editing the build.prop system file. You may wonder why Google Play is not allowing you to install the app !! A simple reason to start with is the app perhaps is tested to run on a limited handful of devices as the developer doesn't have the resources to provide wider support.

In-app purchase with Lucky Patcher

I have already introduced this tool in my earlier post here. Lucky Patcher is a powerful Android tool to remove ads, modify Permissions, bypass premium applications license verification, and more.
To use all features to Lucky Patcher, you will need a rooted device.

With the latest update in Lucky Patcher, you wont require to install or use freedom apk to hack in app purchases. The latest version of lucky patcher apk i.e. 4.7.0 supports 'Hack google in app emulation'.
Click here towards read in detail and to download the tool.

Sum cells based on background color

I had this difficult task was of adding the contents of certain cells based on their background colors. This is a really tough, just thingking of it. I tried to do it with conditional formatting and formulas, but in vain. Then i came up with a clean trick that help me complete the same.

How To Maximize The Adsense Earnings

Most webmasters know that Adsense generates a sizeable source of added advertising income. Which why more out of them use it to go after high paying keywords. They has with them the lists it tells what the keywords are and also already used various methods of determining them. And but, when putting up these supposed-to-be higher paying keywords into their pages, the money they expected towards come rolling in is not really coming in.

Why Adsense is essential for sites

In order to know why Adsense is important of will contents sites is to understand first how this work.
The idea is really simple, if you think about it. The publisher or the webmaster inserts a java script into a some web site. Almost every time the page is accessed, the java script will pull advertisements from the Adsense program.

Run any Windows applications on Android phone

The accelerated development in Smartphone technology has revolutionized the workplace, both inside and outside the workplace. What do you do, if you require a file from your office computer in the middle of a meeting? Till late 90's, workers were in the mercy of someone printing that file and then faxing the hard copy to them. Or if they had access to a PC they may get to the desktop via Citrix (GoToMyPC) and LogMeIn, which have provided this particular functionality for years. Now, there's an alternative in the palm to your hand: your cell phone. Simply tapping an app on an Android Smartphone gives remote workers access to their entire desktop and/or files.

How Android changed the smartphone revolution

Are you thinking of buying a new cellphone device or some technology gadgets? Within the last few years we have seen an explosion in the market for handheld devices to new technology equipment.
These cool new tech gadgets can make as much, if not a lot more, in some cases, from an old PC could. As with any device running programs that require excellent operating system to do so. There are many of these operating systems to choose from; the one that everyone is talking about now is the Android OS by Google.

The Real Challenge of the Developers - Android

Ever since it's first release, Google android was updated with the new versions and typically all the bugs are fixed and new features are added. At the end of the year of 2009 Google estimated that there would be at least 18 phone models that will use Google android. The additional advantage of Google android is that users are able to work with this and install it even with other operating systems.

Users can install Google android in mobile devices that have other operating system with a little amount of hacking and it ensures limited functionality. Early applications that were developed with Google android had many issues that included bugs, insufficient documentation, absence of system for public tracking and absence of sufficient QA infrastructure. In spite of the faults, applications were seen after the platform was announced. First ever released application-Snake game got a wide support from the users.

Hardware unlocked and sim unlocked device was the android dev phone which was mainly used by the advanced users. Developers can either choose regular end user device to test and use the devices while other developers don't use a retail device for their applications. The Software Development Kit (SDK) Android 0.9 has API that was updated and extended than its older version. Home screen also has some updated attractive design.

However Android SDK 1.0 fixed all the issues with bugs and included small features. Number of mobiles with Android is increasing and this in turn has led to the third party developers to install applications into android operating systems. Some of the most Internet websites think android as most important to create some native applications based upon android. Most popular among them are MySpace and Facebook.

Find and remove sensitive and hidden data in Excel

In Excel, there may be sensitive information, hidden cells, hidden rows or columns that needs to be deleted before sharing with someone. If you use Excel 2007, 2010 or Excel 2013, it is easily for you to remove the unwanted hidden rows or columns.

How to hide cells contents in Excel

This small trick will only change the formatting of the Excel cells and will not change the content. They contents are still there and shall be accessible for formulas, charts.

Calculate difference between two dates

I recently came up with a hidden function in Excel called DATEDIF. As the name suggests the job of this function is to calculate the difference between two given dates (DATE DIF).
I consider this function as hidden because, for some reason Microsoft has decided not to document this function. And because of this you won’t find this function in the Formula Tab. To verify this, try and type =DATE in any cell. You will see, Excel enlists all the functions that start with the word “date” but it doesn’t shows DATEDIF.

Using HLOOKUP in Excel

Many of the Excel users are known to have skills if they are able to use VLOOKUP formula.
Alternatively there is a little complex formula called HLOOKUP where H stands for “Horizontal” and hence it is often called as Horizontal Lookup. It is a little confusion to most of the users how to use it. The basic task of HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify.

Create a custom list to sort data

It has been quite some time i have written a post. If you like to sort information differently as per your choice, and not in the classic fashion of ascending or descending sort order in Microsoft ® Excel ®, you can easily customize it. Lets get to it directly.

Few time saving Excel tips and tricks

Everyone wants data at the snap of the finger. Even a small mistake can take one to spend hours for resolution. I am listing down a few tips that will save lot of time.

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.

Hack Kardashian game (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.

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

Remove unwanted page from home screen in JB

In Android Jelly Bean, for some devices, you face issue while trying to remove a page in home screen. Following these steps, you can remove the unwanted page.

Hack coins in "Hill Climb Racing"

You need to have a rooted device with Freedom tool installed. Using Freedom tool, you can hack unlimited coins in "Hill Climb Racing". Check the video out.

Hack credits and money in 'Voxel Rush"

Using Freedom tool, one can buy credits and money in Voxel Rush, which I am going to show today. Basically this Freedom tool can assist in hacking any Android game to provide a free card instead of any real card which emulate the buying process.

Hack coins in "Daddy was a Thief" using Freedom tool

This is for rooted users only, with Freedom tool installed on the device. This simple hack using Freedom tool will help you get unlimited coins in the game.

Enjoy the hack, and comment in case you have any questions.

Hack keys in Subway surfer

This hack is incontinuation to my earlier video on hacking coins in Subway Surfer. If you have missed it, you may see it here. In Subway Surfer, keys are used to revive your life for one more time..the more advanced the stage, the more keys it require.

Hack "Bike Mayhem" items using Freedom

Starting a video series of games hacks that are short and self explanatory. Hope you will enjoy the first video of the hack series, using Freedom tool which can be used to buy game goodies without spending actual money.

Mandatory Backup tools for Rooted user

If you are a rooted user on Android, these kinds of tools are mandatory to have, to enjoy a peace of mind.
Basically, these tools have saved me a significant trouble by enabling me to restore to earlier "good working" condition in a few mins of time. Inside just a matter of few clicks, the whole system is restored and device is fully functioning again, as if nothing ever happened.

Android tips and tricks - Part two

This is second part in continuation to my earlier post here. Are you tired of entering your lock password on a regular basis? Wouldn't it be nice if all the locks be disabled, when you reach home or workplace? Here we will show some appllications that are of convenience to users, and Xposed framework and its modules.

Google account password can be changed by anyone using your Android phone

As it is said, necessity is the mother of invention. In dire circumstances, even a feature which was provided to convenience the user could prove to be harmful for another. Recently, a reddit user has posted story of his son resetting the password of his Google account using his phone to buy an app from the Play store.

Block unwanted App and Game Requests on Facebook

I have seen so many people sweaing with regards to the app and game requests they get on Facebook. I offer them few steps, whenever I find time. The main question remains, why you get app request despite telling them not to send?

Redesign any website using TOMODO

Have you ever wanted a chance to redesign Facebook, Twitter or Flickr page? Well guess what, you got it.
There is a webapp called Tomodo that allows you to redesign the interface of the website at your end.

Fix "Windows not responding" problem

One of the most common problem in Windows that we are could see is the one which shows “windows explorer has stopped working”. This would be sometimes really frustrating and hang the whole system.

Android tips and tricks - Part one

There are a lot of things you can do with your Android phone, from basic to advanced levels. Listing down a few of the tips and tricks.

Control Data Usage on your Android phone

Any smartphone user would be storing most of the content online via cloud computing using utilities like Dropbox, Google Drive, etc. Most of them are now morre social with facebook, twitter and other social networking sites, which means more data usage. If you have limited data plans, you have to either control or decrease the data usage by tweaking some apps os settings.

Take Android phone backup without rooting

One of the top queries by friends and acquaintances, is how to take full backup of the phone without rooting it ! Backing up of your android device is the only way to be safe from any disaster. However many of the users do not want to root their phone, and yet dont know how to just take full backup. In this article I will show you the steps to take a full backup without rooting.

Unlimited app in-purchase using Freedom tool

Even if a game comes for free, it doesn’t mean that it won’t cost you. Most of the games provide "goodies", which can be used to add/ enhance the game prospect (eg coins, credits, health etc). Google has released an in-app–buy (making a purchase from within the mobile program) alternative for its Android os working system, so users of those devices may use it whenever required. Hence this is one tool which is a savior for game lovers, when you are in need of assistance of some energy ups, coins or wellness without spending money.

Caution: This post is for instructional purpose only. You are responsible for any consequence which you bring on your phone.

Hacking tools and Apps for Android

I have been posting articles on hacking android apps and games, but never cross my mind to have introduced the in the first place. You can do awesome stuff with Android when your smartphone is rooted. I am listing down here a collection of apps and tools that will take your Android smartphone experience to whole new level.

Caution: This post is for educational purpose only. You are responsible for any consequence that you bring on your phone.

Few upcoming topics

Few of my upcoming topics that i intend to cover in coming weeks
1) Exploring Pivot table and Pivot charts in Excel
2) Resize or increase space in /system or /data area in Android
3) Data slicing
4) More Excel tips

Candy crush Extra life tool for rooted users

This readily available tool helps user get what he wants instantaneously, without any extra effort. Unlike other tools, where you have to scratch your head to find a way to hack, deep searching through the memory areas etc, this tool readily hacks the Game.dat file directly.

Teen Patti hack for unlimited coins

This one little hack was done, in response to a request made by a colleague to increase the chips. Believe me, it was completed in flat 10 mins. This hack is like any other hacks we have performed earlier.
Disclaim: I do not promote rooting or hacking. If you choose to do so, you take full responsibility of the same.

Real Boxing hack for improving player statistics.

This is continuation to my earlier post here on hacking Real Boxing game.

For this your phone needs to be rooted and have GameKiller installed.

Organize your Gmail

This is one of the post, which i have lost in the transition from Blogger to Wordpress and vice versa.
The video was made in 2010, and have changed a little from what Gmail is now.

How-to Catalog your hard disc collection the easy way

If you are an avid collector of movies or songs like me; at some point in time, you will realize that managing them is really a pain in the neck. You actually don't have a reference point, where you can check and validate if you already have it or not. Here's a really quick way of having a simple list of your collections.

Hack Android games - Method 4

Hack method 4: 

This is a different level of hack method and works on most of the Android games. If you have missed earlier hack methods (1 to 3), read them here. Like earlier hack methods, this requires a rooted phone and GameKiller tool. To learn how to root your phone, please read here.

Disclaimer: Should you choose to root your phone, do it at your own risk. I will not be responsible, in whatsoever way, in case you brick your phone in the process.
Caution:  This is an extensive step by step tutorial with lots of images. If you are using a limited data connection, you are advised to switch to a Wifi connection.

Introduction to Formulas and Functions in Excel - Part Two

This is the second introductory part of Excel, to familiarize with Formulas and Functions in Excel. If you have missed part one, read it here. To begin with, formulas is the main backbone of a spreadsheet, without it, it would have been just a normal word-processing document. This part will introduce you to Formulas, to help you speed up with spreadsheets.

Quickly create multiple defined names at once in Excel

In the earlier example of using natural language in Excel, where we use name ranges; one has to create multiple data names for each of the location and data type. Heres a quick way to do so.
Here is a quick shortcut to create multiple data range at once.

How to quickly find rank in a data table

You might have came across various data tables, where you wish to sort data or rank them as per the performance. There is a Function called RANK, which you can use to quickly find the performance ranking.

Simplify Excel with custom defined names

Excel has hundreds of formula's available, for varied subjects and requirements. Have you ever wondered if you could work a way where you could use user friendly language to derive what you want; kind of programming your way in Excel !! Heres a way how to...

Sum of same cell across multiple worksheets

Suppose you have 12 identical table across worksheets, for each month. And you want to take sum of each of the cells across all the worksheets. You would use mouse and keyboard to browse each of the sheets and select the cells to get this =Jan!E6+Feb!E6+Mar!E6+Apr!E6…Dec!E6
Todays post is to show you a shorter way.