Excel Tips and Tutorials

Creating Histogram With Analysis Tool Pack

One of the best ways to find how your data is behaving is to plot a histogram. Creating histogram is amongst the firs step we take to analyze the data as it outlines how the data is distributed, details about the skew-ness and kurtosis (described later in this section). 

Performing The Three Dimensional Lookup

Two dimensional lookup is obvious – we have a header row and a column and we want to look at the intersection of the two criteria’s.

Averaging The 5 Lowest Values In Your Data!

Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed? 

How To Find The Quarter Of Year

Accounts finance and marketing people are often concerned with the term “Quarter” in context of their budgeting and marketing assignments. 

Using Substitute Function To Convert Values With Comma To Numbers

We encounter this problem of numbers behaving as text with commas when we import data from some other software in to excel sheet. 

How To VLOOKUP From Tables In Different Sheets In Excel

We often have sheets with similar tables and with similar layout.

Finding if a Number if Prime!

Prime Numbers are numbers that are only divisible by their selves. In this small tutorial we will guide you how to find if a number is prime or not.

Total Count  : 186