| 文件 | 大小 |
|---|
| 01 Introduction/001 The Data.mp4 | 26.94 MB |
| 01 Introduction/attached files/001 Pivot-Table-Tips-and-Tricks.xlsx | 22.28 kB |
| 02 Tips and Tricks/002 Use a Table for Your Source Data.mp4 | 63.14 MB |
| 02 Tips and Tricks/003 Create a PivotTable With a Keyboard Shortcut.mp4 | 2.50 MB |
| 02 Tips and Tricks/004 PivotTable and PivotChart Wizard Keyboard Shortcut.mp4 | 5.66 MB |
| 02 Tips and Tricks/005 Show Details Behind a Value.mp4 | 3.49 MB |
| 02 Tips and Tricks/006 Turn Off Show Details to Avoid Accidental Double Clicks.mp4 | 4.15 MB |
| 02 Tips and Tricks/007 Replace Blank Cells.mp4 | 3.45 MB |
| 02 Tips and Tricks/008 Show Items with No Data.mp4 | 4.12 MB |
| 02 Tips and Tricks/009 Filter Items Using a Keyboard Shortcut.mp4 | 1.84 MB |
| 02 Tips and Tricks/010 Add the Current Search Selection to a Filter.mp4 | 2.98 MB |
| 02 Tips and Tricks/011 Use The Select All Filter Toggle.mp4 | 1.47 MB |
| 02 Tips and Tricks/012 Defer Layout Update.mp4 | 2.41 MB |
| 02 Tips and Tricks/013 Add or Remove Fields Using the Check Box.mp4 | 1.59 MB |
| 02 Tips and Tricks/014 Filter Fields from the PivotTable Fields Window.mp4 | 2.82 MB |
| 02 Tips and Tricks/015 Rename any Label.mp4 | 3.46 MB |
| 02 Tips and Tricks/016 Rename a Label with a Trailing Space.mp4 | 1.84 MB |
| 02 Tips and Tricks/017 Hide or Unhide the PivotTable Fields Window.mp4 | 1.88 MB |
| 02 Tips and Tricks/018 Move Resize or Close the PivotTable Fields Window.mp4 | 1.49 MB |
| 02 Tips and Tricks/019 Undock the PivotTable Fields Window.mp4 | 1.21 MB |
| 02 Tips and Tricks/020 Double Click to Dock the PivotTable Fields Window.mp4 | 1.31 MB |
| 02 Tips and Tricks/021 Change the Default Arrangement of the PivotTable Fields Window.mp4 | 2.18 MB |
| 02 Tips and Tricks/022 Change the Sort Order of Your Field List.mp4 | 2.52 MB |
| 02 Tips and Tricks/023 Search the PivotTable Fields List.mp4 | 1.71 MB |
| 02 Tips and Tricks/024 Group Together Items in a Field.mp4 | 8.80 MB |
| 02 Tips and Tricks/025 Group Together Items in a Field with a Keyboard Shortcut.mp4 | 1.08 MB |
| 02 Tips and Tricks/026 Ungroup Items in a Field with a Keyboard Shortcut.mp4 | 1.41 MB |
| 02 Tips and Tricks/027 Group Date Fields.mp4 | 4.34 MB |
| 02 Tips and Tricks/028 Group Numbers Into Ranges.mp4 | 3.59 MB |
| 02 Tips and Tricks/029 Give Your Pivot Table a Different Style.mp4 | 3.53 MB |
| 02 Tips and Tricks/030 Add or Remove Different Style Elements.mp4 | 2.02 MB |
| 02 Tips and Tricks/031 Refresh Your Data.mp4 | 4.38 MB |
| 02 Tips and Tricks/032 Refresh with a Keyboard Shortcut.mp4 | 1.84 MB |
| 02 Tips and Tricks/033 Refresh All with a Keyboard Shortcut.mp4 | 7.15 MB |
| 02 Tips and Tricks/034 Automatically Refresh Data When Opening Your Workbook.mp4 | 1.46 MB |
| 02 Tips and Tricks/035 Select the Entire Pivot Table.mp4 | 2.49 MB |
| 02 Tips and Tricks/036 Clear All Filters.mp4 | 1.69 MB |
| 02 Tips and Tricks/037 Clear Your Entire Pivot Table.mp4 | 1.77 MB |
| 02 Tips and Tricks/038 Clear Old Field Items.mp4 | 4.56 MB |
| 02 Tips and Tricks/039 Format Numbers.mp4 | 3.03 MB |
| 02 Tips and Tricks/040 Expand or Collapse Field Headings.mp4 | 4.13 MB |
| 02 Tips and Tricks/041 Double Click to Expand or Collapse Field Headings.mp4 | 1.19 MB |
| 02 Tips and Tricks/042 Add or Remove Expand or Collapse Buttons.mp4 | 1.63 MB |
| 02 Tips and Tricks/043 Automatically Create a Pivot Table for Each Item in a Filter.mp4 | 4.72 MB |
| 02 Tips and Tricks/044 Allow Multiple Filters Per Field.mp4 | 31.82 MB |
| 02 Tips and Tricks/045 Use a Pivot Table to Get a List of Unique Values.mp4 | 16.34 MB |
| 02 Tips and Tricks/046 Count the Occurrence of an Item in Your Data.mp4 | 18.48 MB |
| 02 Tips and Tricks/047 Delete Your Source Data.mp4 | 24.71 MB |
| 02 Tips and Tricks/048 Sort Items in Alphabetical Order.mp4 | 23.83 MB |
| 02 Tips and Tricks/049 Manually Sort Items.mp4 | 14.82 MB |
| 02 Tips and Tricks/050 Sort Items by Value.mp4 | 32.63 MB |
| 02 Tips and Tricks/051 Create a Custom Sort Order.mp4 | 28.05 MB |
| 02 Tips and Tricks/052 Insert a Blank Line After Each Item.mp4 | 10.56 MB |
| 02 Tips and Tricks/053 Double Click to Open Value Field Settings.mp4 | 12.40 MB |
| 02 Tips and Tricks/054 Count of Distinct Items.mp4 | 32.02 MB |
| 02 Tips and Tricks/055 Hide Selected Items.mp4 | 6.80 MB |
| 02 Tips and Tricks/056 Keep Selected Items.mp4 | 8.93 MB |
| 02 Tips and Tricks/057 Change the Layout.mp4 | 21.68 MB |
| 02 Tips and Tricks/058 Repeat All Item Labels.mp4 | 11.79 MB |
| 02 Tips and Tricks/059 Turn Grand Totals On or Off.mp4 | 11.29 MB |
| 02 Tips and Tricks/060 Turn Subtotals On or Off.mp4 | 10.36 MB |
| 02 Tips and Tricks/061 Turn Off GETPIVOTDATA.mp4 | 20.26 MB |
| 02 Tips and Tricks/062 Add Duplicate Fields to the Values Area.mp4 | 8.05 MB |
| 02 Tips and Tricks/063 Add Data Bars.mp4 | 24.70 MB |
| 02 Tips and Tricks/064 Add Color Scales.mp4 | 16.08 MB |
| 02 Tips and Tricks/065 Add Icon Sets.mp4 | 17.22 MB |
| 02 Tips and Tricks/066 Add Highlighted Cells Rules.mp4 | 23.54 MB |
| 02 Tips and Tricks/067 Add Highlighted Top or Bottom N Formatting.mp4 | 19.21 MB |
| 02 Tips and Tricks/068 Format Numbers as Invisible Text.mp4 | 10.30 MB |
| 02 Tips and Tricks/069 Use Conditional Format Settings to Remove Text.mp4 | 17.83 MB |
| 02 Tips and Tricks/070 Prevent Column Width Changing on Update.mp4 | 17.16 MB |
| 02 Tips and Tricks/071 Add a Calculated Field.mp4 | 30.46 MB |
| 02 Tips and Tricks/072 Changing or Removing a Calculated Field.mp4 | 16.91 MB |
| 02 Tips and Tricks/073 Insert a Calculated Field with a Keyboard Shortcut.mp4 | 9.90 MB |
| 02 Tips and Tricks/074 Add a Calculated Item.mp4 | 25.92 MB |
| 02 Tips and Tricks/075 Change or Remove a Calculated Item.mp4 | 16.68 MB |
| 02 Tips and Tricks/076 Insert a Calculated Item with a Keyboard Shortcut.mp4 | 19.70 MB |
| 02 Tips and Tricks/077 Replace Errors.mp4 | 18.62 MB |
| 02 Tips and Tricks/078 Create a PivotChart.mp4 | 22.12 MB |
| 02 Tips and Tricks/079 Insert a PivotChart with a Keyboard Shortcut.mp4 | 6.81 MB |
| 02 Tips and Tricks/080 Add a Slicer.mp4 | 16.83 MB |
| 02 Tips and Tricks/081 Add a Timeline.mp4 | 19.96 MB |
| 02 Tips and Tricks/082 Hide All Field Buttons on a Pivot Chart.mp4 | 12.24 MB |
| 02 Tips and Tricks/083 Connect Slicers or Timelines to Multiple Pivot Tables.mp4 | 19.57 MB |
| 02 Tips and Tricks/084 Change the Number of Columns in a Slicer.mp4 | 12.38 MB |
| 02 Tips and Tricks/085 Filter on Top or Bottom N Items.mp4 | 41.11 MB |
| 02 Tips and Tricks/086 Add a Value Filter for any Field.mp4 | 16.84 MB |
| 02 Tips and Tricks/087 Add Multiple Subtotal Calculations.mp4 | 17.91 MB |
| 02 Tips and Tricks/088 Include New Items in Manual Filters.mp4 | 27.38 MB |
| 02 Tips and Tricks/089 Use an External Data Connection.mp4 | 21.55 MB |
| 02 Tips and Tricks/090 Refresh External Connections on a Schedule.mp4 | 16.67 MB |
| 02 Tips and Tricks/091 Show Value As.mp4 | 25.70 MB |
| 02 Tips and Tricks/092 Show Value as of Grand Total.mp4 | 26.31 MB |
| 02 Tips and Tricks/093 Show Value As Of Column Total.mp4 | 21.49 MB |
| 02 Tips and Tricks/094 Show Value as of Row Total.mp4 | 19.71 MB |
| 02 Tips and Tricks/095 Show Value as of Parent Column Total.mp4 | 39.08 MB |
| 02 Tips and Tricks/096 Show Value as of Parent Row Total.mp4 | 21.48 MB |
| 02 Tips and Tricks/097 Show Value as Difference.mp4 | 13.27 MB |
| 02 Tips and Tricks/098 Show Value as Running Total.mp4 | 13.31 MB |
| 02 Tips and Tricks/099 Show Value as of Difference.mp4 | 17.47 MB |
| 02 Tips and Tricks/100 Show Value as of Running Total.mp4 | 17.86 MB |
| 02 Tips and Tricks/101 Show Value as Rank.mp4 | 20.54 MB |
| Torrent downloaded from 1337x.to.txt | 43.00 B |
| Torrent Downloaded From limetorrents.info.txt | 53.00 B |
-