Trace Location Of A Person By Chatting on Facebook or WhatsApp

There are often situations when you need to track the location of the person you’re talking to. Not always, but sometimes its really urgent. So, we have come here with three best methods to help you be aware :

1. Through Facebook Chat

This is fast,but a little tricky as well, thought its pretty straight forward. Many people have used this method and its been a success. You need to be friends with whoever you want to track on Facebook. Next have a conversation with that friend on Facebook. Make sure all other tabs remain closed, and no application is running on the background that consumes your net.

Next, follow these :

• Press Win+R , a shortcut it us.
• Next you type cmd and enter.
• In the command prompt that appears, type netstat -an and click enter.
• This now provides to you with a list of IP addresses, which will have the person’s address whom you are chatting too as well.
• You now have to have a look at the possible IP of the person.
• Next you have to go to http://www.ip-adress.com/ip_tracer/ and then type the IP address on the box which says “lookup this ip or website”

And there you go!

2. By Creating Tracking Link

this is a better source than the first one. Also, once done, it lets you track the addresses.Basically you are to great a link which will save their IP address  with timestamp and user-agent/browser.

All you do is follow as stated below:

1. Visit a website such as 000webhost, ByteHost, Free Hostia, etc. (See Full List of Free Web Hosting Sites Here)
2. Now you need to make up a domain name and register yourself there for free. May be a sub domain such yoursite.freehosting.com. And aslo make sure you can add up your own files..
3. Next you have to download a zip file: Track-IP
4. You will see files, Namely: img.jpg, index.php and log.txt. You need to out them up on your free website root.
5. Now, the link you created, (yoursite.freehosting.com), this will be your tracking link. You send it to the person, and make sure that they visit it
6. Once they click on the URL, the log.txt file will trace their IP, Browser along with the timestamp. And now you are through!*This works out better on email*
   

   3. Using Website Tracing Scripts

   This needs you to have a website.
   Now the steps:
   • Add the Google Analytics tracking code on your website.
   • Create a link of your website. A dummy post would be more preferable.
   • Just like in the above method you need to make them click over the link you just sent.
   • If you happen to be online, you would be able to see them on your Google Analytics account for the link. Otherwise you cab visit their later, and check out the history and other details.
   • For the user’s stat, Google Analytics is a lot more derailed.
   There are other tracking links such as Histats, Statcounter, etc.

Basic to Advanced Excel Formulas and Functions

Excel provides an enormous number of established formulas and assistance in auditing and calculating your data. The primary groupings are financial, logical, text, date and time, lookup and reference, math and trigonometry, statistical, engineering, cube, and file-related information.

Download 70+ Free Designer Quality Excel Chart Templates

How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore?

Well, I will tell you my answer, its 293049430493 times 

Worry not! for you can become a charting superman (or elastigirl) by using these 73 free designer quality chart templates in literally no time (well, almost)

5 Powerful and Most Useful Excel FeaturesThat no will ever tell you!!

Microsoft Excel is the most useful and easy tool for business analysts. It has large number of useful formulas, features and bundles of interactive charts. But, most of us are not known of all of them and there are some more features which are powerful and easy to use to make our work simpler. You might not have noticed some of the useful Excel 2010 & 2013 features like Sparklines, Slicers, Conditional Formatting and other formulas which add value to your work. In this article, I will take you through them and will give you an idea on what are those and how to use them.

Most Useful Excel Features

Among many Excel features, there are some hidden features which are easy to use and you many not know all of them. Without any further delay, we will look at 5 such Excel features.

Sparklines

Sparklines were first introduced in Excel 2010 and are used to represent visualizations for the trend across the data in a row. It fits in a single Excel cell and saves the space on the worksheet. This is a cool feature and is very easy to use. Calculating the trend for row data and placing the visualization in the single excel is really a great feature to use.

In order to create your own Sparklines, select the range of data. Click insert on the ribbon and select the type of Sparklines (Line, Column or Win/Loss). Next, enter the range of the target where you want to show the Sparklines.

Conditional Formatting

Conditional Formatting is a well known feature of Excel. It is used to visually present the data based on the conditions met. It is also useful to create heat maps. This would be helpful to find the interesting patterns by exploring the data effectively.

To create the heat map, select the data and head over to the ribbon. Under Home, clickConditional Formatting and then click Color Scales. Now, pick the color scale. You can even set the color scale by editing the formatting rule. 

SMALL and LARGE Functions

We all know about MAX and MIN functions. They give you the maximum and minimum values of the selected data respectively. But, in order to find the 1st, 2nd, 3rd or nth largest or smallest value of the selected range if data, we can make use of LARGE and SMALL functions respectively.

In this example, in order to find the top two products for each month, we made use of MATCH and INDEX functions along with LARGE and SMALL functions. 

Remove Duplicates

Do not blame me for mentioning this feature in this list. It is very important to get rid of redundant data from the available huge amount of data. It is one of the best ways for cleaning and organizing the data and so thought of having it in this list of powerful Excel features. Removing Duplicates feature was introduced from Excel 2007 and is helpful to remove duplicates which is the most important problem which we face.

To remove duplicates, select the data and head over to the ribbon. Under Data, click theRemove Duplicates button and what you see the data without duplicates. 

Slicers

Slicers act as visual filters. It helps you to visualize the subset of data as a connected chart or as a raw data. For example, if you want to show the trend of sales of various products, then you can create the interactive sales trend chart using Slicers. Based on the product you select, respective chart is shown. Slicers were first introduced in Excel 2010 and enhanced a lot in Excel 2013.

In Excel 2013, if you want to add Slicer to your charts, select the data range and click on insert > Slicer. Now, select the part of the data you want to use as a filter. In the image above, Product column is used as a filter. 

How many of you have used these powerful and useful Excel features? If you want to add more features to the list, please let us know through comments.

Best 15 Key Principles for Excel Best Practice

People often ask about the best principles to follow to make the better excel spreadsheets. Hope you might also be interested to know them. Here we go…

Creating an Interactive Game in Microsoft Excel

Creating an Interactive Game in Microsoft Excel

In the activity you will create and interactive game for elementary kids. There will be 9 questions and if the student answers them correctly it will reveal a picture underneath. The picture we will use for this activity is the shown below. Save it to your student folder.

Open Microsoft Excel 2007: Start > All Programs > Microsoft Office > Microsoft Excel 2007

Create a New Workbook

How to Make a Budget in Excel

How to Make a Budget

Steps to Making a Budget Using Excel

Making a budget is pretty simple. But before I outline how to make a budget, I need to explain what I believe is the number one key concept in budgeting: A Budget is a Plan. "Budgeting" and "Planning" are synonymous.

"A budget is a plan for how you are going to spend your money"

A popular cliche applies here: "If You Fail to Plan, You Plan to Fail". When you break your budget, you are messing up your plan. When you stick to a budget, you are sticking to a plan. Which one sounds more optimistic?

A budget is often hated because people are always fighting against their budget. So what I want you to do when you make a budget is think of it and talk about it as a plan. Make a plan for how to spend your money and stick to your plan. I think this new point of view will help you be more optimistic, and it is certainly more empowering.

3 Crazy Excel Formulas That Do Amazing Things

I’ve always believed that Excel is one of the most powerful software tools out there. It isn’t just the fact that it’s spreadsheet software, which is by its nature powerful anyway.
No, Microsoft Excel 2013 itself has such an awesome collection of built-in tools and features that it has beyond any doubt, become one of the most useful tools for so many things. In this article, I plan to show you how powerful formulas and conditional formatting can be, with three pretty useful examples.