- When you are ready to download PowerPivot for Excel 2010…you can do so by going to the main Microsoft.com website,…and searching for the download by its ID number.…Microsoft, like many companies, changes its website a lot,…so it's hard to give you a direct link…to the file that you need.…Instead what I'll do is show you…how to use the search prompt,…so I'll click the search button here…on the main Microsoft.com page,…and in the search box I will type in its ID,…and that is id=29074 and press enter.…
I see my search results, and my first one…appears to be in Spanish as spoken in Spain,…so rather than work in a language…with which I'm not familiar, I will select the URL,…press control C, go to the address bar, press control V,…and I will edit so that the language code…instead of es-es is en-us, and press enter.…
There I have my download…and the page is available in English.…If I would have clicked the link to the…Spanish language version of this page…then I could have just used the Select Language control,…and selected English, but in this case I am working…
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
-
Welcome52s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables4m 2s
-
Creating a PivotTable4m 20s
-
Pivoting a PivotTable3m 47s
-
Configuring a PivotTable3m 22s
-
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 8s
-
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: Downloading and installing PowerPivot