Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel: Lookup Tables v. Pivot Tables
Resolved · Low Priority · Version 2003
Greta has attended:
Excel Intermediate course
Project Management - Framework & Processes course
Can you explain when I should use a Lookup table versus a when I should use a Pivot table?
Hi Greta
Thank you for your question and welcome to the forum.
A lookup is typically used to extract a piece of data from a cell within a database/list; whereas a pivot table is used to summarise/analyse data which is stored in a database/list in a table/matrix format.
We cover VLOOKUP, HLOOKUP and pivot tables on our Excel Advanced course.
I hope this helps.
Amanda
Wed 28 Jan 2009: Automatically marked as resolved.
|
Excel tip:Formula for last day of monthIn some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 |
We'll call during UK business hours
Server loaded in 0.05 secs.