Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
I hope you've enjoyed working through Excel 2010. If you're looking for more information about PivotTables and about PowerPivot, then I've got a couple of resources for you. The first is the Excel 2010 Essential Training course available from lynda.com and also if you're looking into PivotTable automation you should look into my course Excel: VBA in Depth. Both of those courses are available in the lynda.com Online Training Library and also, you can go into a lot more depth on PowerPivot.
The best book that I found on the subject is Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that was published by Microsoft Press and then you can also go to www.powerpivot.com. That's where you download PowerPivot and you can also find other tutorials and information about how to use the software. Thanks again for working through the course and I hope you get a lot out of PivotTables in Excel 2010.
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.