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?
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.
Have you ever thrown a pebble in water? You must have in your childhood! The pebble follows not a straight line but a parabolic path.
It is not uncommon that we want to sum data on the basis of certain criteria – on the basis of weeks, months, every tenth day and so on.
Deleting rows are usually done by two methods as explained below.
The up and down arrows on stock exchange information board is the life line of trading business.
The world has been growing rapidly over the past few decades. Today modern technology has completely changed our lifestyle and is adding a lot to our daily lives
A spreadsheet is a sheet consisting of rows and columns which intersect with each other to form cell. Data are entered in each cell for calculation, storage or manipulation. Excel is collection of electronic spreadsheets
A spreadsheet is an electronic document formed by the combination of rows and columns marked with a grid. Excel is a matrix and powerful platform and a massive program.
Power Query allows the execution of several steps in series for the basic purpose of transformation of data present in Excel.
Measures is amongst the most important and highly powerful features in Power Pivot. Measures are actually the calculations or formulas you add to the Pivot Table. Below is an example of it.
Excel has pivot tables that offer different types of calculations. You can start off with it by selecting the ‘Show Values As’ option. Then you can get the calculation of the ‘Percent of Row Total’ as well.
Power Query is a very strong tool available in Excel. It allows you to perform different types of transformations on your data.
In case you need to transpose a dataset in Excel, that is, you want to convert the columns into rows and vice versa, it is very hard to do that manually.
Microsoft Excel Pivot Tables have many functions available through the option of Show Values As. One particular calculation can be used to display the Parent Row Total Percentage.
A data set’s comparative view can easily be represented visually with the aid of a heat map
Normally, the VLOOKUP function lookup function is normally not sensitive to case
Inserting rows in between selected rows, is one of the most necessary and important functions we require when working in excel worksheets.