|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 001 Welcome.mp4 |
6.85MB |
| 002 Using the exercise files.mp4 |
996.47KB |
| 003 Introducing PivotTables.mp4 |
10.01MB |
| 004 Formatting data for use in a PivotTable.mp4 |
13.31MB |
| 005 Creating a PivotTable.mp4 |
9.87MB |
| 006 Creating a recommended PivotTable.mp4 |
6.37MB |
| 007 Pivoting a PivotTable.mp4 |
9.41MB |
| 008 Configuring a PivotTable.mp4 |
11.42MB |
| 009 Connecting to an external data source.mp4 |
5.66MB |
| 010 Consolidating data from multiple sources.mp4 |
11.01MB |
| 011 Managing PivotTables.mp4 |
13.84MB |
| 012 Managing subtotals and grand totals.mp4 |
11.36MB |
| 013 Changing the data field summary operation.mp4 |
11.63MB |
| 014 Summarizing more than one data field.mp4 |
10.36MB |
| 015 Creating a calculated field.mp4 |
10.71MB |
| 016 Using PivotTable data in a formula.mp4 |
9.86MB |
| 017 Drilling down to the underlying data.mp4 |
9.69MB |
| 018 Sorting PivotTable data.mp4 |
8.96MB |
| 019 Creating a custom sort order.mp4 |
9.65MB |
| 020 Filtering a PivotTable field by selection.mp4 |
9.82MB |
| 021 Filtering a PivotTable by rule.mp4 |
11.57MB |
| 022 Filtering a PivotTable using a search filter.mp4 |
6.89MB |
| 023 Filtering a PivotTable using slicers.mp4 |
9.77MB |
| 024 Formatting slicers.mp4 |
14.19MB |
| 025 Filtering with report filter fields.mp4 |
10.57MB |
| 026 Clearing and reapplying PivotTable filters.mp4 |
4.68MB |
| 027 Applying a PivotTable style.mp4 |
12.13MB |
| 028 Creating a PivotTable style.mp4 |
15.40MB |
| 029 Changing the PivotTable layout.mp4 |
13.71MB |
| 030 Changing the data field number format.mp4 |
8.98MB |
| 031 Highlighting cells by applying a rule.mp4 |
15.22MB |
| 032 Highlighting the top or bottom values in a PivotTable.mp4 |
14.04MB |
| 033 Formatting cells using data bars.mp4 |
13.28MB |
| 034 Formatting cells using color scales.mp4 |
15.06MB |
| 035 Formatting cells using icon sets.mp4 |
15.35MB |
| 036 Editing a conditional formatting rule.mp4 |
8.83MB |
| 037 Controlling how multiple rules are applied.mp4 |
8.39MB |
| 038 Deleting a conditional formatting rule.mp4 |
5.27MB |
| 039 Creating a PivotChart.mp4 |
9.37MB |
| 040 Pivoting a PivotChart.mp4 |
7.96MB |
| 041 Filtering a PivotChart.mp4 |
5.99MB |
| 042 Formatting a PivotChart.mp4 |
9.72MB |
| 043 Changing a PivotCharts layout.mp4 |
7.82MB |
| 044 Changing a PivotCharts chart type.mp4 |
4.00MB |
| 045 Adding a trendline to a PivotChart.mp4 |
9.41MB |
| 046 Printing a PivotTable.mp4 |
5.04MB |
| 047 Setting PivotTable print options.mp4 |
7.93MB |
| 048 Printing each item on its own page.mp4 |
16.57MB |
| 049 Printing a PivotChart.mp4 |
5.77MB |
| 050 Recording and reviewing an Excel macro.mp4 |
11.75MB |
| 051 Running an Excel macro.mp4 |
15.46MB |
| 052 Creating a simple PivotTable presentation kit.mp4 |
15.62MB |
| 053 Working with PivotTables using keyboard shortcuts.mp4 |
8.45MB |
| 054 Creating relationships between tables.mp4 |
12.04MB |
| 055 Creating a PivotTable using the data model.mp4 |
8.13MB |
| 056 Editing table relationships.mp4 |
9.50MB |
| 057 Next steps.mp4 |
2.44MB |
| ApplyStyle.xlsx |
20.91KB |
| Calculated.xlsx |
19.18KB |
| ChangeLayout.xlsx |
24.31KB |
| ChangeType.xlsx |
24.57KB |
| Clearing.xlsx |
19.50KB |
| ColorScales.xlsx |
20.96KB |
| ConditionalRules.xlsx |
20.71KB |
| Configure.xlsx |
17.97KB |
| Consolidating.xlsx |
10.49KB |
| CreatePivot.xlsx |
12.45KB |
| CreatePTChart.xlsx |
13.94KB |
| CreateRelated.xlsx |
183.78KB |
| CreateStyle.xlsx |
20.62KB |
| CustomOrder.xlsx |
18.93KB |
| DataBars.xlsx |
20.69KB |
| DataFormat.xlsx |
20.72KB |
| DataPrep.xlsx |
11.78KB |
| DefineRelationships.xlsx |
175.72KB |
| DeleteConds.xlsx |
19.72KB |
| DrillDown.xlsx |
17.37KB |
| EditConds.xlsx |
20.97KB |
| EditRelationships.xlsx |
183.79KB |
| External.xlsx |
7.49KB |
| FilterByRule.xlsx |
19.11KB |
| Filtering.xlsx |
25.24KB |
| FormatSlicer.xlsx |
20.38KB |
| Formatting.xlsx |
24.77KB |
| GetPivotData.xlsx |
18.65KB |
| Grouping.xlsx |
17.96KB |
| IconSets.xlsx |
19.42KB |
| Introducing.xlsx |
17.45KB |
| Keyboard.xlsx |
21.22KB |
| Managing.xlsx |
18.49KB |
| MoreThanOne.xlsx |
19.18KB |
| Multiple.xlsx |
19.71KB |
| OutsideSource.xlsx |
12.45KB |
| Pivoting.xlsx |
24.30KB |
| Pivoting.xlsx |
16.97KB |
| Presentation.xlsx |
21.22KB |
| PrintChart.xlsx |
25.54KB |
| Printing.xlsx |
20.56KB |
| PrintItems.xlsx |
21.17KB |
| PTLayout.xlsx |
20.60KB |
| Recommended.xlsx |
12.45KB |
| RecordMacro.xlsx |
21.18KB |
| RemoveMonth.xlsm |
25.66KB |
| ReportFilter.xlsx |
20.56KB |
| SearchFilter.xlsx |
20.38KB |
| Selection.xlsx |
20.27KB |
| SetOptions.xlsx |
20.56KB |
| Slicers.xlsx |
20.38KB |
| Sorting.xlsx |
19.32KB |
| SubAndGrand.xlsx |
17.96KB |
| Summary.xlsx |
18.34KB |
| TopTen.xlsx |
21.31KB |
| Trendline.xlsx |
24.58KB |