16 July 2010
VLOOK UP This function scans down the row headings at the side of a table to find a specified item.When the item is found, it then scans across to pick a cell entry.
There is no R look up in excel
HLOOKUPThis function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry.
pivot table
biggest advantage to using Pivot Tables is the fact that we can generate and extract meaningful information from a large table of information within a matter of minutes. Or perhaps it is because they will not use up a lot of memory from your PC. In a lot of cases we could get the same results from a table of data by using Excels built in functions, but this would take more time and use far more memory. On top of this, if we wanted some new information we can simply drag-and-drop (pivot). We can also opt to have our information update each time we open the Workbook and/or by clicking refresh.
CAclubindia
