Lynda Excel 2016 Pivot Tables in Depth | BA68872E4B53294D0A2857E27820FA547AB9BDD4

Lynda Excel 2016 Pivot Tables in Depth

Name	Lynda - Excel 2016 Pivot Tables in Depth	DOWNLOAD Copy Link
Total Size	596.2 MB
Total Files	113
Hash	BA68872E4B53294D0A2857E27820FA547AB9BDD4

/
048 Printing each item on its own page.mp4	17.4 MB
052 Creating a simple PivotTable presentation kit.mp4	16.4 MB
051 Running an Excel macro.mp4	16.2 MB
028 Creating a PivotTable style.mp4	16.2 MB
035 Formatting cells using icon sets.mp4	16.1 MB
031 Highlighting cells by applying a rule.mp4	16.0 MB
034 Formatting cells using color scales.mp4	15.8 MB
024 Formatting slicers.mp4	14.9 MB
032 Highlighting the top or bottom values in a PivotTable.mp4	14.7 MB
011 Managing PivotTables.mp4	14.5 MB
029 Changing the PivotTable layout.mp4	14.4 MB
004 Formatting data for use in a PivotTable.mp4	14.0 MB
033 Formatting cells using data bars.mp4	13.9 MB
027 Applying a PivotTable style.mp4	12.7 MB
054 Creating relationships between tables.mp4	12.6 MB
050 Recording and reviewing an Excel macro.mp4	12.3 MB
013 Changing the data field summary operation.mp4	12.2 MB
021 Filtering a PivotTable by rule.mp4	12.1 MB
008 Configuring a PivotTable.mp4	12.0 MB
012 Managing subtotals and grand totals.mp4	11.9 MB
010 Consolidating data from multiple sources.mp4	11.5 MB
015 Creating a calculated field.mp4	11.2 MB
025 Filtering with report filter fields.mp4	11.1 MB
014 Summarizing more than one data field.mp4	10.9 MB
003 Introducing PivotTables.mp4	10.5 MB
005 Creating a PivotTable.mp4	10.4 MB
016 Using PivotTable data in a formula.mp4	10.3 MB
020 Filtering a PivotTable field by selection.mp4	10.3 MB
023 Filtering a PivotTable using slicers.mp4	10.2 MB
042 Formatting a PivotChart.mp4	10.2 MB
017 Drilling down to the underlying data.mp4	10.2 MB
019 Creating a custom sort order.mp4	10.1 MB
056 Editing table relationships.mp4	10.0 MB
045 Adding a trendline to a PivotChart.mp4	9.9 MB
007 Pivoting a PivotTable.mp4	9.9 MB
039 Creating a PivotChart.mp4	9.8 MB
030 Changing the data field number format.mp4	9.4 MB
018 Sorting PivotTable data.mp4	9.4 MB
036 Editing a conditional formatting rule.mp4	9.3 MB
053 Working with PivotTables using keyboard shortcuts.mp4	8.9 MB
037 Controlling how multiple rules are applied.mp4	8.8 MB
055 Creating a PivotTable using the data model.mp4	8.5 MB
040 Pivoting a PivotChart.mp4	8.4 MB
047 Setting PivotTable print options.mp4	8.3 MB
043 Changing a PivotCharts layout.mp4	8.2 MB
022 Filtering a PivotTable using a search filter.mp4	7.2 MB
001 Welcome.mp4	7.2 MB
006 Creating a recommended PivotTable.mp4	6.7 MB
041 Filtering a PivotChart.mp4	6.3 MB
049 Printing a PivotChart.mp4	6.0 MB
009 Connecting to an external data source.mp4	5.9 MB
038 Deleting a conditional formatting rule.mp4	5.5 MB
046 Printing a PivotTable.mp4	5.3 MB
026 Clearing and reapplying PivotTable filters.mp4	4.9 MB
044 Changing a PivotCharts chart type.mp4	4.2 MB
057 Next steps.mp4	2.6 MB
002 Using the exercise files.mp4	1.0 MB
/Exercise Files/Chapter09/
EditRelationships.xlsx	188.2 KB
CreateRelated.xlsx	188.2 KB
DefineRelationships.xlsx	179.9 KB
/Exercise Files/Chapter08/
RemoveMonth.xlsm	26.3 KB
Presentation.xlsx	21.7 KB
Keyboard.xlsx	21.7 KB
RecordMacro.xlsx	21.7 KB
/Exercise Files/Chapter07/
PrintChart.xlsx	26.2 KB
PrintItems.xlsx	21.7 KB
SetOptions.xlsx	21.1 KB
Printing.xlsx	21.1 KB
/Exercise Files/Chapter06/
Filtering.xlsx	25.8 KB
Formatting.xlsx	25.4 KB
Trendline.xlsx	25.2 KB
ChangeType.xlsx	25.2 KB
ChangeLayout.xlsx	24.9 KB
Pivoting.xlsx	24.9 KB
CreatePTChart.xlsx	14.3 KB
/Exercise Files/Chapter05/
TopTen.xlsx	21.8 KB
EditConds.xlsx	21.5 KB
ColorScales.xlsx	21.5 KB
ConditionalRules.xlsx	21.2 KB
DataBars.xlsx	21.2 KB
DeleteConds.xlsx	20.2 KB
Multiple.xlsx	20.2 KB
IconSets.xlsx	19.9 KB
/Exercise Files/Chapter04/
ApplyStyle.xlsx	21.4 KB
DataFormat.xlsx	21.2 KB
CreateStyle.xlsx	21.1 KB
PTLayout.xlsx	21.1 KB
/Exercise Files/Chapter03/
ReportFilter.xlsx	21.1 KB
FormatSlicer.xlsx	20.9 KB
Slicers.xlsx	20.9 KB
SearchFilter.xlsx	20.9 KB
Selection.xlsx	20.8 KB
Clearing.xlsx	20.0 KB
Sorting.xlsx	19.8 KB
FilterByRule.xlsx	19.6 KB
CustomOrder.xlsx	19.4 KB
/Exercise Files/Chapter02/
Calculated.xlsx	19.6 KB
MoreThanOne.xlsx	19.6 KB
GetPivotData.xlsx	19.1 KB
Summary.xlsx	18.8 KB
Grouping.xlsx	18.4 KB
SubAndGrand.xlsx	18.4 KB
DrillDown.xlsx	17.8 KB
/Exercise Files/Chapter01/
Managing.xlsx	18.9 KB
Configure.xlsx	18.4 KB
Introducing.xlsx	17.9 KB
Pivoting.xlsx	17.4 KB
Recommended.xlsx	12.8 KB
OutsideSource.xlsx	12.7 KB
CreatePivot.xlsx	12.7 KB
DataPrep.xlsx	12.1 KB
Consolidating.xlsx	10.7 KB
External.xlsx	7.7 KB
Total files 113