Microsoft Excel with Excel Pivot Tables Bootcamp | 92A415CE6ACDB8964698FD41B594D8C2396E824C

Microsoft Excel with Excel Pivot Tables Bootcamp

Name	Microsoft Excel - Excel with Excel Pivot Tables Bootcamp!	DOWNLOAD Copy Link
Total Size	3.4 GB
Total Files	758
Last Seen	2025-02-12 23:21
Hash	92A415CE6ACDB8964698FD41B594D8C2396E824C

/.../13 DATA MANAGEMENT/
226 CHAPTER-13.zip	114.0 MB
226 WORKBOOKS.html	0.9 KB
227 Reducing file memory by copying existing pivot table-en.srt	1.5 KB
227 Reducing file memory by copying existing pivot table-it.srt	1.6 KB
227 Reducing file memory by copying existing pivot table.mp4	9.2 MB
228 Reducing file memory by deleting the data source-en.srt	1.9 KB
228 Reducing file memory by deleting the data source-it.srt	2.1 KB
228 Reducing file memory by deleting the data source.mp4	12.8 MB
229 Reducing file memory by saving file as Excel Binary Workbook-en.srt	0.9 KB
229 Reducing file memory by saving file as Excel Binary Workbook-it.srt	0.9 KB
229 Reducing file memory by saving file as Excel Binary Workbook.mp4	6.6 MB
230 Reducing file memory by keeping data source in MS Access-en.srt	2.6 KB
230 Reducing file memory by keeping data source in MS Access-it.srt	2.7 KB
230 Reducing file memory by keeping data source in MS Access.mp4	10.9 MB
231 Compatibility Issues with Excel 2007 and Excel E0-en.srt	1.4 KB
231 Compatibility Issues with Excel 2007 and Excel E0-it.srt	1.4 KB
231 Compatibility Issues with Excel 2007 and Excel E0.mp4	4.5 MB
232 Sharing a Pivot Table via OneDrive-en.srt	3.1 KB
232 Sharing a Pivot Table via OneDrive-it.srt	3.2 KB
232 Sharing a Pivot Table via OneDrive.mp4	9.0 MB
/
Visit Coursedrive.org.url	0.1 KB
ReadMe.txt	0.2 KB
/Microsoft Excel - Excel with Excel Pivot Tables Bootcamp!/
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
/.../01 CUSTOMIZING YOUR EXCEL PIVOT TABLE/
010 CHAPTER-1.zip	2.6 MB
010 WORKBOOKS.html	0.9 KB
011 ARRANGING YOUR DATA SET ~ Tabular Format-en.srt	2.8 KB
011 ARRANGING YOUR DATA SET ~ Tabular Format-it.srt	2.9 KB
011 ARRANGING YOUR DATA SET ~ Tabular Format.mp4	16.5 MB
012 ARRANGING YOUR DATA SET ~ No Gaps-en.srt	2.9 KB
012 ARRANGING YOUR DATA SET ~ No Gaps-it.srt	3.0 KB
012 ARRANGING YOUR DATA SET ~ No Gaps.mp4	16.5 MB
013 ARRANGING YOUR DATA SET ~ Formatting-en.srt	1.7 KB
013 ARRANGING YOUR DATA SET ~ Formatting-it.srt	1.8 KB
013 ARRANGING YOUR DATA SET ~ Formatting.mp4	7.0 MB
014 ARRANGING YOUR DATA SET ~ Tables-en.srt	3.2 KB
014 ARRANGING YOUR DATA SET ~ Tables-it.srt	3.4 KB
014 ARRANGING YOUR DATA SET ~ Tables.mp4	16.5 MB
015 ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set-en.srt	2.8 KB
015 ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set-it.srt	2.9 KB
015 ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set.mp4	10.4 MB
016 CREATING A PIVOT TABLE ~ Inserting a Pivot Table-en.srt	4.1 KB
016 CREATING A PIVOT TABLE ~ Inserting a Pivot Table-it.srt	4.3 KB
016 CREATING A PIVOT TABLE ~ Inserting a Pivot Table.mp4	14.5 MB
017 CREATING A PIVOT TABLE ~ Field List - Activate move resize layout-en.srt	1.9 KB
017 CREATING A PIVOT TABLE ~ Field List - Activate move resize layout-it.srt	2.0 KB
017 CREATING A PIVOT TABLE ~ Field List - Activate move resize layout.mp4	6.9 MB
018 CREATING A PIVOT TABLE ~ Field List Areas-en.srt	6.1 KB
018 CREATING A PIVOT TABLE ~ Field List Areas-it.srt	6.3 KB
018 CREATING A PIVOT TABLE ~ Field List Areas.mp4	20.2 MB
019 CREATING A PIVOT TABLE ~ Drill down to audit-en.srt	1.7 KB
019 CREATING A PIVOT TABLE ~ Drill down to audit-it.srt	1.8 KB
019 CREATING A PIVOT TABLE ~ Drill down to audit.mp4	11.7 MB
020 CREATING A PIVOT TABLE ~ Sort Field List from A to Z-en.srt	0.6 KB
020 CREATING A PIVOT TABLE ~ Sort Field List from A to Z-it.srt	0.6 KB
020 CREATING A PIVOT TABLE ~ Sort Field List from A to Z.mp4	3.1 MB
021 CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields-en.srt	0.9 KB
021 CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields-it.srt	1.0 KB
021 CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields.mp4	3.7 MB
022 CREATING A PIVOT TABLE ~ TIP Defer Layout Update-en.srt	1.0 KB
022 CREATING A PIVOT TABLE ~ TIP Defer Layout Update-it.srt	1.0 KB
022 CREATING A PIVOT TABLE ~ TIP Defer Layout Update.mp4	3.6 MB
023 OPTIONS DATA ~ Pivot Cache explained-en.srt	1.0 KB
023 OPTIONS DATA ~ Pivot Cache explained-it.srt	1.1 KB
023 OPTIONS DATA ~ Pivot Cache explained.mp4	4.6 MB
024 OPTIONS DATA ~ Refresh-en.srt	1.3 KB
024 OPTIONS DATA ~ Refresh-it.srt	1.3 KB
024 OPTIONS DATA ~ Refresh.mp4	5.3 MB
025 OPTIONS DATA ~ Refresh All-en.srt	2.3 KB
025 OPTIONS DATA ~ Refresh All-it.srt	2.4 KB
025 OPTIONS DATA ~ Refresh All.mp4	10.3 MB
026 OPTIONS DATA ~ Refresh External Data-en.srt	6.0 KB
026 OPTIONS DATA ~ Refresh External Data-it.srt	6.0 KB
026 OPTIONS DATA ~ Refresh External Data.mp4	22.4 MB
027 OPTIONS DATA ~ Import from Access database-en.srt	2.4 KB
027 OPTIONS DATA ~ Import from Access database-it.srt	2.5 KB
027 OPTIONS DATA ~ Import from Access database.mp4	12.1 MB
028 OPTIONS DATA ~ Change Data Source-en.srt	3.3 KB
028 OPTIONS DATA ~ Change Data Source-it.srt	3.5 KB
028 OPTIONS DATA ~ Change Data Source.mp4	20.0 MB
029 OPTIONS ACTIONS ~ Clear Filters Clear Pivot-en.srt	0.9 KB
029 OPTIONS ACTIONS ~ Clear Filters Clear Pivot-it.srt	1.0 KB
029 OPTIONS ACTIONS ~ Clear Filters Clear Pivot.mp4	5.1 MB
030 OPTIONS ACTIONS ~ Select format-en.srt	3.0 KB
030 OPTIONS ACTIONS ~ Select format-it.srt	3.2 KB
030 OPTIONS ACTIONS ~ Select format.mp4	20.0 MB
031 OPTIONS ACTIONS ~ Move a Pivot Table-en.srt	0.9 KB
031 OPTIONS ACTIONS ~ Move a Pivot Table-it.srt	1.0 KB
031 OPTIONS ACTIONS ~ Move a Pivot Table.mp4	4.4 MB
032 DESIGN STYLES ~ Pivot Table Styles-en.srt	3.7 KB
032 DESIGN STYLES ~ Pivot Table Styles-it.srt	3.9 KB
032 DESIGN STYLES ~ Pivot Table Styles.mp4	23.6 MB
033 DESIGN STYLES ~ Customising a Pivot Table Style-en.srt	4.4 KB
033 DESIGN STYLES ~ Customising a Pivot Table Style-it.srt	4.5 KB
033 DESIGN STYLES ~ Customising a Pivot Table Style.mp4	24.3 MB
034 DESIGN STYLES ~ Use a customised style in another workbook-en.srt	1.4 KB
034 DESIGN STYLES ~ Use a customised style in another workbook-it.srt	1.6 KB
034 DESIGN STYLES ~ Use a customised style in another workbook.mp4	7.8 MB
035 DESIGN LAYOUT ~ Subtotals-en.srt	0.8 KB
035 DESIGN LAYOUT ~ Subtotals-it.srt	0.8 KB
035 DESIGN LAYOUT ~ Subtotals.mp4	4.4 MB
036 DESIGN LAYOUT ~ Grand Totals-en.srt	0.8 KB
036 DESIGN LAYOUT ~ Grand Totals-it.srt	0.9 KB
036 DESIGN LAYOUT ~ Grand Totals.mp4	5.0 MB
037 DESIGN LAYOUT ~ Report Layouts-en.srt	2.6 KB
037 DESIGN LAYOUT ~ Report Layouts-it.srt	2.8 KB
037 DESIGN LAYOUT ~ Report Layouts.mp4	14.6 MB
038 DESIGN LAYOUT ~ Blank Rows-en.srt	0.6 KB
038 DESIGN LAYOUT ~ Blank Rows-it.srt	0.6 KB
038 DESIGN LAYOUT ~ Blank Rows.mp4	2.9 MB
039 DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout-en.srt	1.1 KB
039 DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout-it.srt	1.2 KB
039 DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout.mp4	6.1 MB
040 OPTIONS SHOW ~ Expand Collapse buttons-en.srt	4.9 KB
040 OPTIONS SHOW ~ Expand Collapse buttons-it.srt	5.3 KB
040 OPTIONS SHOW ~ Expand Collapse buttons.mp4	25.1 MB
041 OPTIONS SHOW ~ Move Remove Fields and Items-en.srt	2.9 KB
041 OPTIONS SHOW ~ Move Remove Fields and Items-it.srt	3.1 KB
041 OPTIONS SHOW ~ Move Remove Fields and Items.mp4	12.2 MB
042 OPTIONS SHOW ~ ShowHide Field List-en.srt	0.3 KB
042 OPTIONS SHOW ~ ShowHide Field List-it.srt	0.3 KB
042 OPTIONS SHOW ~ ShowHide Field List.mp4	1.8 MB
043 OPTIONS SHOW ~ ShowHide Field Headers-en.srt	0.4 KB
043 OPTIONS SHOW ~ ShowHide Field Headers-it.srt	0.3 KB
043 OPTIONS SHOW ~ ShowHide Field Headers.mp4	1.8 MB
044 CUSTOMISATION ~ Change Count of to Sum of-en.srt	1.3 KB
044 CUSTOMISATION ~ Change Count of to Sum of-it.srt	1.3 KB
044 CUSTOMISATION ~ Change Count of to Sum of.mp4	5.8 MB
045 CUSTOMISATION ~ Number formatting-en.srt	1.8 KB
045 CUSTOMISATION ~ Number formatting-it.srt	1.9 KB
045 CUSTOMISATION ~ Number formatting.mp4	7.9 MB
046 CUSTOMISATION ~ Field name formatting-en.srt	2.6 KB
046 CUSTOMISATION ~ Field name formatting-it.srt	2.7 KB
046 CUSTOMISATION ~ Field name formatting.mp4	10.0 MB
047 CUSTOMISATION ~ TIP Predetermined number formatting-en.srt	1.3 KB
047 CUSTOMISATION ~ TIP Predetermined number formatting-it.srt	1.4 KB
047 CUSTOMISATION ~ TIP Predetermined number formatting.mp4	5.9 MB
048 CUSTOMISATION ~ TIP Change Sum views in Label areas-en.srt	0.9 KB
048 CUSTOMISATION ~ TIP Change Sum views in Label areas-it.srt	0.9 KB
048 CUSTOMISATION ~ TIP Change Sum views in Label areas.mp4	3.3 MB
049 LAYOUT FORMAT ~ Indent rows in compact layout-en.srt	0.8 KB
049 LAYOUT FORMAT ~ Indent rows in compact layout-it.srt	0.9 KB
049 LAYOUT FORMAT ~ Indent rows in compact layout.mp4	6.1 MB
050 LAYOUT FORMAT ~ Change the layout of a report filter-en.srt	1.4 KB
050 LAYOUT FORMAT ~ Change the layout of a report filter-it.srt	1.5 KB
050 LAYOUT FORMAT ~ Change the layout of a report filter.mp4	6.3 MB
051 LAYOUT FORMAT ~ Format error values-en.srt	0.8 KB
051 LAYOUT FORMAT ~ Format error values-it.srt	0.8 KB
051 LAYOUT FORMAT ~ Format error values.mp4	3.6 MB
052 LAYOUT FORMAT ~ Format empty cells-en.srt	1.3 KB
052 LAYOUT FORMAT ~ Format empty cells-it.srt	1.4 KB
052 LAYOUT FORMAT ~ Format empty cells.mp4	7.3 MB
053 LAYOUT FORMAT ~ Keep column widths upon refresh-en.srt	0.9 KB
053 LAYOUT FORMAT ~ Keep column widths upon refresh-it.srt	0.9 KB
053 LAYOUT FORMAT ~ Keep column widths upon refresh.mp4	4.9 MB
054 LAYOUT FORMAT ~ TIP Automatic Refresh a Pivot Table-en.srt	0.9 KB
054 LAYOUT FORMAT ~ TIP Automatic Refresh a Pivot Table-it.srt	0.9 KB
054 LAYOUT FORMAT ~ TIP Automatic Refresh a Pivot Table.mp4	4.4 MB
055 LAYOUT FORMAT ~ TIP Printing a pivot table on two pages-en.srt	1.3 KB
055 LAYOUT FORMAT ~ TIP Printing a pivot table on two pages-it.srt	1.4 KB
055 LAYOUT FORMAT ~ TIP Printing a pivot table on two pages.mp4	6.4 MB
056 LAYOUT FORMAT ~ TIPShow report filter on multiple pages-en.srt	2.6 KB
056 LAYOUT FORMAT ~ TIPShow report filter on multiple pages-it.srt	2.7 KB
056 LAYOUT FORMAT ~ TIPShow report filter on multiple pages.mp4	13.4 MB
057 Course Review-en.srt	0.9 KB
057 Course Review-it.srt	0.9 KB
057 Course Review.mp4	3.3 MB
/.../02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/
058 CHAPTER-2.zip	927.1 KB
058 WORKBOOKS.html	0.9 KB
059 Create multiple subtotals-en.srt	1.7 KB
059 Create multiple subtotals-it.srt	1.8 KB
059 Create multiple subtotals.mp4	8.7 MB
060 Count-en.srt	2.7 KB
060 Count-it.srt	2.8 KB
060 Count.mp4	15.8 MB
061 Average-en.srt	2.6 KB
061 Average-it.srt	2.8 KB
061 Average.mp4	17.7 MB
062 Maximum-en.srt	2.1 KB
062 Maximum-it.srt	2.1 KB
062 Maximum.mp4	11.1 MB
063 Minimum-en.srt	1.3 KB
063 Minimum-it.srt	1.4 KB
063 Minimum.mp4	8.1 MB
064 Product-en.srt	3.8 KB
064 Product-it.srt	3.9 KB
064 Product.mp4	12.8 MB
065 Count Numbers-en.srt	2.1 KB
065 Count Numbers-it.srt	2.2 KB
065 Count Numbers.mp4	8.5 MB
066 Std Dev-en.srt	8.2 KB
066 Std Dev-it.srt	8.7 KB
066 Std Dev.mp4	26.0 MB
067 Varp-en.srt	3.4 KB
067 Varp-it.srt	3.6 KB
067 Varp.mp4	19.2 MB
068 TIP Show various Grand Totals-en.srt	2.7 KB
068 TIP Show various Grand Totals-it.srt	2.9 KB
068 TIP Show various Grand Totals.mp4	13.4 MB
069 TIP Shortcuts to Field Value Field Settings-en.srt	2.5 KB
069 TIP Shortcuts to Field Value Field Settings-it.srt	2.8 KB
069 TIP Shortcuts to Field Value Field Settings.mp4	11.5 MB
070 TIP See all pivot Items-en.srt	6.1 KB
070 TIP See all pivot Items-it.srt	6.7 KB
070 TIP See all pivot Items.mp4	21.2 MB
071 TIP Show a unique count-en.srt	3.0 KB
071 TIP Show a unique count-it.srt	3.1 KB
071 TIP Show a unique count.mp4	14.8 MB
/.../03 VALUE FIELD SETTINGS SHOW VALUES AS/
072 CHAPTER-3.zip	857.1 KB
072 WORKBOOKS.html	0.9 KB
073 of Grand Total-en.srt	1.8 KB
073 of Grand Total-it.srt	2.0 KB
073 of Grand Total.mp4	13.1 MB
074 of Column Total-en.srt	2.0 KB
074 of Column Total-it.srt	2.1 KB
074 of Column Total.mp4	11.9 MB
075 of Row Total-en.srt	1.6 KB
075 of Row Total-it.srt	1.7 KB
075 of Row Total.mp4	11.7 MB
076 Of-en.srt	3.9 KB
076 Of-it.srt	4.2 KB
076 Of.mp4	19.4 MB
077 of Parent Row Total (NEW IN EXCEL E0)-en.srt	3.2 KB
077 of Parent Row Total (NEW IN EXCEL E0)-it.srt	3.4 KB
077 of Parent Row Total (NEW IN EXCEL E0).mp4	22.9 MB
078 of Parent Column Total (NEW IN EXCEL E0)-en.srt	2.3 KB
078 of Parent Column Total (NEW IN EXCEL E0)-it.srt	2.5 KB
078 of Parent Column Total (NEW IN EXCEL E0).mp4	12.5 MB
079 of Parent Total (NEW IN EXCEL E0)-en.srt	2.8 KB
079 of Parent Total (NEW IN EXCEL E0)-it.srt	3.0 KB
079 of Parent Total (NEW IN EXCEL E0).mp4	17.4 MB
080 Difference From-en.srt	4.6 KB
080 Difference From-it.srt	4.8 KB
080 Difference From.mp4	25.4 MB
081 Difference From-en.srt	4.4 KB
081 Difference From-it.srt	4.6 KB
081 Difference From.mp4	21.0 MB
082 Running Total in-en.srt	2.2 KB
082 Running Total in-it.srt	2.2 KB
082 Running Total in.mp4	11.0 MB
083 Running Total in (NEW IN EXCEL E0)-en.srt	2.9 KB
083 Running Total in (NEW IN EXCEL E0)-it.srt	3.0 KB
083 Running Total in (NEW IN EXCEL E0).mp4	12.2 MB
084 Rank Smallest to Largest (NEW IN EXCEL E0)-en.srt	2.2 KB
084 Rank Smallest to Largest (NEW IN EXCEL E0)-it.srt	2.3 KB
084 Rank Smallest to Largest (NEW IN EXCEL E0).mp4	8.8 MB
085 Rank Largest to Smallest (NEW IN EXCEL E0)-en.srt	2.3 KB
085 Rank Largest to Smallest (NEW IN EXCEL E0)-it.srt	2.5 KB
085 Rank Largest to Smallest (NEW IN EXCEL E0).mp4	10.4 MB
086 Index-en.srt	3.6 KB
086 Index-it.srt	3.9 KB
086 Index.mp4	16.1 MB
087 TIP Shortcuts to Show Values As-en.srt	1.1 KB
087 TIP Shortcuts to Show Values As-it.srt	1.2 KB
087 TIP Shortcuts to Show Values As.mp4	5.1 MB
088 CASE STUDY ~ ACCOUNTING of Revenue Margins-en.srt	2.8 KB
088 CASE STUDY ~ ACCOUNTING of Revenue Margins-it.srt	3.0 KB
088 CASE STUDY ~ ACCOUNTING of Revenue Margins.mp4	11.2 MB
089 CASE STUDY ~ FINANCIAL Actual v Plan Variance Report-en.srt	5.9 KB
089 CASE STUDY ~ FINANCIAL Actual v Plan Variance Report-it.srt	6.1 KB
089 CASE STUDY ~ FINANCIAL Actual v Plan Variance Report.mp4	24.2 MB
/04 GROUPING/
090 CHAPTER-4.zip	1.0 MB
090 WORKBOOKS.html	0.9 KB
091 Group by Date-en.srt	3.0 KB
091 Group by Date-it.srt	3.2 KB
091 Group by Date.mp4	15.4 MB
092 Group by Months-en.srt	2.0 KB
092 Group by Months-it.srt	2.1 KB
092 Group by Months.mp4	8.7 MB
093 Group by Quarters Years-en.srt	1.9 KB
093 Group by Quarters Years-it.srt	2.0 KB
093 Group by Quarters Years.mp4	7.6 MB
094 Group by Sales ranges-en.srt	3.5 KB
094 Group by Sales ranges-it.srt	3.7 KB
094 Group by Sales ranges.mp4	14.6 MB
095 Group by Text fields-en.srt	2.2 KB
095 Group by Text fields-it.srt	2.4 KB
095 Group by Text fields.mp4	7.0 MB
096 Group by Time-en.srt	1.7 KB
096 Group by Time-it.srt	1.9 KB
096 Group by Time.mp4	7.1 MB
097 TIP Shortcuts to Grouping-en.srt	1.5 KB
097 TIP Shortcuts to Grouping-it.srt	1.8 KB
097 TIP Shortcuts to Grouping.mp4	6.0 MB
098 TIP Grouping by Half Years-en.srt	1.8 KB
098 TIP Grouping by Half Years-it.srt	1.9 KB
098 TIP Grouping by Half Years.mp4	5.7 MB
099 TIP Group by a Date that starts on a Monday-en.srt	2.2 KB
099 TIP Group by a Date that starts on a Monday-it.srt	2.3 KB
099 TIP Group by a Date that starts on a Monday.mp4	8.1 MB
100 TIP Grouping by a custom date-en.srt	1.9 KB
100 TIP Grouping by a custom date-it.srt	2.0 KB
100 TIP Grouping by a custom date.mp4	11.0 MB
101 TIP Group by fiscal years quarters-en.srt	6.6 KB
101 TIP Group by fiscal years quarters-it.srt	6.9 KB
101 TIP Group by fiscal years quarters.mp4	22.0 MB
102 TIP Errors when grouping by dates-en.srt	3.3 KB
102 TIP Errors when grouping by dates-it.srt	3.5 KB
102 TIP Errors when grouping by dates.mp4	12.3 MB
103 TIP Group two pivot tables independently-en.srt	4.1 KB
103 TIP Group two pivot tables independently-it.srt	4.2 KB
103 TIP Group two pivot tables independently.mp4	21.7 MB
104 TIP Fixing the problem of counting grouped sales-en.srt	0.7 KB
104 TIP Fixing the problem of counting grouped sales-it.srt	0.8 KB
104 TIP Fixing the problem of counting grouped sales.mp4	2.8 MB
105 TIP Display dates that have no data-en.srt	1.0 KB
105 TIP Display dates that have no data-it.srt	1.0 KB
105 TIP Display dates that have no data.mp4	6.7 MB
106 CASE STUDY ~ ACCOUNTING Quarterly Comparative Report-en.srt	7.9 KB
106 CASE STUDY ~ ACCOUNTING Quarterly Comparative Report-it.srt	8.4 KB
106 CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.mp4	39.5 MB
107 CASE STUDY ~ FINANCIAL Min Max Bank Balance-en.srt	5.3 KB
107 CASE STUDY ~ FINANCIAL Min Max Bank Balance-it.srt	5.4 KB
107 CASE STUDY ~ FINANCIAL Min Max Bank Balance.mp4	21.1 MB
/05 SORTING/
108 CHAPTER-5.zip	476.4 KB
108 WORKBOOKS.html	0.9 KB
109 Sorting by Largest or Smallest-en.srt	1.9 KB
109 Sorting by Largest or Smallest-it.srt	2.0 KB
109 Sorting by Largest or Smallest.mp4	7.5 MB
110 Sort an Item Row (Left to Right)-en.srt	1.3 KB
110 Sort an Item Row (Left to Right)-it.srt	1.3 KB
110 Sort an Item Row (Left to Right).mp4	6.6 MB
111 Sort manually (drag write right click)-en.srt	2.1 KB
111 Sort manually (drag write right click)-it.srt	2.2 KB
111 Sort manually (drag write right click).mp4	7.7 MB
112 Sort using a Custom List-en.srt	3.6 KB
112 Sort using a Custom List-it.srt	4.0 KB
112 Sort using a Custom List.mp4	12.2 MB
113 Override a Custom List sort-en.srt	1.6 KB
113 Override a Custom List sort-it.srt	1.7 KB
113 Override a Custom List sort.mp4	5.2 MB
114 Sort row from A-Z and sales from Z-A-en.srt	1.0 KB
114 Sort row from A-Z and sales from Z-A-it.srt	1.1 KB
114 Sort row from A-Z and sales from Z-A.mp4	6.1 MB
115 TIP Sort new items added to your data source-en.srt	1.4 KB
115 TIP Sort new items added to your data source-it.srt	1.5 KB
115 TIP Sort new items added to your data source.mp4	4.9 MB
116 TIP Clear a sort-en.srt	0.4 KB
116 TIP Clear a sort-it.srt	0.4 KB
116 TIP Clear a sort.mp4	2.8 MB
117 TIP Sort Largest to Smallest Grand Totals-en.srt	0.2 KB
117 TIP Sort Largest to Smallest Grand Totals-it.srt	0.2 KB
117 TIP Sort Largest to Smallest Grand Totals.mp4	2.3 MB
/06 FILTERING/
118 CHAPTER-6.zip	1.2 MB
118 WORKBOOKS.html	0.9 KB
119 Filter by Dates-en.srt	7.7 KB
119 Filter by Dates-it.srt	7.9 KB
119 Filter by Dates.mp4	26.3 MB
120 Filter by Labels - Text-en.srt	2.8 KB
120 Filter by Labels - Text-it.srt	2.9 KB
120 Filter by Labels - Text.mp4	10.2 MB
121 Filter by Labels - Numerical Text-en.srt	3.0 KB
121 Filter by Labels - Numerical Text-it.srt	3.0 KB
121 Filter by Labels - Numerical Text.mp4	11.7 MB
122 Filter by Values-en.srt	4.7 KB
122 Filter by Values-it.srt	4.7 KB
122 Filter by Values.mp4	15.9 MB
123 Filter by Values - Top or Bottom 10 Items-en.srt	2.4 KB
123 Filter by Values - Top or Bottom 10 Items-it.srt	2.5 KB
123 Filter by Values - Top or Bottom 10 Items.mp4	8.5 MB
124 Filter by Values - Top or Bottom-en.srt	2.0 KB
124 Filter by Values - Top or Bottom-it.srt	2.0 KB
124 Filter by Values - Top or Bottom.mp4	8.0 MB
125 Filter by Values - Top or Bottom Sum-en.srt	1.6 KB
125 Filter by Values - Top or Bottom Sum-it.srt	1.8 KB
125 Filter by Values - Top or Bottom Sum.mp4	7.0 MB
126 Filter by Report Filter-en.srt	3.9 KB
126 Filter by Report Filter-it.srt	4.2 KB
126 Filter by Report Filter.mp4	14.9 MB
127 TIP Shortcuts to filters-en.srt	1.7 KB
127 TIP Shortcuts to filters-it.srt	1.9 KB
127 TIP Shortcuts to filters.mp4	7.4 MB
128 TIP Keep or hide selected items-en.srt	0.8 KB
128 TIP Keep or hide selected items-it.srt	0.9 KB
128 TIP Keep or hide selected items.mp4	4.0 MB
129 TIP Filter by Text wildcards and-en.srt	3.4 KB
129 TIP Filter by Text wildcards and-it.srt	3.6 KB
129 TIP Filter by Text wildcards and.mp4	13.0 MB
130 TIP Filter by multiple fields-en.srt	1.2 KB
130 TIP Filter by multiple fields-it.srt	1.2 KB
130 TIP Filter by multiple fields.mp4	4.6 MB
131 TIP Apply multiple filters-en.srt	1.9 KB
131 TIP Apply multiple filters-it.srt	2.0 KB
131 TIP Apply multiple filters.mp4	7.8 MB
132 TIP Filter by multiple values-en.srt	1.2 KB
132 TIP Filter by multiple values-it.srt	1.2 KB
132 TIP Filter by multiple values.mp4	5.2 MB
133 TIP Include new items in manual filter-en.srt	2.2 KB
133 TIP Include new items in manual filter-it.srt	2.3 KB
133 TIP Include new items in manual filter.mp4	8.5 MB
134 TIP Clear filters with one click-en.srt	2.0 KB
134 TIP Clear filters with one click-it.srt	2.1 KB
134 TIP Clear filters with one click.mp4	6.7 MB
135 TIP Add a filter for the column items-en.srt	0.6 KB
135 TIP Add a filter for the column items-it.srt	0.6 KB
135 TIP Add a filter for the column items.mp4	3.2 MB
136 CASE STUDY ~ ACCOUNTING Top 5 Expenses report-en.srt	2.6 KB
136 CASE STUDY ~ ACCOUNTING Top 5 Expenses report-it.srt	2.7 KB
136 CASE STUDY ~ ACCOUNTING Top 5 Expenses report.mp4	9.9 MB
137 CASE STUDY ~ FINANCIAL Top 25 of Channel Partners-en.srt	2.7 KB
137 CASE STUDY ~ FINANCIAL Top 25 of Channel Partners-it.srt	2.8 KB
137 CASE STUDY ~ FINANCIAL Top 25 of Channel Partners.mp4	10.4 MB
/.../07 SLICERS (NEW IN EXCEL E0)/
138 CHAPTER-7.zip	1.0 MB
138 WORKBOOKS.html	0.9 KB
139 Insert a Slicer-en.srt	4.6 KB
139 Insert a Slicer-it.srt	4.8 KB
139 Insert a Slicer.mp4	14.5 MB
140 Slicer Styles-en.srt	2.6 KB
140 Slicer Styles-it.srt	2.7 KB
140 Slicer Styles.mp4	10.5 MB
141 Creating a custom style-en.srt	6.4 KB
141 Creating a custom style-it.srt	6.6 KB
141 Creating a custom style.mp4	24.0 MB
142 Copy a custom style into a new workbook-en.srt	1.6 KB
142 Copy a custom style into a new workbook-it.srt	1.7 KB
142 Copy a custom style into a new workbook.mp4	7.2 MB
143 Slicer Settings-en.srt	5.8 KB
143 Slicer Settings-it.srt	6.2 KB
143 Slicer Settings.mp4	23.1 MB
144 Slicer Size Properties-en.srt	3.0 KB
144 Slicer Size Properties-it.srt	3.2 KB
144 Slicer Size Properties.mp4	11.2 MB
145 Slicer Connections for multiple pivot tables-en.srt	3.8 KB
145 Slicer Connections for multiple pivot tables-it.srt	4.0 KB
145 Slicer Connections for multiple pivot tables.mp4	14.4 MB
146 TIP Different ways to filter a Slicer-en.srt	1.3 KB
146 TIP Different ways to filter a Slicer-it.srt	1.4 KB
146 TIP Different ways to filter a Slicer.mp4	4.8 MB
147 TIP Use one slicer for two pivot tables-en.srt	1.4 KB
147 TIP Use one slicer for two pivot tables-it.srt	1.5 KB
147 TIP Use one slicer for two pivot tables.mp4	6.9 MB
148 TIP Lock the workbook but not the slicer-en.srt	1.6 KB
148 TIP Lock the workbook but not the slicer-it.srt	1.7 KB
148 TIP Lock the workbook but not the slicer.mp4	7.3 MB
149 TIP Interactive employee photos with Slicers FUN-en.srt	10.5 KB
149 TIP Interactive employee photos with Slicers FUN-it.srt	11.2 KB
149 TIP Interactive employee photos with Slicers FUN.mp4	32.6 MB
150 CASE STUDY ~ ACCOUNTING Select a Monthly PL report with a Slicer-en.srt	4.7 KB
150 CASE STUDY ~ ACCOUNTING Select a Monthly PL report with a Slicer-it.srt	4.8 KB
150 CASE STUDY ~ ACCOUNTING Select a Monthly PL report with a Slicer.mp4	22.0 MB
151 CASE STUDY ~ FINANCIAL Base Best Worst case Forecast-en.srt	5.8 KB
151 CASE STUDY ~ FINANCIAL Base Best Worst case Forecast-it.srt	6.1 KB
151 CASE STUDY ~ FINANCIAL Base Best Worst case Forecast.mp4	23.7 MB
152 Course Review-en.srt	0.9 KB
152 Course Review-it.srt	0.9 KB
152 Course Review.mp4	3.3 MB
/.../08 CALCULATED FIELDS ITEMS/
153 CHAPTER-8.zip	1.0 MB
153 WORKBOOKS.html	0.9 KB
154 Creating a Calculated Field-en.srt	4.5 KB
154 Creating a Calculated Field-it.srt	4.8 KB
154 Creating a Calculated Field.mp4	17.9 MB
155 Use an existing Calculated Field in a new calculation-en.srt	2.8 KB
155 Use an existing Calculated Field in a new calculation-it.srt	3.0 KB
155 Use an existing Calculated Field in a new calculation.mp4	13.4 MB
156 Editing a Calculated Field-en.srt	2.3 KB
156 Editing a Calculated Field-it.srt	2.3 KB
156 Editing a Calculated Field.mp4	13.4 MB
157 Excel formulas Calculated Fields-en.srt	3.2 KB
157 Excel formulas Calculated Fields-it.srt	3.3 KB
157 Excel formulas Calculated Fields.mp4	14.7 MB
158 Creating a Calculated Item-en.srt	4.5 KB
158 Creating a Calculated Item-it.srt	4.6 KB
158 Creating a Calculated Item.mp4	18.5 MB
159 Use an existing Calculated Item in a new calculation-en.srt	1.5 KB
159 Use an existing Calculated Item in a new calculation-it.srt	1.5 KB
159 Use an existing Calculated Item in a new calculation.mp4	9.0 MB
160 Editing a Calculated Item-en.srt	2.6 KB
160 Editing a Calculated Item-it.srt	2.8 KB
160 Editing a Calculated Item.mp4	14.5 MB
161 Excel formulas Calculated Items-en.srt	1.5 KB
161 Excel formulas Calculated Items-it.srt	1.6 KB
161 Excel formulas Calculated Items.mp4	10.2 MB
162 Calculated Item on Column Labels-en.srt	2.3 KB
162 Calculated Item on Column Labels-it.srt	2.5 KB
162 Calculated Item on Column Labels.mp4	11.7 MB
163 Shortcomings of Calculated Items-en.srt	2.1 KB
163 Shortcomings of Calculated Items-it.srt	2.3 KB
163 Shortcomings of Calculated Items.mp4	8.8 MB
164 TIP Solve Order for Calculated Items-en.srt	4.0 KB
164 TIP Solve Order for Calculated Items-it.srt	4.2 KB
164 TIP Solve Order for Calculated Items.mp4	22.4 MB
165 TIP List Calculated Field Item formulas-en.srt	1.3 KB
165 TIP List Calculated Field Item formulas-it.srt	1.3 KB
165 TIP List Calculated Field Item formulas.mp4	5.1 MB
166 TIP Remove a Calculated Field temporarily-en.srt	0.9 KB
166 TIP Remove a Calculated Field temporarily-it.srt	0.9 KB
166 TIP Remove a Calculated Field temporarily.mp4	4.1 MB
167 TIP Order of operations-en.srt	2.2 KB
167 TIP Order of operations-it.srt	2.3 KB
167 TIP Order of operations.mp4	4.7 MB
168 CASE STUDY ~ ACCOUNTING Creating a PL Pivot Table Report-en.srt	10.1 KB
168 CASE STUDY ~ ACCOUNTING Creating a PL Pivot Table Report-it.srt	10.6 KB
168 CASE STUDY ~ ACCOUNTING Creating a PL Pivot Table Report.mp4	61.4 MB
169 CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields-en.srt	7.5 KB
169 CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields-it.srt	7.9 KB
169 CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.mp4	53.5 MB
/.../09 PIVOT CHARTS/
170 CHAPTER-9.zip	1.7 MB
170 WORKBOOKS.html	0.9 KB
171 Insert a Pivot Chart-en.srt	3.7 KB
171 Insert a Pivot Chart-it.srt	4.2 KB
171 Insert a Pivot Chart.mp4	12.7 MB
172 Insert a Slicer with a Pivot Chart-en.srt	1.9 KB
172 Insert a Slicer with a Pivot Chart-it.srt	2.1 KB
172 Insert a Slicer with a Pivot Chart.mp4	7.8 MB
173 Pivot Chart Designs-en.srt	4.0 KB
173 Pivot Chart Designs-it.srt	4.1 KB
173 Pivot Chart Designs.mp4	15.8 MB
174 Pivot Chart Layouts-en.srt	4.0 KB
174 Pivot Chart Layouts-it.srt	4.3 KB
174 Pivot Chart Layouts.mp4	21.3 MB
175 Pivot Chart Formats-en.srt	6.9 KB
175 Pivot Chart Formats-it.srt	7.2 KB
175 Pivot Chart Formats.mp4	21.0 MB
176 Limitations of Pivot Charts workarounds-en.srt	2.1 KB
176 Limitations of Pivot Charts workarounds-it.srt	2.3 KB
176 Limitations of Pivot Charts workarounds.mp4	8.6 MB
177 Saving a Pivot Chart template-en.srt	1.7 KB
177 Saving a Pivot Chart template-it.srt	1.8 KB
177 Saving a Pivot Chart template.mp4	6.7 MB
178 TIP Shortcuts to formatting a Pivot Chart-en.srt	1.5 KB
178 TIP Shortcuts to formatting a Pivot Chart-it.srt	1.5 KB
178 TIP Shortcuts to formatting a Pivot Chart.mp4	5.9 MB
179 TIP Link chart title to a pivot cell-en.srt	1.1 KB
179 TIP Link chart title to a pivot cell-it.srt	1.1 KB
179 TIP Link chart title to a pivot cell.mp4	4.1 MB
180 TIP Copying a second chart-en.srt	0.7 KB
180 TIP Copying a second chart-it.srt	0.8 KB
180 TIP Copying a second chart.mp4	3.7 MB
181 TIP Put a chart on a separate page with F11-en.srt	0.6 KB
181 TIP Put a chart on a separate page with F11-it.srt	0.6 KB
181 TIP Put a chart on a separate page with F11.mp4	2.6 MB
182 TIP Insert Pivot Chart straight from the data source-en.srt	0.8 KB
182 TIP Insert Pivot Chart straight from the data source-it.srt	0.9 KB
182 TIP Insert Pivot Chart straight from the data source.mp4	4.8 MB
183 TIP Paste Pivot Chart to your email as a picture-en.srt	1.2 KB
183 TIP Paste Pivot Chart to your email as a picture-it.srt	1.2 KB
183 TIP Paste Pivot Chart to your email as a picture.mp4	3.7 MB
184 TIP Paste Pivot Chart to PowerPoint make live updates-en.srt	1.6 KB
184 TIP Paste Pivot Chart to PowerPoint make live updates-it.srt	1.8 KB
184 TIP Paste Pivot Chart to PowerPoint make live updates.mp4	6.2 MB
185 TIP Printing a Pivot Chart-en.srt	1.6 KB
185 TIP Printing a Pivot Chart-it.srt	1.6 KB
185 TIP Printing a Pivot Chart.mp4	6.2 MB
186 TIP Include a Sparkline with your pivot table-en.srt	1.3 KB
186 TIP Include a Sparkline with your pivot table-it.srt	1.4 KB
186 TIP Include a Sparkline with your pivot table.mp4	5.8 MB
187 TIP Charts Do s Donts-en.srt	3.0 KB
187 TIP Charts Do s Donts-it.srt	3.3 KB
187 TIP Charts Do s Donts.mp4	10.6 MB
188 TIP Change Chart Type with Slicers FUN-en.srt	8.7 KB
188 TIP Change Chart Type with Slicers FUN-it.srt	9.4 KB
188 TIP Change Chart Type with Slicers FUN.mp4	30.2 MB
189 TIP Workaround to creating an interactive Scatter graph-en.srt	2.8 KB
189 TIP Workaround to creating an interactive Scatter graph-it.srt	3.0 KB
189 TIP Workaround to creating an interactive Scatter graph.mp4	11.2 MB
190 CASE STUDY ~ ACCOUNTING PL Pivot Table report with Graphs-en.srt	9.3 KB
190 CASE STUDY ~ ACCOUNTING PL Pivot Table report with Graphs-it.srt	9.6 KB
190 CASE STUDY ~ ACCOUNTING PL Pivot Table report with Graphs.mp4	40.4 MB
191 CASE STUDY ~ FINANCIAL Pivot Table Slicer Chart Dashboard-en.srt	18.4 KB
191 CASE STUDY ~ FINANCIAL Pivot Table Slicer Chart Dashboard-it.srt	19.2 KB
191 CASE STUDY ~ FINANCIAL Pivot Table Slicer Chart Dashboard.mp4	71.1 MB
/.../10 CONDITIONAL FORMATTING PIVOT TABLES/
192 CHAPTER-10.zip	1.2 MB
192 WORKBOOKS.html	0.9 KB
193 Intro to Conditional Formatting-en.srt	3.1 KB
193 Intro to Conditional Formatting-it.srt	3.2 KB
193 Intro to Conditional Formatting.mp4	14.4 MB
194 Highlight Cell Rules based on values-en.srt	1.6 KB
194 Highlight Cell Rules based on values-it.srt	1.6 KB
194 Highlight Cell Rules based on values.mp4	6.8 MB
195 Highlight Cell Rules based on text labels-en.srt	0.9 KB
195 Highlight Cell Rules based on text labels-it.srt	1.0 KB
195 Highlight Cell Rules based on text labels.mp4	4.6 MB
196 Highlight Cell Rules based on date labels-en.srt	1.4 KB
196 Highlight Cell Rules based on date labels-it.srt	1.5 KB
196 Highlight Cell Rules based on date labels.mp4	6.0 MB
197 Top Bottom Rules-en.srt	3.9 KB
197 Top Bottom Rules-it.srt	4.1 KB
197 Top Bottom Rules.mp4	17.9 MB
198 Data Bars Color Scales Icon Sets (NEW IN EXCEL E0)-en.srt	7.0 KB
198 Data Bars Color Scales Icon Sets (NEW IN EXCEL E0)-it.srt	7.2 KB
198 Data Bars Color Scales Icon Sets (NEW IN EXCEL E0).mp4	25.4 MB
199 TIP Format only cells that contain - For Bonuses-en.srt	1.8 KB
199 TIP Format only cells that contain - For Bonuses-it.srt	1.9 KB
199 TIP Format only cells that contain - For Bonuses.mp4	7.7 MB
200 TIP Format only Top or Bottom ranked values - Top 3 sales per year-en.srt	1.7 KB
200 TIP Format only Top or Bottom ranked values - Top 3 sales per year-it.srt	1.8 KB
200 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4	9.0 MB
201 TIP Format values that are above or below the average - For Promotions-en.srt	2.0 KB
201 TIP Format values that are above or below the average - For Promotions-it.srt	2.0 KB
201 TIP Format values that are above or below the average - For Promotions.mp4	6.2 MB
202 TIP Use a formula to determine which cells to format-en.srt	2.8 KB
202 TIP Use a formula to determine which cells to format-it.srt	3.0 KB
202 TIP Use a formula to determine which cells to format.mp4	9.9 MB
203 Use selected cells to format multiple fields-en.srt	1.7 KB
203 Use selected cells to format multiple fields-it.srt	1.9 KB
203 Use selected cells to format multiple fields.mp4	9.2 MB
204 All cells showing values to format multiple fields-en.srt	1.6 KB
204 All cells showing values to format multiple fields-it.srt	1.7 KB
204 All cells showing values to format multiple fields.mp4	7.9 MB
205 Control Conditional Formatting with Slicers-en.srt	2.7 KB
205 Control Conditional Formatting with Slicers-it.srt	2.8 KB
205 Control Conditional Formatting with Slicers.mp4	11.0 MB
206 Show text in the Pivot Table Values area-en.srt	4.3 KB
206 Show text in the Pivot Table Values area-it.srt	4.4 KB
206 Show text in the Pivot Table Values area.mp4	23.4 MB
207 Cond Format blank cells or cells-en.srt	1.3 KB
207 Cond Format blank cells or cells-it.srt	1.4 KB
207 Cond Format blank cells or cells.mp4	5.9 MB
208 CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix-en.srt	7.7 KB
208 CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix-it.srt	8.1 KB
208 CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4	28.6 MB
209 CASE STUDY ~ FINANCIAL Conditionally Format your sales results-en.srt	4.2 KB
209 CASE STUDY ~ FINANCIAL Conditionally Format your sales results-it.srt	4.3 KB
209 CASE STUDY ~ FINANCIAL Conditionally Format your sales results.mp4	16.3 MB
/.../11 GETPIVOTDATA Formula/
210 CHAPTER-11.zip	603.2 KB
210 WORKBOOKS.html	0.9 KB
211 Intro to GETPIVOTDATA-en.srt	6.1 KB
211 Intro to GETPIVOTDATA-it.srt	6.3 KB
211 Intro to GETPIVOTDATA.mp4	23.1 MB
212 Create a custom report with GETPIVOTDATA-en.srt	6.2 KB
212 Create a custom report with GETPIVOTDATA-it.srt	6.8 KB
212 Create a custom report with GETPIVOTDATA.mp4	22.9 MB
213 Reference Dates with GETPIVOTDATA-en.srt	3.7 KB
213 Reference Dates with GETPIVOTDATA-it.srt	3.8 KB
213 Reference Dates with GETPIVOTDATA.mp4	11.6 MB
214 Data validation with GETPIVOTDATA-en.srt	2.7 KB
214 Data validation with GETPIVOTDATA-it.srt	2.9 KB
214 Data validation with GETPIVOTDATA.mp4	13.3 MB
215 Shortfalls of GETPIVOTDATA-en.srt	1.8 KB
215 Shortfalls of GETPIVOTDATA-it.srt	1.9 KB
215 Shortfalls of GETPIVOTDATA.mp4	6.3 MB
216 TIP Grand Totals to the left of the pivot table-en.srt	3.3 KB
216 TIP Grand Totals to the left of the pivot table-it.srt	3.3 KB
216 TIP Grand Totals to the left of the pivot table.mp4	14.1 MB
217 CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA-en.srt	8.4 KB
217 CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA-it.srt	8.5 KB
217 CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.mp4	32.5 MB
218 CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA-en.srt	5.9 KB
218 CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA-it.srt	5.9 KB
218 CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.mp4	26.2 MB
/.../12 MACROS PIVOT TABLES/
219 CHAPTER-12.zip	534.1 KB
219 WORKBOOKS.html	0.9 KB
220 Adding the Developer tab disabling macros-en.srt	3.0 KB
220 Adding the Developer tab disabling macros-it.srt	3.0 KB
220 Adding the Developer tab disabling macros.mp4	9.5 MB
221 Record a simple macro to Refresh a pivot table-en.srt	5.3 KB
221 Record a simple macro to Refresh a pivot table-it.srt	5.7 KB
221 Record a simple macro to Refresh a pivot table.mp4	18.4 MB
222 Date filter macro-en.srt	4.5 KB
222 Date filter macro-it.srt	4.7 KB
222 Date filter macro.mp4	15.8 MB
223 Different pivot table views macro-en.srt	5.0 KB
223 Different pivot table views macro-it.srt	5.2 KB
223 Different pivot table views macro.mp4	20.0 MB
224 Top 10 macro-en.srt	3.5 KB
224 Top 10 macro-it.srt	3.7 KB
224 Top 10 macro.mp4	11.9 MB
225 Add macro to quick access toolbar-en.srt	1.5 KB
225 Add macro to quick access toolbar-it.srt	1.5 KB
225 Add macro to quick access toolbar.mp4	7.5 MB
/.../14 BONUS VIDEOS/
233 CHAPTER-14.zip	340.1 KB
233 WORKBOOKS.html	0.9 KB
234 Sales Forecasting with Calculated Fields-en.srt	4.6 KB
234 Sales Forecasting with Calculated Fields-it.srt	4.7 KB
234 Sales Forecasting with Calculated Fields.mp4	22.3 MB
235 Consolidate with a Pivot Table-en.srt	5.6 KB
235 Consolidate with a Pivot Table-it.srt	6.0 KB
235 Consolidate with a Pivot Table.mp4	23.2 MB
236 Frequency distribution with a Pivot Table-en.srt	2.4 KB
236 Frequency distribution with a Pivot Table-it.srt	2.5 KB
236 Frequency distribution with a Pivot Table.mp4	10.5 MB
237 Break Even Model-en.srt	3.2 KB
237 Break Even Model-it.srt	3.4 KB
237 Break Even Model.mp4	9.9 MB
238 Several Slicer custom styles for you to use-en.srt	2.1 KB
238 Several Slicer custom styles for you to use-it.srt	2.1 KB
238 Several Slicer custom styles for you to use.mp4	7.2 MB
239 Interactive Balance Sheet Pivot Table-en.srt	13.4 KB
239 Interactive Balance Sheet Pivot Table-it.srt	13.7 KB
239 Interactive Balance Sheet Pivot Table.mp4	50.2 MB
240 Monthly Sales Manager Performance Report-en.srt	5.6 KB
240 Monthly Sales Manager Performance Report-it.srt	5.8 KB
240 Monthly Sales Manager Performance Report.mp4	29.0 MB
241 Reconciling customer payments-en.srt	2.1 KB
241 Reconciling customer payments-it.srt	2.2 KB
241 Reconciling customer payments.mp4	6.8 MB
/.../15 NEW EXCEL E3 PIVOT TABLE FEATURES/
242 New-Excel-E3-Features.zip	7.1 MB
242 WORKBOOKS.html	0.9 KB
243 Cosmetic changes in the PivotTable Tools Ribbon Menu-en.srt	2.8 KB
243 Cosmetic changes in the PivotTable Tools Ribbon Menu-it.srt	2.9 KB
243 Cosmetic changes in the PivotTable Tools Ribbon Menu.mp4	22.6 MB
244 Recommended Pivot Tables-en.srt	2.7 KB
244 Recommended Pivot Tables-it.srt	2.8 KB
244 Recommended Pivot Tables.mp4	26.7 MB
245 Distinct Count-en.srt	1.7 KB
245 Distinct Count-it.srt	1.8 KB
245 Distinct Count.mp4	21.2 MB
246 Timelime Slicers-en.srt	5.0 KB
246 Timelime Slicers-it.srt	5.2 KB
246 Timelime Slicers.mp4	40.5 MB
247 Data Models-en.srt	7.7 KB
247 Data Models-it.srt	8.0 KB
247 Data Models.mp4	78.8 MB
/.../16 NEW EXCEL E6 PIVOT TABLE FEATURES/
248 New-Excel-E6-New-Feature.zip	285.0 KB
248 WORKBOOKS.html	0.9 KB
249 Group Periods-en.srt	2.0 KB
249 Group Periods-it.srt	2.1 KB
249 Group Periods.mp4	19.1 MB
250 Multi-Select Slicer items-en.srt	0.6 KB
250 Multi-Select Slicer items-it.srt	0.6 KB
250 Multi-Select Slicer items.mp4	4.1 MB
251 Pivot Chart - Expand and Collapse fields-en.srt	1.3 KB
251 Pivot Chart - Expand and Collapse fields-it.srt	1.4 KB
251 Pivot Chart - Expand and Collapse fields.mp4	12.2 MB
252 3D Maps-en.srt	1.9 KB
252 3D Maps-it.srt	1.9 KB
252 3D Maps.mp4	19.0 MB
/.../17 NEW EXCEL E9 OFFICE 365 PIVOT TABLE FEATURES/
253 DOWNLOADABLE WORKBOOKS.html	0.9 KB
253 ExcelE9NewFeatureWorkbooks.zip	5.0 MB
254 Which Excel version do you have-en.srt	2.2 KB
254 Which Excel version do you have-it.srt	2.2 KB
254 Which Excel version do you have.mp4	14.7 MB
255 Default Pivot Table Layout-en.srt	7.5 KB
255 Default Pivot Table Layout-it.srt	7.9 KB
255 Default Pivot Table Layout.mp4	57.4 MB
256 Automatic Relationship Detection-en.srt	7.4 KB
256 Automatic Relationship Detection-it.srt	7.7 KB
256 Automatic Relationship Detection.mp4	52.0 MB
257 Automatic Time Grouping-en.srt	3.5 KB
257 Automatic Time Grouping-it.srt	3.6 KB
257 Automatic Time Grouping.mp4	26.2 MB
258 Search in a Pivot Table-en.srt	2.0 KB
258 Search in a Pivot Table-it.srt	2.1 KB
258 Search in a Pivot Table.mp4	12.9 MB
/.../18 BONUS THE MYEXCELONLINE ACADEMY/
259 THANK YOU-en.srt	0.9 KB
259 THANK YOU-it.srt	0.9 KB
259 THANK YOU.mp4	3.3 MB
260 Academy-Course-Upgrade-COUPON.pdf	63.0 KB
260 The MyExcelOnline Academy Online Course-en.srt	1.6 KB
260 The MyExcelOnline Academy Online Course-it.srt	1.7 KB
260 The MyExcelOnline Academy Online Course.mp4	23.3 MB
external-assets-links.txt	0.1 KB
/.../001 PIVOT TABLE COURSE INTRODUCTION/
001 PIVOT TABLE COURSE INTRODUCTION-en.srt	4.4 KB
001 PIVOT TABLE COURSE INTRODUCTION-it.srt	4.4 KB
001 PIVOT TABLE COURSE INTRODUCTION.mp4	38.1 MB
002 EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ).html	1.8 KB
003 BONUS 1 COURSE TRACKER EXCEL WORKBOOK [FREE EXCEL WORKBOOK DOWNLOAD].html	1.5 KB
003 Xtreme-Pivot-Table-Course-Outline.xlsx	64.7 KB
004 BONUS 2 PIVOT TABLE CHEAT SHEET [FREE PDF DOWNLOAD].html	1.1 KB
004 Pivot-Table-Cheat-Sheet-New.pdf	2.5 MB
005 5-Speedy-Steps-to-an-Excel-Pivot-Table.pdf	5.1 MB
005 BONUS 3 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD].html	1.0 KB
006 101-Ready-Made-Excel-Templates.zip	10.7 MB
006 BONUS 4 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD].html	1.1 KB
007 BONUS 5 50 EXCEL KEYBOARD SHORTCUTS IN A KEYBOARD LAYOUT [FREE PDF DOWNLOAD].html	1.1 KB
007 Keyboard-Shortcuts-Bonus.pdf	2.1 MB
008 BONUS 6 EXCEL RESOURCE BLOG.html	1.3 KB
009 BONUS 7 MY EXCEL PODCAST SHOW.html	2.1 KB
Total files 758