Lynda com- Excel 2010 Pivot Tables in Depth

1. 00 Introduction/01. Welcome.mov5.42MB
2. 00 Introduction/02. Using the exercise files.mov852.43KB
3. 01 Creating and Pivoting PivotTables/09. Updating and refreshing PivotTable data sources.mov7.01MB
4. 01 Creating and Pivoting PivotTables/02. Formatting data for use in a PivotTable.mov6.81MB
5. 01 Creating and Pivoting PivotTables/08. Consolidating data from multiple sources.mov6.79MB
6. 01 Creating and Pivoting PivotTables/01. Introducing PivotTables.mov6.55MB
7. 01 Creating and Pivoting PivotTables/03. Creating a PivotTable.mov6.51MB
8. 01 Creating and Pivoting PivotTables/06. Connecting to an external data source.mov5.85MB
9. 01 Creating and Pivoting PivotTables/10. Managing PivotTables.mov5.37MB
10. 01 Creating and Pivoting PivotTables/04. Pivoting a PivotTable.mov4.25MB
11. 01 Creating and Pivoting PivotTables/05. Configuring a PivotTable.mov4.04MB
12. 01 Creating and Pivoting PivotTables/07. Connecting to an Access database.mov3.63MB
13. 02 Summarizing PivotTable Data/06. Using PivotTable data in a formula.mov7MB
14. 02 Summarizing PivotTable Data/02. Changing the PivotTable data field summary operation.mov6.84MB
15. 02 Summarizing PivotTable Data/01. Adding, removing, and positioning subtotals and grand totals.mov5.21MB
16. 02 Summarizing PivotTable Data/03. Summarizing more than one data field.mov4.75MB
17. 02 Summarizing PivotTable Data/05. Grouping PivotTable fields.mov4.35MB
18. 02 Summarizing PivotTable Data/04. Creating a calculated field.mov3.7MB
19. 02 Summarizing PivotTable Data/07. Drilling down to the underlying data.mov2.5MB
20. 03 Sorting and Filtering PivotTable Data/08. Filtering a PivotTable with report filter fields.mov6.93MB
21. 03 Sorting and Filtering PivotTable Data/06. Filtering a PivotTable using slicers.mov6.11MB
22. 03 Sorting and Filtering PivotTable Data/07. Formatting slicers.mov5.63MB
23. 03 Sorting and Filtering PivotTable Data/02. Creating a custom sort order.mov5.52MB
24. 03 Sorting and Filtering PivotTable Data/03. Filtering a PivotTable field by selection.mov4.5MB
25. 03 Sorting and Filtering PivotTable Data/05. Filtering a PivotTable using a search filter.mov4.39MB
26. 03 Sorting and Filtering PivotTable Data/04. Filtering a PivotTable by rule.mov4.06MB
27. 03 Sorting and Filtering PivotTable Data/01. Sorting PivotTable data.mov2.86MB
28. 03 Sorting and Filtering PivotTable Data/09. Clearing and reapplying PivotTable filters.mov2.05MB
29. 04 Formatting PivotTables/02. Creating a PivotTable style.mov8.37MB
30. 04 Formatting PivotTables/01. Applying a PivotTable style.mov8.33MB
31. 04 Formatting PivotTables/03. Changing the PivotTable layout.mov4.77MB
32. 04 Formatting PivotTables/04. Changing the data field number format.mov2.83MB
33. 05 Applying Conditional Formatting to PivotTables/03. Formatting PivotTable cells using data bars.mov5.93MB
34. 05 Applying Conditional Formatting to PivotTables/04. Formatting PivotTable cells using color scales.mov5.69MB
35. 05 Applying Conditional Formatting to PivotTables/02. Highlighting the top or bottom values in a PivotTable.mov5.15MB
36. 05 Applying Conditional Formatting to PivotTables/07. Controlling how multiple rules are applied.mov5.11MB
37. 05 Applying Conditional Formatting to PivotTables/01. Highlighting cells by applying a rule.mov4.2MB
38. 05 Applying Conditional Formatting to PivotTables/06. Editing conditional formatting rules.mov3.49MB
39. 05 Applying Conditional Formatting to PivotTables/08. Deleting a conditional formatting rule.mov3.25MB
40. 05 Applying Conditional Formatting to PivotTables/05. Formatting PivotTable cells using icon sets.mov3.2MB
41. 06 Creating and Manipulating PivotCharts/06. Changing a PivotChart's chart type.mov7.15MB
42. 06 Creating and Manipulating PivotCharts/04. Formatting a PivotChart.mov5.98MB
43. 06 Creating and Manipulating PivotCharts/01. Creating a PivotChart.mov5.16MB
44. 06 Creating and Manipulating PivotCharts/03. Filtering a PivotChart.mov5.12MB
45. 06 Creating and Manipulating PivotCharts/02. Pivoting a PivotChart.mov4.32MB
46. 06 Creating and Manipulating PivotCharts/05. Changing a PivotChart's layout.mov4.24MB
47. 06 Creating and Manipulating PivotCharts/07. Adding a trendline to a PivotChart.mov3.74MB
48. 07 Printing PivotTables and PivotCharts/01. Printing a PivotTable.mov6.37MB
49. 07 Printing PivotTables and PivotCharts/02. Printing each item on its own page.mov5.23MB
50. 07 Printing PivotTables and PivotCharts/03. Printing a PivotChart.mov2.73MB
51. 08 Manipulating PivotTables Using Macros/02. Running a macro.mov9.74MB
52. 08 Manipulating PivotTables Using Macros/01. Recording and reviewing a macro.mov6.55MB
53. 08 Manipulating PivotTables Using Macros/03. Creating a simple PivotTable presentation kit.mov5.03MB
54. 09 Getting Started with PowerPivot/06. Creating relationships between tables.mov7.14MB
55. 09 Getting Started with PowerPivot/04. Managing table columns.mov6.76MB
56. 09 Getting Started with PowerPivot/02. Downloading and installing PowerPivot.mov5.38MB
57. 09 Getting Started with PowerPivot/03. Importing PowerPivot data.mov5.25MB
58. 09 Getting Started with PowerPivot/05. Adding tables to a PowerPivot model.mov4.32MB
59. 09 Getting Started with PowerPivot/01. Introducing PowerPivot.mov3.48MB
60. 10 Working with DAX Expressions/06. Using filters in aggregate functions.mov7.32MB
61. 10 Working with DAX Expressions/05. Using aggregate functions.mov6.69MB
62. 10 Working with DAX Expressions/02. Using DAX operators.mov6.31MB
63. 10 Working with DAX Expressions/04. Adding calculated columns and measures.mov6.21MB
64. 10 Working with DAX Expressions/03. Surveying DAX functions.mov5.43MB
65. 10 Working with DAX Expressions/01. Introducing the DAX language.mov4.81MB
66. 11 Conclusion/Additional resources.mov1.14MB