种子简介

种子名称： microsoft-excel-pivot-tables-for-2007-2010-2013
文件类型： 视频
文件数目： 218个文件
文件大小： 2.49 GB
收录时间： 2017-1-1 08:18
已经下载： 3次
资源热度： 233
最近下载： 2024-12-19 20:47

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:c5a13d12016f48c3c1b41ef26d6267a6689078fb&dn=microsoft-excel-pivot-tables-for-2007-2010-2013 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

microsoft-excel-pivot-tables-for-2007-2010-2013.torrent

09 PIVOT CHARTS/021 CASE STUDY FINANCIAL Pivot Table Slicer Chart Dashboard.mp467.81MB

08 CALCULATED FIELDS ITEMS/015 CASE STUDY ACCOUNTING Creating a PL Pivot Table Report.mp458.6MB

08 CALCULATED FIELDS ITEMS/016 CASE STUDY FINANCIAL Actuals v Plan with Calculated Fields.mp450.99MB

14 BONUS VIDEOS/006 Interactive Balance Sheet Pivot Table.mp447.83MB

09 PIVOT CHARTS/020 CASE STUDY ACCOUNTING PL Pivot Table report with Graphs.mp438.49MB

04 GROUPING/016 CASE STUDY ACCOUNTING Quarterly Comparative Report.mp437.65MB

07 SLICERS NEW IN EXCEL 2010/011 TIP Interactive employee photos with Slicers FUN.mp431.08MB

11 GETPIVOTDATA Formula/007 CASE STUDY ACCOUNTING Live forecasting with GETPIVOTDATA.mp431.02MB

09 PIVOT CHARTS/018 TIP Change Chart Type with Slicers FUN.mp428.79MB

14 BONUS VIDEOS/007 Monthly Sales Manager Performance Report.mp427.67MB

10 CONDITIONAL FORMATTING PIVOT TABLES/016 CASE STUDY ACCOUNTING Accounts Receivable Ageing Report Matrix.mp427.31MB

06 FILTERING/001 Filter by Dates.mp425.11MB

11 GETPIVOTDATA Formula/008 CASE STUDY FINANCIAL Channel Analysis with GETPIVOTDATA.mp424.99MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/008 Std Dev.mp424.78MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/008 Difference From.mp424.2MB

10 CONDITIONAL FORMATTING PIVOT TABLES/006 Data Bars, Color Scales Icon Sets NEW IN EXCEL 2010.mp424.18MB

01 CUSTOMIZING YOUR PIVOT TABLE/030 OPTIONS SHOW Expand Collapse buttons.mp423.94MB

01 CUSTOMIZING YOUR PIVOT TABLE/023 DESIGN STYLES Customising a Pivot Table Style.mp423.18MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/017 CASE STUDY FINANCIAL Actual v Plan Variance Report.mp423.1MB

07 SLICERS NEW IN EXCEL 2010/003 Creating a custom style.mp422.9MB

07 SLICERS NEW IN EXCEL 2010/013 CASE STUDY FINANCIAL Base, Best Worst case Forecast.mp422.65MB

01 CUSTOMIZING YOUR PIVOT TABLE/022 DESIGN STYLES Pivot Table Styles.mp422.5MB

10 CONDITIONAL FORMATTING PIVOT TABLES/014 Show text in the Pivot Table Values area.mp422.3MB

14 BONUS VIDEOS/002 Consolidate with a Pivot Table.mp422.14MB

11 GETPIVOTDATA Formula/001 Intro to GETPIVOTDATA.mp422.06MB

07 SLICERS NEW IN EXCEL 2010/005 Slicer Settings.mp421.98MB

01 CUSTOMIZING YOUR PIVOT TABLE/016 OPTIONS DATA Refresh External Data.mp421.4MB

08 CALCULATED FIELDS ITEMS/011 TIP Solve Order for Calculated Items.mp421.37MB

14 BONUS VIDEOS/001 Sales Forecasting with Calculated Fields.mp421.27MB

04 GROUPING/011 TIP Group by fiscal years quarters.mp420.95MB

07 SLICERS NEW IN EXCEL 2010/012 CASE STUDY ACCOUNTING Select a Monthly PL report with a Slicer.mp420.95MB

09 PIVOT CHARTS/004 Pivot Chart Layouts.mp420.35MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/012 TIP See all pivot Items.mp420.2MB

04 GROUPING/017 CASE STUDY FINANCIAL Min Max Bank Balance.mp420.14MB

09 PIVOT CHARTS/005 Pivot Chart Formats.mp420.07MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/009 Difference From.mp420.05MB

