Viewers: in countries Watching now:
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
- 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 in English, so I'll go ahead and click the Download button. If you don't see anything happen after you click download you might have your popup blocker on, and popups do need to be enabled for this page for the download to start.
I'll go ahead and click Download, and in this page I see that I can select from a number of different files. I am running the 32 bit version of Excel instead of the 64 bit, and if you're in doubt just select the x86 version, so I will check that box and click Next. Doing so starts the download, and now with the download complete I will open my downloads folder, and double click PowerPivot_for_Excel_x86.
I'll verify that I do want to Run the file, and step through the Excel PowerPivot Setup Wizard. I'll click Next to go passed the first screen, I'll accept the terms of the license agreement, click Next, and I'll just type in a company, Lynda.com. Click Next, and then click Install, and now that it's done I can click Finish. I'll close my Windows Explorer window, and run Excel.
As Excel starts you'll see that it has loaded the PowerPivot add-in, and then when you run the program for the first time after you install PowerPivot a warning box appears indicating that it has installed a customization, and asking you if you want to keep it. You can either select not to install it, if you don't recognize the publisher, or you can choose to keep the installation by clicking the Install button. In this case we are familiar with the program, and we did want to install it, so we can click Install. When we do Excel installs PowerPivot, and the PowerPivot tab appears on the ribbon.
We'll just click it to make sure all the tools are there, and everything looks to be in order. Now that PowerPivot's installed we can start downloading data, and working with it quickly and efficiently.
There are currently no FAQs about Excel 2010: Pivot Tables in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.