Excel 2007 Pivot Tables- Column labels can do everything row labels can do- same in latest versions
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
Excel 2007 Pivot Tables Full Course
Introduction to why Pivot Tables: • Why Pivot Tables in Excel 2007- appli...
Pivot Table data source setup: • Pivot Tables Excel 2007: Required dat...
Build your first Pivot Table: • Pivot Tables- Set up your first pivot...
Options available in Pivot Tables Excel 2007 Ribbon: • Options available in Pivot Ribbon in ...
Values in Pivot Tables: • Pivot Tables in Excel 2007: Options i...
Working with the Rows part of a Pivot Table: • Pivot Tables Row Labels in Excel 2007
Working with the columns part of a Pivot Table: • Excel 2007 Pivot Tables- Column label...
Working with the rows and columns in Pivot Tables : • Pivot Tables Excel 2007: Combine rows...
Using the Report Filter in Pivot Tables: • Pages in your Pivot Tables incl creat...
Grouping items in a pivot table- days to weeks/ months, bands of numbers: • Grouping data in Excel 2007 Pivot Tab...
Build Pivot Charts/ Graphs directly off the Pivot Table: • Link a Graph/ Chart to a Pivot Table ...
Conditional formatting on Pivot Tables: • Conditional Formatting on Pivot Table...
Build formula directly into Pivot Tables: • Building calculations into Pivot Tabl...
Get individual cells out of a Pivot Table: • Extract a single cell from a Pivot Ta...
Linking a pivot table to a database/ external source: • Link Pivot Tables to external databas...
Consolidate Pivot Table data from multiple locations: • Consolidate data from multiple source...
Now let's look at the Column Labels available.
What you can see here is that the pivot table has got the months in the row labels with some amounts. It is very simple to put everything in the column labels. I grab an item, pull it across here, let go and you'll see very quickly your pivot table has changed so the months are now in the column labels.
Everything we could do on the row labels can be done on the column labels. So, for example, if I come here and I take the day of the week, I can click it, drag it, and maybe put it after the month, let go, now we have got the month, the day of the week and the related data that relates to it. If I don't like that, click here, maybe put it above the month, let go. Now you can see all the day 1's- January, February, March -- all the day 2's - January, February, March etc. I am just going to go back there.
All options that were available under row labels are available under column labels. So if I right click here, you will see I can go to Field Settings and everything here is exactly the same as the row labels - so we suggest you watch the row label video clip to see how this can be useful
Смотрите видео Excel 2007 Pivot Tables- Column labels can do everything row labels can do- same in latest versions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь AuditExcel Advanced Excel and Financial Model Training and Consulting 03 Март 2013, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,031 раз и оно понравилось 0 людям.