01 CUSTOMIZING YOUR PIVOT TABLE/008 CREATING A PIVOT TABLE Field List Areas.mp419.24MB

01 CUSTOMIZING YOUR PIVOT TABLE/020 OPTIONS ACTIONS Select format.mp419.1MB

01 CUSTOMIZING YOUR PIVOT TABLE/018 OPTIONS DATA Change Data Source.mp419.1MB

12 MACROS PIVOT TABLES/004 Different pivot table views macro.mp419.08MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/004 Of.mp418.49MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/009 Varp.mp418.3MB

08 CALCULATED FIELDS ITEMS/005 Creating a Calculated Item.mp417.67MB

12 MACROS PIVOT TABLES/002 Record a simple macro to Refresh a pivot table.mp417.51MB

08 CALCULATED FIELDS ITEMS/001 Creating a Calculated Field.mp417.09MB

10 CONDITIONAL FORMATTING PIVOT TABLES/005 Top Bottom Rules.mp417.07MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/003 Average.mp416.86MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/007 of Parent Total NEW IN EXCEL 2010.mp416.57MB

01 CUSTOMIZING YOUR PIVOT TABLE/004 ARRANGING YOUR DATA SET Tables.mp415.78MB

10 CONDITIONAL FORMATTING PIVOT TABLES/017 CASE STUDY FINANCIAL Conditionally Format your sales results.mp415.55MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/014 Index.mp415.34MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/002 Count.mp415.08MB

12 MACROS PIVOT TABLES/003 Date filter macro.mp415.07MB

09 PIVOT CHARTS/003 Pivot Chart Designs.mp415.04MB

04 GROUPING/001 Group by Date.mp414.65MB

06 FILTERING/008 Filter by Report Filter.mp414.18MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/013 TIP Show a unique count.mp414.09MB

08 CALCULATED FIELDS ITEMS/004 Excel formulas Calculated Fields.mp413.99MB

01 CUSTOMIZING YOUR PIVOT TABLE/027 DESIGN LAYOUT Report Layouts.mp413.9MB

04 GROUPING/004 Group by Sales ranges.mp413.89MB

07 SLICERS NEW IN EXCEL 2010/001 Insert a Slicer.mp413.79MB

08 CALCULATED FIELDS ITEMS/007 Editing a Calculated Item.mp413.79MB

07 SLICERS NEW IN EXCEL 2010/007 Slicer Connections for multiple pivot tables.mp413.76MB

10 CONDITIONAL FORMATTING PIVOT TABLES/001 Intro to Conditional Formatting.mp413.75MB

11 GETPIVOTDATA Formula/006 TIP Grand Totals to the left of the pivot table.mp413.42MB

08 CALCULATED FIELDS ITEMS/002 Use an existing Calculated Field in a new calculation.mp412.79MB

08 CALCULATED FIELDS ITEMS/003 Editing a Calculated Field.mp412.77MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/010 TIP Show various Grand Totals.mp412.76MB

01 CUSTOMIZING YOUR PIVOT TABLE/046 LAYOUT FORMAT TIPShow report filter on multiple pages.mp412.74MB

11 GETPIVOTDATA Formula/004 Data validation with GETPIVOTDATA.mp412.68MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/001 of Grand Total.mp412.48MB

06 FILTERING/011 TIP Filter by Text wildcards and .mp412.39MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/006 Product.mp412.25MB

13 DATA MANAGEMENT/002 Reducing file memory by deleting the data source.mp412.23MB

09 PIVOT CHARTS/001 Insert a Pivot Chart.mp412.12MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/006 of Parent Column Total NEW IN EXCEL 2010.mp411.88MB

04 GROUPING/012 TIP Errors when grouping by dates.mp411.7MB

01 CUSTOMIZING YOUR PIVOT TABLE/031 OPTIONS SHOW Move Remove Fields and Items.mp411.67MB

05 SORTING/004 Sort using a Custom List.mp411.65MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/011 Running Total in NEW IN EXCEL 2010.mp411.61MB

01 CUSTOMIZING YOUR PIVOT TABLE/017 OPTIONS DATA Import from Access database.mp411.57MB

12 MACROS PIVOT TABLES/005 Top 10 macro.mp411.4MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/002 of Column Total.mp411.31MB

08 CALCULATED FIELDS ITEMS/009 Calculated Item on Column Labels.mp411.2MB

01 CUSTOMIZING YOUR PIVOT TABLE/009 CREATING A PIVOT TABLE Drill down to audit.mp411.11MB

06 FILTERING/003 Filter by Labels - Numerical Text.mp411.11MB

