Join Curt Frye for an in-depth discussion in this video Managing table columns, part of Excel 2010: Pivot Tables.
After you bring your data into PowerPivot you can manage the data within both…the PowerPivot datasheet and also within your PivotTables.…In this movie I will show you how to work with PowerPivot columns of data.…So to display the data that I have in this worksheet, I will click the…PowerPivot tab and then open the PowerPivot window by clicking the PowerPivot…Window button in the Launch section of this tab on the Ribbon, and when I do my…data appears in PowerPivot, and to indicate how much data we're working with,…at the bottom left corner you can see that we are currently looking at Row 1 of 964,260.…
In PowerPivot as in Excel you can manipulate the columns inside of…the PowerPivot window.…So let's say for example that you want to hide a particular column and in…this case we will just say that we want to hide the Product column, to do…that you can right-click the column header and then click Hide Columns and…then select whether you want to hide the column from the PowerPivot window…and the PivotTable,…
Author
Curt Frye
Released
4/19/2011- Formatting data for use in a PivotTable
- Connecting to an external data source
- Refreshing a data source
- Adding, removing, and positioning subtotals and grand totals
- Creating a calculated field
- Grouping PivotTable fields
- Clearing and reapplying PivotTable filters
- Applying field styles
- Formatting cells
- Creating a PivotChart
- Printing PivotTables and PivotCharts
- Creating relationships between tables in a PowerPivot model
- Using the DAX language for advanced summaries in PowerPivot
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome55s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables4m 2s
-
Creating a PivotTable4m 20s
-
Pivoting a PivotTable3m 47s
-
Configuring a PivotTable3m 23s
-
Managing PivotTables3m 26s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field2m 27s
-
Grouping PivotTable fields3m 17s
-
3. Sorting and Filtering PivotTable Data
-
Creating a custom sort order2m 48s
-
Formatting slicers3m 43s
-
4. Formatting PivotTables
-
Creating a PivotTable style4m 37s
-
5. Applying Conditional Formatting to PivotTables
-
6. Creating and Manipulating PivotCharts
-
Creating a PivotChart3m 29s
-
Pivoting a PivotChart3m 5s
-
Filtering a PivotChart3m 45s
-
Formatting a PivotChart3m 35s
-
Changing a PivotChart layout3m 14s
-
-
7. Printing PivotTables and PivotCharts
-
Printing a PivotTable4m 2s
-
Printing a PivotChart1m 55s
-
-
8. Manipulating PivotTables Using Macros
-
Running a macro5m 57s
-
9. Getting Started with PowerPivot
-
Introducing PowerPivot2m 9s
-
Importing PowerPivot data3m 14s
-
Managing table columns4m 1s
-
-
10. Working with DAX Expressions
-
Introducing the DAX language2m 58s
-
Using DAX operators4m 44s
-
Surveying DAX functions2m 40s
-
Using aggregate functions4m 24s
-
-
Conclusion
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Managing table columns