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.
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?
Accounts finance and marketing people are often concerned with the term “Quarter” in context of their budgeting and marketing assignments.
We encounter this problem of numbers behaving as text with commas when we import data from some other software in to excel sheet.
We often have sheets with similar tables and with similar layout.
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.
Data bars are amongst one of the many feature excel has for presenting data.
Total Count : 192
Excel has a built in function to create hyperlinks &...
“Query” in MS Excel has same meaning as ...
Our today’s post is about “Power Map&rdq...
Conventional charts are mostly used for displaying r...
In our last post, we explored how to use calculated ...
Made with in Istanbul
Get notified first! Sign-up free for our newsletter.