11 GETPIVOTDATA Formula/003 Reference Dates with GETPIVOTDATA.mp411.04MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/011 TIP Shortcuts to Field Value Field Settings.mp411.01MB

09 PIVOT CHARTS/019 TIP Workaround to creating an interactive Scatter graph.mp410.73MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/016 CASE STUDY ACCOUNTING of Revenue Margins.mp410.65MB

07 SLICERS NEW IN EXCEL 2010/006 Slicer Size Properties.mp410.64MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/004 Maximum.mp410.62MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/010 Running Total in.mp410.53MB

04 GROUPING/010 TIP Grouping by a custom date.mp410.49MB

10 CONDITIONAL FORMATTING PIVOT TABLES/013 Control Conditional Formatting with Slicers.mp410.47MB

13 DATA MANAGEMENT/004 Reducing file memory by keeping data source in MS Access.mp410.37MB

09 PIVOT CHARTS/017 TIP Charts Dos Donts.mp410.14MB

07 SLICERS NEW IN EXCEL 2010/002 Slicer Styles.mp410.05MB

14 BONUS VIDEOS/003 Frequency distribution with a Pivot Table.mp410.02MB

06 FILTERING/019 CASE STUDY FINANCIAL Top 25 of Channel Partners.mp49.96MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/013 Rank Largest to Smallest NEW IN EXCEL 2010.mp49.91MB

01 CUSTOMIZING YOUR PIVOT TABLE/005 ARRANGING YOUR DATA SET TIP Clean Your Data Set.mp49.9MB

01 CUSTOMIZING YOUR PIVOT TABLE/015 OPTIONS DATA Refresh All.mp49.84MB

08 CALCULATED FIELDS ITEMS/008 Excel formulas Calculated Items.mp49.76MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/003 of Row Total.mp49.75MB

06 FILTERING/002 Filter by Labels - Text.mp49.73MB

01 CUSTOMIZING YOUR PIVOT TABLE/036 CUSTOMISATION Field name formatting.mp49.57MB

06 FILTERING/018 CASE STUDY ACCOUNTING Top 5 Expenses report.mp49.47MB

10 CONDITIONAL FORMATTING PIVOT TABLES/010 TIP Use a formula to determine which cells to format.mp49.45MB

14 BONUS VIDEOS/004 Break Even Model.mp49.42MB

13 DATA MANAGEMENT/001 Reducing file memory by copying existing pivot table.mp48.75MB

10 CONDITIONAL FORMATTING PIVOT TABLES/011 Use selected cells to format multiple fields.mp48.73MB

10 CONDITIONAL FORMATTING PIVOT TABLES/008 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp48.6MB

13 DATA MANAGEMENT/006 Sharing a Pivot Table via OneDrive.mp48.57MB

08 CALCULATED FIELDS ITEMS/006 Use an existing Calculated Item in a new calculation.mp48.57MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/012 Rank Smallest to Largest NEW IN EXCEL 2010.mp48.38MB

08 CALCULATED FIELDS ITEMS/010 Shortcomings of Calculated Items.mp48.34MB

04 GROUPING/002 Group by Months.mp48.32MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 Create multiple subtotals.mp48.29MB

09 PIVOT CHARTS/006 Limitations of Pivot Charts workarounds.mp48.2MB

06 FILTERING/005 Filter by Values - Top or Bottom 10 Items.mp48.12MB

06 FILTERING/015 TIP Include new items in manual filter.mp48.08MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/007 Count Numbers.mp48.07MB

04 GROUPING/009 TIP Group by a Date that starts on a Monday.mp47.73MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/005 Minimum.mp47.68MB

06 FILTERING/006 Filter by Values - Top or Bottom .mp47.65MB

10 CONDITIONAL FORMATTING PIVOT TABLES/012 All cells showing values to format multiple fields.mp47.58MB

01 CUSTOMIZING YOUR PIVOT TABLE/035 CUSTOMISATION Number formatting.mp47.49MB

01 CUSTOMIZING YOUR PIVOT TABLE/024 DESIGN STYLES Use a customised style in another workbook.mp47.44MB

09 PIVOT CHARTS/002 Insert a Slicer with a Pivot Chart.mp47.42MB

06 FILTERING/013 TIP Apply multiple filters.mp47.4MB

05 SORTING/003 Sort manually drag, write, right click.mp47.35MB

04 GROUPING/013 TIP Group two pivot tables independently.mp47.34MB

10 CONDITIONAL FORMATTING PIVOT TABLES/007 TIP Format only cells that contain - For Bonuses.mp47.3MB

04 GROUPING/003 Group by Quarters Years.mp47.22MB

05 SORTING/001 Sorting by Largest or Smallest.mp47.14MB

