A Pivot Table is an interactive table that automatically extracts, organizes, and summarizes your data. You can use a Pivot Table to analyze the data, make comparisons, detect patterns and relationships, and discover trends.
This short video is taken from a recording of a webinar that I delivered in 2012 where I demonstrated how to create and use Pivot Tables in Excel 2011 for Mac.
I need to know how to implements the functions
Hi – which functions are you interested in?
Hi, how do I move pivot tables into the same worksheet? Everytime I do it it says destination reference is not valid.
Hi Syakirah. You have to specify a single cell. In the move dialog box, specify the sheet name and the cell where you want the pivot table to start, with an exclamation mark between them, for example: my_sheet_name!A1