Microsoft Excel - Excel with Excel Pivot Tables Bootcamp!

  13 DATA MANAGEMENT

   226 WORKBOOKS.html

   227 Reducing file memory by copying existing pivot table-it.srt

   228 Reducing file memory by deleting the data source-en.srt

   228 Reducing file memory by deleting the data source.mp4

   229 Reducing file memory by saving file as Excel Binary Workbook-it.srt

   230 Reducing file memory by keeping data source in MS Access-en.srt

   230 Reducing file memory by keeping data source in MS Access.mp4

   231 Compatibility Issues with Excel 2007 and Excel E0-it.srt

   232 Sharing a Pivot Table via OneDrive-en.srt

   232 Sharing a Pivot Table via OneDrive.mp4

  ReadMe.txt

  01 CUSTOMIZING YOUR EXCEL PIVOT TABLE

   010 WORKBOOKS.html

   011 ARRANGING YOUR DATA SET ~ Tabular Format-it.srt

   012 ARRANGING YOUR DATA SET ~ No Gaps-en.srt

   012 ARRANGING YOUR DATA SET ~ No Gaps.mp4

   013 ARRANGING YOUR DATA SET ~ Formatting-it.srt

   014 ARRANGING YOUR DATA SET ~ Tables-en.srt

   014 ARRANGING YOUR DATA SET ~ Tables.mp4

   015 ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set-it.srt

   016 CREATING A PIVOT TABLE ~ Inserting a Pivot Table-en.srt

   016 CREATING A PIVOT TABLE ~ Inserting a Pivot Table.mp4

   017 CREATING A PIVOT TABLE ~ Field List - Activate move resize layout-it.srt

   018 CREATING A PIVOT TABLE ~ Field List Areas-en.srt

   018 CREATING A PIVOT TABLE ~ Field List Areas.mp4

   019 CREATING A PIVOT TABLE ~ Drill down to audit-it.srt

   020 CREATING A PIVOT TABLE ~ Sort Field List from A to Z-en.srt

   020 CREATING A PIVOT TABLE ~ Sort Field List from A to Z.mp4

   021 CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields-it.srt

   022 CREATING A PIVOT TABLE ~ TIP Defer Layout Update-en.srt

   022 CREATING A PIVOT TABLE ~ TIP Defer Layout Update.mp4

   023 OPTIONS DATA ~ Pivot Cache explained-it.srt

   024 OPTIONS DATA ~ Refresh-en.srt

   024 OPTIONS DATA ~ Refresh.mp4

   025 OPTIONS DATA ~ Refresh All-it.srt

   026 OPTIONS DATA ~ Refresh External Data-en.srt

   026 OPTIONS DATA ~ Refresh External Data.mp4

   027 OPTIONS DATA ~ Import from Access database-it.srt

   028 OPTIONS DATA ~ Change Data Source-en.srt

   028 OPTIONS DATA ~ Change Data Source.mp4

   029 OPTIONS ACTIONS ~ Clear Filters Clear Pivot-it.srt

   030 OPTIONS ACTIONS ~ Select format-en.srt

   030 OPTIONS ACTIONS ~ Select format.mp4

   031 OPTIONS ACTIONS ~ Move a Pivot Table-it.srt

   032 DESIGN STYLES ~ Pivot Table Styles-en.srt

   032 DESIGN STYLES ~ Pivot Table Styles.mp4

   033 DESIGN STYLES ~ Customising a Pivot Table Style-it.srt

   034 DESIGN STYLES ~ Use a customised style in another workbook-en.srt

   034 DESIGN STYLES ~ Use a customised style in another workbook.mp4

   035 DESIGN LAYOUT ~ Subtotals-it.srt

   036 DESIGN LAYOUT ~ Grand Totals-en.srt

   036 DESIGN LAYOUT ~ Grand Totals.mp4

   037 DESIGN LAYOUT ~ Report Layouts-it.srt

   038 DESIGN LAYOUT ~ Blank Rows-en.srt

   038 DESIGN LAYOUT ~ Blank Rows.mp4

   039 DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout-it.srt

   040 OPTIONS SHOW ~ Expand Collapse buttons-en.srt

   040 OPTIONS SHOW ~ Expand Collapse buttons.mp4

   041 OPTIONS SHOW ~ Move Remove Fields and Items-it.srt

   042 OPTIONS SHOW ~ ShowHide Field List-en.srt

   042 OPTIONS SHOW ~ ShowHide Field List.mp4

   043 OPTIONS SHOW ~ ShowHide Field Headers-it.srt

   044 CUSTOMISATION ~ Change Count of to Sum of-en.srt

   044 CUSTOMISATION ~ Change Count of to Sum of.mp4

   045 CUSTOMISATION ~ Number formatting-it.srt

   046 CUSTOMISATION ~ Field name formatting-en.srt

   046 CUSTOMISATION ~ Field name formatting.mp4

   047 CUSTOMISATION ~ TIP Predetermined number formatting-it.srt

   048 CUSTOMISATION ~ TIP Change Sum views in Label areas-en.srt

   048 CUSTOMISATION ~ TIP Change Sum views in Label areas.mp4

   049 LAYOUT FORMAT ~ Indent rows in compact layout-it.srt

   050 LAYOUT FORMAT ~ Change the layout of a report filter-en.srt

   050 LAYOUT FORMAT ~ Change the layout of a report filter.mp4

   051 LAYOUT FORMAT ~ Format error values-it.srt

   052 LAYOUT FORMAT ~ Format empty cells-en.srt

   052 LAYOUT FORMAT ~ Format empty cells.mp4

   053 LAYOUT FORMAT ~ Keep column widths upon refresh-it.srt

   054 LAYOUT FORMAT ~ TIP Automatic Refresh a Pivot Table-en.srt

   054 LAYOUT FORMAT ~ TIP Automatic Refresh a Pivot Table.mp4

   055 LAYOUT FORMAT ~ TIP Printing a pivot table on two pages-it.srt

   056 LAYOUT FORMAT ~ TIPShow report filter on multiple pages-en.srt

   056 LAYOUT FORMAT ~ TIPShow report filter on multiple pages.mp4

   057 Course Review-it.srt

  02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY

   058 WORKBOOKS.html

   059 Create multiple subtotals-it.srt

   060 Count-en.srt

   060 Count.mp4

   061 Average-it.srt

   062 Maximum-en.srt

   062 Maximum.mp4

   063 Minimum-it.srt

   064 Product-en.srt

   064 Product.mp4

   065 Count Numbers-it.srt

   066 Std Dev-en.srt

   066 Std Dev.mp4

   067 Varp-it.srt

   068 TIP Show various Grand Totals-en.srt

   068 TIP Show various Grand Totals.mp4

   069 TIP Shortcuts to Field Value Field Settings-it.srt

   070 TIP See all pivot Items-en.srt

   070 TIP See all pivot Items.mp4

   071 TIP Show a unique count-it.srt

  03 VALUE FIELD SETTINGS SHOW VALUES AS

   072 WORKBOOKS.html

   073 of Grand Total-it.srt

   074 of Column Total-en.srt

   074 of Column Total.mp4

   075 of Row Total-it.srt

   076 Of-en.srt

   076 Of.mp4

   077 of Parent Row Total (NEW IN EXCEL E0)-it.srt

   078 of Parent Column Total (NEW IN EXCEL E0)-en.srt

   078 of Parent Column Total (NEW IN EXCEL E0).mp4

   079 of Parent Total (NEW IN EXCEL E0)-it.srt

   080 Difference From-en.srt

   080 Difference From.mp4

   081 Difference From-it.srt

   082 Running Total in-en.srt

   082 Running Total in.mp4

   083 Running Total in (NEW IN EXCEL E0)-it.srt

   084 Rank Smallest to Largest (NEW IN EXCEL E0)-en.srt

   084 Rank Smallest to Largest (NEW IN EXCEL E0).mp4

   085 Rank Largest to Smallest (NEW IN EXCEL E0)-it.srt

   086 Index-en.srt

   086 Index.mp4

   087 TIP Shortcuts to Show Values As-it.srt

   088 CASE STUDY ~ ACCOUNTING of Revenue Margins-en.srt

   088 CASE STUDY ~ ACCOUNTING of Revenue Margins.mp4

   089 CASE STUDY ~ FINANCIAL Actual v Plan Variance Report-it.srt

  04 GROUPING

   090 WORKBOOKS.html

   091 Group by Date-it.srt

   092 Group by Months-en.srt

   092 Group by Months.mp4

   093 Group by Quarters Years-it.srt

   094 Group by Sales ranges-en.srt

   094 Group by Sales ranges.mp4

   095 Group by Text fields-it.srt

   096 Group by Time-en.srt

   096 Group by Time.mp4

   097 TIP Shortcuts to Grouping-it.srt

   098 TIP Grouping by Half Years-en.srt

   098 TIP Grouping by Half Years.mp4

   099 TIP Group by a Date that starts on a Monday-it.srt

   100 TIP Grouping by a custom date-en.srt

   100 TIP Grouping by a custom date.mp4

   101 TIP Group by fiscal years quarters-it.srt

   102 TIP Errors when grouping by dates-en.srt

   102 TIP Errors when grouping by dates.mp4

   103 TIP Group two pivot tables independently-it.srt

   104 TIP Fixing the problem of counting grouped sales-en.srt

   104 TIP Fixing the problem of counting grouped sales.mp4

   105 TIP Display dates that have no data-it.srt

   106 CASE STUDY ~ ACCOUNTING Quarterly Comparative Report-en.srt

   106 CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.mp4

   107 CASE STUDY ~ FINANCIAL Min Max Bank Balance-it.srt

  05 SORTING

   108 WORKBOOKS.html

   109 Sorting by Largest or Smallest-it.srt

   110 Sort an Item Row (Left to Right)-en.srt

   110 Sort an Item Row (Left to Right).mp4

   111 Sort manually (drag write right click)-it.srt

   112 Sort using a Custom List-en.srt

   112 Sort using a Custom List.mp4

   113 Override a Custom List sort-it.srt

   114 Sort row from A-Z and sales from Z-A-en.srt

   114 Sort row from A-Z and sales from Z-A.mp4

   115 TIP Sort new items added to your data source-it.srt

   116 TIP Clear a sort-en.srt

   116 TIP Clear a sort.mp4

   117 TIP Sort Largest to Smallest Grand Totals-it.srt

  06 FILTERING

   118 WORKBOOKS.html

   119 Filter by Dates-it.srt

   120 Filter by Labels - Text-en.srt

   120 Filter by Labels - Text.mp4

   121 Filter by Labels - Numerical Text-it.srt

   122 Filter by Values-en.srt

   122 Filter by Values.mp4

   123 Filter by Values - Top or Bottom 10 Items-it.srt

   124 Filter by Values - Top or Bottom-en.srt

   124 Filter by Values - Top or Bottom.mp4

   125 Filter by Values - Top or Bottom Sum-it.srt

   126 Filter by Report Filter-en.srt

   126 Filter by Report Filter.mp4

   127 TIP Shortcuts to filters-it.srt

   128 TIP Keep or hide selected items-en.srt

   128 TIP Keep or hide selected items.mp4

   129 TIP Filter by Text wildcards and-it.srt

   130 TIP Filter by multiple fields-en.srt

   130 TIP Filter by multiple fields.mp4

   131 TIP Apply multiple filters-it.srt

   132 TIP Filter by multiple values-en.srt

   132 TIP Filter by multiple values.mp4

   133 TIP Include new items in manual filter-it.srt

   134 TIP Clear filters with one click-en.srt

   134 TIP Clear filters with one click.mp4

   135 TIP Add a filter for the column items-it.srt

   136 CASE STUDY ~ ACCOUNTING Top 5 Expenses report-en.srt

   136 CASE STUDY ~ ACCOUNTING Top 5 Expenses report.mp4

   137 CASE STUDY ~ FINANCIAL Top 25 of Channel Partners-it.srt

  07 SLICERS (NEW IN EXCEL E0)

   138 WORKBOOKS.html

   139 Insert a Slicer-it.srt

   140 Slicer Styles-en.srt

   140 Slicer Styles.mp4

   141 Creating a custom style-it.srt

   142 Copy a custom style into a new workbook-en.srt

   142 Copy a custom style into a new workbook.mp4

   143 Slicer Settings-it.srt

   144 Slicer Size Properties-en.srt

   144 Slicer Size Properties.mp4

   145 Slicer Connections for multiple pivot tables-it.srt

   146 TIP Different ways to filter a Slicer-en.srt

   146 TIP Different ways to filter a Slicer.mp4

   147 TIP Use one slicer for two pivot tables-it.srt

   148 TIP Lock the workbook but not the slicer-en.srt

   148 TIP Lock the workbook but not the slicer.mp4

   149 TIP Interactive employee photos with Slicers FUN-it.srt

   150 CASE STUDY ~ ACCOUNTING Select a Monthly PL report with a Slicer-en.srt

   150 CASE STUDY ~ ACCOUNTING Select a Monthly PL report with a Slicer.mp4

   151 CASE STUDY ~ FINANCIAL Base Best Worst case Forecast-it.srt

   152 Course Review-en.srt

   152 Course Review.mp4

  08 CALCULATED FIELDS ITEMS

   153 WORKBOOKS.html

   154 Creating a Calculated Field-it.srt

   155 Use an existing Calculated Field in a new calculation-en.srt

   155 Use an existing Calculated Field in a new calculation.mp4

   156 Editing a Calculated Field-it.srt

   157 Excel formulas Calculated Fields-en.srt

   157 Excel formulas Calculated Fields.mp4

   158 Creating a Calculated Item-it.srt

   159 Use an existing Calculated Item in a new calculation-en.srt

   159 Use an existing Calculated Item in a new calculation.mp4

   160 Editing a Calculated Item-it.srt

   161 Excel formulas Calculated Items-en.srt

   161 Excel formulas Calculated Items.mp4

   162 Calculated Item on Column Labels-it.srt

   163 Shortcomings of Calculated Items-en.srt

   163 Shortcomings of Calculated Items.mp4

   164 TIP Solve Order for Calculated Items-it.srt

   165 TIP List Calculated Field Item formulas-en.srt

   165 TIP List Calculated Field Item formulas.mp4

   166 TIP Remove a Calculated Field temporarily-it.srt

   167 TIP Order of operations-en.srt

   167 TIP Order of operations.mp4

   168 CASE STUDY ~ ACCOUNTING Creating a PL Pivot Table Report-it.srt

   169 CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields-en.srt

   169 CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.mp4

  09 PIVOT CHARTS

   170 WORKBOOKS.html

   171 Insert a Pivot Chart-it.srt

   172 Insert a Slicer with a Pivot Chart-en.srt

   172 Insert a Slicer with a Pivot Chart.mp4

   173 Pivot Chart Designs-it.srt

   174 Pivot Chart Layouts-en.srt

   174 Pivot Chart Layouts.mp4

   175 Pivot Chart Formats-it.srt

   176 Limitations of Pivot Charts workarounds-en.srt

   176 Limitations of Pivot Charts workarounds.mp4

   177 Saving a Pivot Chart template-it.srt

   178 TIP Shortcuts to formatting a Pivot Chart-en.srt

   178 TIP Shortcuts to formatting a Pivot Chart.mp4

   179 TIP Link chart title to a pivot cell-it.srt

   180 TIP Copying a second chart-en.srt

   180 TIP Copying a second chart.mp4

   181 TIP Put a chart on a separate page with F11-it.srt

   182 TIP Insert Pivot Chart straight from the data source-en.srt

   182 TIP Insert Pivot Chart straight from the data source.mp4

   183 TIP Paste Pivot Chart to your email as a picture-it.srt

   184 TIP Paste Pivot Chart to PowerPoint make live updates-en.srt

   184 TIP Paste Pivot Chart to PowerPoint make live updates.mp4

   185 TIP Printing a Pivot Chart-it.srt

   186 TIP Include a Sparkline with your pivot table-en.srt

   186 TIP Include a Sparkline with your pivot table.mp4

   187 TIP Charts Do s Donts-it.srt

   188 TIP Change Chart Type with Slicers FUN-en.srt

   188 TIP Change Chart Type with Slicers FUN.mp4

   189 TIP Workaround to creating an interactive Scatter graph-it.srt

   190 CASE STUDY ~ ACCOUNTING PL Pivot Table report with Graphs-en.srt

   190 CASE STUDY ~ ACCOUNTING PL Pivot Table report with Graphs.mp4

   191 CASE STUDY ~ FINANCIAL Pivot Table Slicer Chart Dashboard-it.srt

  10 CONDITIONAL FORMATTING PIVOT TABLES

   192 WORKBOOKS.html

   193 Intro to Conditional Formatting-it.srt

   194 Highlight Cell Rules based on values-en.srt

   194 Highlight Cell Rules based on values.mp4

   195 Highlight Cell Rules based on text labels-it.srt

   196 Highlight Cell Rules based on date labels-en.srt

   196 Highlight Cell Rules based on date labels.mp4

   197 Top Bottom Rules-it.srt

   198 Data Bars Color Scales Icon Sets (NEW IN EXCEL E0)-en.srt

   198 Data Bars Color Scales Icon Sets (NEW IN EXCEL E0).mp4

   199 TIP Format only cells that contain - For Bonuses-it.srt

   200 TIP Format only Top or Bottom ranked values - Top 3 sales per year-en.srt

   200 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4

   201 TIP Format values that are above or below the average - For Promotions-it.srt

   202 TIP Use a formula to determine which cells to format-en.srt

   202 TIP Use a formula to determine which cells to format.mp4

   203 Use selected cells to format multiple fields-it.srt

   204 All cells showing values to format multiple fields-en.srt

   204 All cells showing values to format multiple fields.mp4

   205 Control Conditional Formatting with Slicers-it.srt

   206 Show text in the Pivot Table Values area-en.srt

   206 Show text in the Pivot Table Values area.mp4

   207 Cond Format blank cells or cells-it.srt

   208 CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix-en.srt

   208 CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4

   209 CASE STUDY ~ FINANCIAL Conditionally Format your sales results-it.srt

  11 GETPIVOTDATA Formula

   210 WORKBOOKS.html

   211 Intro to GETPIVOTDATA-it.srt

   212 Create a custom report with GETPIVOTDATA-en.srt

   212 Create a custom report with GETPIVOTDATA.mp4

   213 Reference Dates with GETPIVOTDATA-it.srt

   214 Data validation with GETPIVOTDATA-en.srt

   214 Data validation with GETPIVOTDATA.mp4

   215 Shortfalls of GETPIVOTDATA-it.srt

   216 TIP Grand Totals to the left of the pivot table-en.srt

   216 TIP Grand Totals to the left of the pivot table.mp4

   217 CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA-it.srt

   218 CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA-en.srt

   218 CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.mp4

  12 MACROS PIVOT TABLES

   219 WORKBOOKS.html

   220 Adding the Developer tab disabling macros-it.srt

   221 Record a simple macro to Refresh a pivot table-en.srt

   221 Record a simple macro to Refresh a pivot table.mp4

   222 Date filter macro-it.srt

   223 Different pivot table views macro-en.srt

   223 Different pivot table views macro.mp4

   224 Top 10 macro-it.srt

   225 Add macro to quick access toolbar-en.srt

   225 Add macro to quick access toolbar.mp4

  14 BONUS VIDEOS

   233 WORKBOOKS.html

   234 Sales Forecasting with Calculated Fields-it.srt

   235 Consolidate with a Pivot Table-en.srt

   235 Consolidate with a Pivot Table.mp4

   236 Frequency distribution with a Pivot Table-it.srt

   237 Break Even Model-en.srt

   237 Break Even Model.mp4

   238 Several Slicer custom styles for you to use-it.srt

   239 Interactive Balance Sheet Pivot Table-en.srt

   239 Interactive Balance Sheet Pivot Table.mp4

   240 Monthly Sales Manager Performance Report-it.srt

   241 Reconciling customer payments-en.srt

   241 Reconciling customer payments.mp4

  15 NEW EXCEL E3 PIVOT TABLE FEATURES

   242 WORKBOOKS.html

   243 Cosmetic changes in the PivotTable Tools Ribbon Menu-it.srt

   244 Recommended Pivot Tables-en.srt

   244 Recommended Pivot Tables.mp4

   245 Distinct Count-it.srt

   246 Timelime Slicers-en.srt

   246 Timelime Slicers.mp4

   247 Data Models-it.srt

  16 NEW EXCEL E6 PIVOT TABLE FEATURES

   248 WORKBOOKS.html

   249 Group Periods-it.srt

   250 Multi-Select Slicer items-en.srt

   250 Multi-Select Slicer items.mp4

   251 Pivot Chart - Expand and Collapse fields-it.srt

   252 3D Maps-en.srt

   252 3D Maps.mp4

  17 NEW EXCEL E9 OFFICE 365 PIVOT TABLE FEATURES

   253 ExcelE9NewFeatureWorkbooks.zip

   254 Which Excel version do you have-it.srt

   255 Default Pivot Table Layout-en.srt

   255 Default Pivot Table Layout.mp4

   256 Automatic Relationship Detection-it.srt

   257 Automatic Time Grouping-en.srt

   257 Automatic Time Grouping.mp4

   258 Search in a Pivot Table-it.srt

  18 BONUS THE MYEXCELONLINE ACADEMY

   259 THANK YOU-it.srt

   260 Academy-Course-Upgrade-COUPON.pdf

   260 The MyExcelOnline Academy Online Course-it.srt

   external-assets-links.txt

  001 PIVOT TABLE COURSE INTRODUCTION

   001 PIVOT TABLE COURSE INTRODUCTION-it.srt

   002 EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ).html

   003 Xtreme-Pivot-Table-Course-Outline.xlsx

   004 Pivot-Table-Cheat-Sheet-New.pdf

   005 BONUS 3 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD].html

   006 BONUS 4 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD].html

   007 Keyboard-Shortcuts-Bonus.pdf

   009 BONUS 7 MY EXCEL PODCAST SHOW.html

 Visit Coursedrive.org.url