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