Details for this torrent 

Lynda - Excel 2016: Pivot Tables in Depth
Type:
Other > Other
Files:
113
Size:
568.62 MiB (596238658 Bytes)
Tag(s):
Business
Uploaded:
2016-01-20 07:25:14 GMT
By:
2boweb VIP
Seeders:
1
Leechers:
0
Comments
2  

Info Hash:
9CC7194D592D0C6B1F67B4F3E16607D9F04201D2




(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel 2016: Pivot Tables in Depth

This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive.

3h 42m Intermediate Jan 13, 2016  | Uploaded in Jan 20, 2016 by 2boweb

Subject: Business 
Software: Excel Office Office 365 
Author:  Curt Frye 

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.
Topics include:
	•	Formatting data for use in a PivotTable
	•	Creating a new PivotTable
	•	Connecting to data sources
	•	Consolidating data from multiple data sources
	•	Creating calculated fields
	•	Summarizing field data
	•	Sorting and filtering PivotTables
	•	Working with Excel slicers
	•	Formatting PivotTables with styles and formats
	•	Applying conditional formats
	•	Creating PivotCharts
	•	Printing PivotTables
	•	Running macros
	•	Creating a PivotTable using the data model


////////////////////////////////////////////////////////////////////

048 Printing each item on its own page.mp416.57 MiB
052 Creating a simple PivotTable presentation kit.mp415.62 MiB
051 Running an Excel macro.mp415.46 MiB
028 Creating a PivotTable style.mp415.4 MiB
035 Formatting cells using icon sets.mp415.35 MiB
031 Highlighting cells by applying a rule.mp415.22 MiB
034 Formatting cells using color scales.mp415.06 MiB
024 Formatting slicers.mp414.19 MiB
032 Highlighting the top or bottom values in a PivotTable.mp414.04 MiB
011 Managing PivotTables.mp413.84 MiB
029 Changing the PivotTable layout.mp413.71 MiB
004 Formatting data for use in a PivotTable.mp413.31 MiB
033 Formatting cells using data bars.mp413.28 MiB
027 Applying a PivotTable style.mp412.13 MiB
054 Creating relationships between tables.mp412.04 MiB
050 Recording and reviewing an Excel macro.mp411.75 MiB
013 Changing the data field summary operation.mp411.63 MiB
021 Filtering a PivotTable by rule.mp411.57 MiB
008 Configuring a PivotTable.mp411.42 MiB
012 Managing subtotals and grand totals.mp411.36 MiB
010 Consolidating data from multiple sources.mp411.01 MiB
015 Creating a calculated field.mp410.71 MiB
025 Filtering with report filter fields.mp410.57 MiB
014 Summarizing more than one data field.mp410.36 MiB
003 Introducing PivotTables.mp410.01 MiB
005 Creating a PivotTable.mp49.87 MiB
016 Using PivotTable data in a formula.mp49.86 MiB
020 Filtering a PivotTable field by selection.mp49.82 MiB
023 Filtering a PivotTable using slicers.mp49.77 MiB
042 Formatting a PivotChart.mp49.72 MiB
017 Drilling down to the underlying data.mp49.69 MiB
019 Creating a custom sort order.mp49.65 MiB
056 Editing table relationships.mp49.5 MiB
045 Adding a trendline to a PivotChart.mp49.41 MiB
007 Pivoting a PivotTable.mp49.41 MiB
039 Creating a PivotChart.mp49.37 MiB
030 Changing the data field number format.mp48.98 MiB
018 Sorting PivotTable data.mp48.96 MiB
036 Editing a conditional formatting rule.mp48.83 MiB
053 Working with PivotTables using keyboard shortcuts.mp48.45 MiB
037 Controlling how multiple rules are applied.mp48.39 MiB
055 Creating a PivotTable using the data model.mp48.13 MiB
040 Pivoting a PivotChart.mp47.96 MiB
047 Setting PivotTable print options.mp47.93 MiB
043 Changing a PivotCharts layout.mp47.82 MiB
022 Filtering a PivotTable using a search filter.mp46.89 MiB
001 Welcome.mp46.85 MiB
006 Creating a recommended PivotTable.mp46.37 MiB
041 Filtering a PivotChart.mp45.99 MiB
049 Printing a PivotChart.mp45.77 MiB
009 Connecting to an external data source.mp45.66 MiB
038 Deleting a conditional formatting rule.mp45.27 MiB
046 Printing a PivotTable.mp45.04 MiB
026 Clearing and reapplying PivotTable filters.mp44.68 MiB
044 Changing a PivotCharts chart type.mp44 MiB
057 Next steps.mp42.44 MiB
002 Using the exercise files.mp4996.47 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter09/EditRelationships.xlsx183.79 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter09/CreateRelated.xlsx183.78 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter09/DefineRelationships.xlsx175.72 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter08/RemoveMonth.xlsm25.66 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter07/PrintChart.xlsx25.54 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/Filtering.xlsx25.24 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/Formatting.xlsx24.77 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/Trendline.xlsx24.58 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/ChangeType.xlsx24.57 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/ChangeLayout.xlsx24.31 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/Pivoting.xlsx24.3 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/TopTen.xlsx21.31 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter08/Presentation.xlsx21.22 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter08/Keyboard.xlsx21.22 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter08/RecordMacro.xlsx21.18 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter07/PrintItems.xlsx21.17 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/EditConds.xlsx20.97 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/ColorScales.xlsx20.96 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter04/ApplyStyle.xlsx20.91 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter04/DataFormat.xlsx20.72 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/ConditionalRules.xlsx20.71 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/DataBars.xlsx20.69 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter04/CreateStyle.xlsx20.62 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter04/PTLayout.xlsx20.6 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter07/SetOptions.xlsx20.56 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter07/Printing.xlsx20.56 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/ReportFilter.xlsx20.56 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/FormatSlicer.xlsx20.38 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/Slicers.xlsx20.38 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/SearchFilter.xlsx20.38 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/Selection.xlsx20.27 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/DeleteConds.xlsx19.72 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/Multiple.xlsx19.71 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/Clearing.xlsx19.5 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter05/IconSets.xlsx19.42 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/Sorting.xlsx19.32 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/Calculated.xlsx19.18 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/MoreThanOne.xlsx19.18 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/FilterByRule.xlsx19.11 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter03/CustomOrder.xlsx18.93 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/GetPivotData.xlsx18.65 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Managing.xlsx18.49 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/Summary.xlsx18.34 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Configure.xlsx17.97 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/Grouping.xlsx17.96 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/SubAndGrand.xlsx17.96 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Introducing.xlsx17.45 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter02/DrillDown.xlsx17.37 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Pivoting.xlsx16.97 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter06/CreatePTChart.xlsx13.94 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Recommended.xlsx12.45 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/OutsideSource.xlsx12.45 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/CreatePivot.xlsx12.45 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/DataPrep.xlsx11.78 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/Consolidating.xlsx10.49 KiB
Ex_Files_Pivot_Tables_In_Depth/Exercise Files/Chapter01/External.xlsx7.49 KiB

Comments