12 MACROS PIVOT TABLES/006 Add macro to quick access toolbar.mp47.14MB

06 FILTERING/009 TIP Shortcuts to filters.mp47.1MB

01 CUSTOMIZING YOUR PIVOT TABLE/042 LAYOUT FORMAT Format empty cells.mp47MB

07 SLICERS NEW IN EXCEL 2010/010 TIP Lock the workbook but not the slicer.mp46.92MB

07 SLICERS NEW IN EXCEL 2010/004 Copy a custom style into a new workbook.mp46.89MB

14 BONUS VIDEOS/005 Several Slicer custom styles for you to use.mp46.87MB

04 GROUPING/006 Group by Time.mp46.74MB

01 CUSTOMIZING YOUR PIVOT TABLE/003 ARRANGING YOUR DATA SET Formatting.mp46.72MB

04 GROUPING/005 Group by Text fields.mp46.71MB

06 FILTERING/007 Filter by Values - Top or Bottom Sum.mp46.63MB

07 SLICERS NEW IN EXCEL 2010/009 TIP Use one slicer for two pivot tables.mp46.58MB

01 CUSTOMIZING YOUR PIVOT TABLE/007 CREATING A PIVOT TABLE Field List - Activate, move, resize layout.mp46.56MB

14 BONUS VIDEOS/008 Reconciling customer payments.mp46.45MB

10 CONDITIONAL FORMATTING PIVOT TABLES/002 Highlight Cell Rules based on values.mp46.45MB

09 PIVOT CHARTS/007 Saving a Pivot Chart template.mp46.41MB

06 FILTERING/016 TIP Clear filters with one click.mp46.37MB

04 GROUPING/015 TIP Display dates that have no data.mp46.36MB

05 SORTING/002 Sort an Item Row Left to Right.mp46.27MB

13 DATA MANAGEMENT/003 Reducing file memory by saving file as Excel Binary Workbook.mp46.27MB

01 CUSTOMIZING YOUR PIVOT TABLE/045 LAYOUT FORMAT TIP Printing a pivot table on two pages.mp46.14MB

11 GETPIVOTDATA Formula/005 Shortfalls of GETPIVOTDATA.mp46.03MB

01 CUSTOMIZING YOUR PIVOT TABLE/040 LAYOUT FORMAT Change the layout of a report filter.mp46.02MB

10 CONDITIONAL FORMATTING PIVOT TABLES/009 TIP Format values that are above or below the average - For Promotions.mp45.91MB

09 PIVOT CHARTS/015 TIP Printing a Pivot Chart.mp45.89MB

09 PIVOT CHARTS/014 TIP Paste Pivot Chart to PowerPoint make live updates.mp45.88MB

05 SORTING/006 Sort row from A-Z and sales from Z-A.mp45.84MB

01 CUSTOMIZING YOUR PIVOT TABLE/029 DESIGN LAYOUT TIP Show the Classic Pivot Table Layout.mp45.79MB

01 CUSTOMIZING YOUR PIVOT TABLE/039 LAYOUT FORMAT Indent rows in compact layout.mp45.77MB

04 GROUPING/007 TIP Shortcuts to Grouping.mp45.75MB

10 CONDITIONAL FORMATTING PIVOT TABLES/004 Highlight Cell Rules based on date labels.mp45.74MB

10 CONDITIONAL FORMATTING PIVOT TABLES/015 Cond Format blank cells or cells.mp45.65MB

09 PIVOT CHARTS/008 TIP Shortcuts to formatting a Pivot Chart.mp45.65MB

01 CUSTOMIZING YOUR PIVOT TABLE/037 CUSTOMISATION TIP Predetermined number formatting.mp45.59MB

09 PIVOT CHARTS/016 TIP Include a Sparkline with your pivot table.mp45.54MB

06 FILTERING/004 Filter by Values.mp45.52MB

01 CUSTOMIZING YOUR PIVOT TABLE/034 CUSTOMISATION Change Count of to Sum of.mp45.48MB

04 GROUPING/008 TIP Grouping by Half Years.mp45.46MB

01 CUSTOMIZING YOUR PIVOT TABLE/014 OPTIONS DATA Refresh.mp45.07MB

06 FILTERING/014 TIP Filter by multiple values.mp44.98MB

05 SORTING/005 Override a Custom List sort.mp44.97MB

08 CALCULATED FIELDS ITEMS/012 TIP List Calculated Field Item formulas.mp44.88MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/015 TIP Shortcuts to Show Values As.mp44.84MB

01 CUSTOMIZING YOUR PIVOT TABLE/019 OPTIONS ACTIONS Clear Filters Clear Pivot.mp44.82MB

01 CUSTOMIZING YOUR PIVOT TABLE/026 DESIGN LAYOUT Grand Totals.mp44.81MB

05 SORTING/007 TIP Sort new items added to your data source.mp44.71MB

01 CUSTOMIZING YOUR PIVOT TABLE/043 LAYOUT FORMAT Keep column widths upon refresh.mp44.66MB

09 PIVOT CHARTS/012 TIP Insert Pivot Chart straight from the data source.mp44.58MB

07 SLICERS NEW IN EXCEL 2010/008 TIP Different ways to filter a Slicer.mp44.57MB

08 CALCULATED FIELDS ITEMS/014 TIP Order of operations.mp44.52MB

10 CONDITIONAL FORMATTING PIVOT TABLES/003 Highlight Cell Rules based on text labels.mp44.41MB

01 CUSTOMIZING YOUR PIVOT TABLE/013 OPTIONS DATA Pivot Cache explained.mp44.38MB

06 FILTERING/012 TIP Filter by multiple fields.mp44.37MB

13 DATA MANAGEMENT/005 Compatibility Issues with Excel 2007 and Excel 2010.mp44.27MB

01 CUSTOMIZING YOUR PIVOT TABLE/021 OPTIONS ACTIONS Move a Pivot Table.mp44.23MB

01 CUSTOMIZING YOUR PIVOT TABLE/025 DESIGN LAYOUT Subtotals.mp44.19MB

01 CUSTOMIZING YOUR PIVOT TABLE/044 LAYOUT FORMAT TIP Automatic Refresh a Pivot Table.mp44.18MB

08 CALCULATED FIELDS ITEMS/013 TIP Remove a Calculated Field temporarily.mp43.94MB

09 PIVOT CHARTS/009 TIP Link chart title to a pivot cell.mp43.88MB

12 MACROS PIVOT TABLES/001 Adding the Developer tab disabling macros.mp43.78MB

06 FILTERING/010 TIP Keep or hide selected items.mp43.77MB

09 PIVOT CHARTS/010 TIP Copying a second chart.mp43.56MB

09 PIVOT CHARTS/013 TIP Paste Pivot Chart to your email as a picture.mp43.52MB

01 CUSTOMIZING YOUR PIVOT TABLE/011 CREATING A PIVOT TABLE TIP Double click on any labels to show more Fields.mp43.49MB

01 CUSTOMIZING YOUR PIVOT TABLE/041 LAYOUT FORMAT Format error values.mp43.45MB

01 CUSTOMIZING YOUR PIVOT TABLE/012 CREATING A PIVOT TABLE TIP Defer Layout Update.mp43.43MB

01 CUSTOMIZING YOUR PIVOT TABLE/038 CUSTOMISATION TIP Change Sum views in Label areas.mp43.11MB

06 FILTERING/017 TIP Add a filter for the column items.mp43.03MB

01 CUSTOMIZING YOUR PIVOT TABLE/006 CREATING A PIVOT TABLE Inserting a Pivot Table.mp43MB

01 CUSTOMIZING YOUR PIVOT TABLE/010 CREATING A PIVOT TABLE Sort Field List from A to Z.mp42.93MB

01 CUSTOMIZING YOUR PIVOT TABLE/028 DESIGN LAYOUT Blank Rows.mp42.81MB

04 GROUPING/014 TIP Fixing the problem of counting grouped sales.mp42.7MB

05 SORTING/008 TIP Clear a sort.mp42.7MB

09 PIVOT CHARTS/011 TIP Put a chart on a separate page with F11.mp42.53MB

00 None/000 INTRODUCTION.mp42.31MB

05 SORTING/009 TIP Sort Largest to Smallest Grand Totals.mp42.24MB

01 CUSTOMIZING YOUR PIVOT TABLE/001 ARRANGING YOUR DATA SET Tabular Format.mp41.92MB

01 CUSTOMIZING YOUR PIVOT TABLE/033 OPTIONS SHOW ShowHide Field Headers.mp41.74MB

01 CUSTOMIZING YOUR PIVOT TABLE/032 OPTIONS SHOW ShowHide Field List.mp41.68MB

14 BONUS VIDEOS/009 THANK YOU.mp41.63MB

01 CUSTOMIZING YOUR PIVOT TABLE/002 ARRANGING YOUR DATA SET No Gaps.mp41.11MB

11 GETPIVOTDATA Formula/002 Create a custom report with GETPIVOTDATA.mp41.08MB

03 VALUE FIELD SETTINGS SHOW VALUES AS/005 of Parent Row Total NEW IN EXCEL 2010.mp4590.57KB