Excel Magic Trick #51 Part 1: Bad Data To Pivot Table
See how to transform data that is not in the correct Excel format to the correct Excel Table format so that we can make a Pivot Table (PivotTable). See how to use Go To Blanks, Delete Rows and Columns, Name Ranges, Use the VLOOPUP function to create data that is in Excel table format.
Take the Excel Table data and create a pivot table with Grouped Dates, fields from the field list, and fields in the Page or Report Filter area. Then see the magic Show Pages trick that instantly creates 2 reports from the main Pivot Table (PivotTable)!
Channel: Science & Technology
Uploaded: March 29, 2008 at 6:48 pm
Author: ExcelIsFun
Length: 10:08
Rating: 5.00
Views: 2031
Tags: Colle Community Data Dates Excel function Gel Girvin Go Group Highline Mike Pages Pivot PivotTable Show Table To VLOOKUP
Video Comments
|
