![]() ![]() Next time we’ll go through and clean up several issues in the consolidated Pivot Table and I’ll show you how the page fields we set up in the wizard can be used in the new Pivot Table. When I don’t get the result I expect, I include in the video how to go back and correct the ranges. Watch carefully and you’ll see I accidentally leave out the top row with the months in two of the three ranges. One of the tricks to consolidating data is to not include any totals in the ranges you add in the wizard. ![]() This video goes through the Pivot Table Wizard to actually create the Pivot Table. Lesson 18 added the Pivot Table Wizard to the Quick Access Toolbar and prepared the data to consolidate. Here’s part 2 of our series on consolidating multiple Excel ranges into a single Pivot Table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |