| | | 000 Introduction.mp4 | 2.31 MB |
| | | 000 BONUS PIVOT TABLE CHEAT SHEET.pdf | 995.35 KB |
| | | 001 BONUS EXCEL RESOURCE BLOG.pdf | 278.59 KB |
| | | 002 BONUS MY EXCEL PODCAST SHOW.pdf | 30.44 KB |
| | | 001 BONUS TOP 20 EXCEL SHORTCUTS.html | 1.73 KB |
| | | 000 COURSE TRACKER WORKBOOK.html | 1.62 KB |
| | | 030 OPTIONS SHOW Expand Collapse buttons.mp4 | 23.94 MB |
| | | 023 DESIGN STYLES Customising a Pivot Table Style.mp4 | 23.18 MB |
| | | 022 DESIGN STYLES Pivot Table Styles.mp4 | 22.5 MB |
| | | 016 OPTIONS DATA Refresh External Data.mp4 | 21.4 MB |
| | | 008 CREATING A PIVOT TABLE Field List Areas.mp4 | 19.24 MB |
| | | 020 OPTIONS ACTIONS Select format.mp4 | 19.1 MB |
| | | 018 OPTIONS DATA Change Data Source.mp4 | 19.1 MB |
| | | 004 ARRANGING YOUR DATA SET Tables.mp4 | 15.78 MB |
| | | 027 DESIGN LAYOUT Report Layouts.mp4 | 13.9 MB |
| | | 046 LAYOUT FORMAT TIPShow report filter on multiple pages.mp4 | 12.74 MB |
| | | 008 Std Dev.mp4 | 24.78 MB |
| | | 012 TIP See all pivot Items.mp4 | 20.2 MB |
| | | 009 Varp.mp4 | 18.3 MB |
| | | 003 Average.mp4 | 16.86 MB |
| | | 002 Count.mp4 | 15.08 MB |
| | | 013 TIP Show a unique count.mp4 | 14.09 MB |
| | | 010 TIP Show various Grand Totals.mp4 | 12.76 MB |
| | | 006 Product.mp4 | 12.25 MB |
| | | 011 TIP Shortcuts to Field Value Field Settings.mp4 | 11.01 MB |
| | | 004 Maximum.mp4 | 10.62 MB |
| | | 008 Difference From.mp4 | 24.2 MB |
| | | 017 CASE STUDY FINANCIAL Actual v Plan Variance Report.mp4 | 23.1 MB |
| | | 009 Difference From.mp4 | 20.05 MB |
| | | 004 Of.mp4 | 18.49 MB |
| | | 007 of Parent Total NEW IN EXCEL 2010.mp4 | 16.57 MB |
| | | 014 Index.mp4 | 15.34 MB |
| | | 001 of Grand Total.mp4 | 12.48 MB |
| | | 006 of Parent Column Total NEW IN EXCEL 2010.mp4 | 11.88 MB |
| | | 011 Running Total in NEW IN EXCEL 2010.mp4 | 11.61 MB |
| | | 002 of Column Total.mp4 | 11.31 MB |
| | | 016 CASE STUDY ACCOUNTING Quarterly Comparative Report.mp4 | 37.65 MB |
| | | 011 TIP Group by fiscal years quarters.mp4 | 20.95 MB |
| | | 017 CASE STUDY FINANCIAL Min Max Bank Balance.mp4 | 20.14 MB |
| | | 001 Group by Date.mp4 | 14.65 MB |
| | | 004 Group by Sales ranges.mp4 | 13.89 MB |
| | | 012 TIP Errors when grouping by dates.mp4 | 11.7 MB |
| | | 010 TIP Grouping by a custom date.mp4 | 10.49 MB |
| | | 002 Group by Months.mp4 | 8.32 MB |
| | | 009 TIP Group by a Date that starts on a Monday.mp4 | 7.73 MB |
| | | 013 TIP Group two pivot tables independently.mp4 | 7.34 MB |
| | | 004 Sort using a Custom List.mp4 | 11.65 MB |
| | | 003 Sort manually drag, write, right click.mp4 | 7.35 MB |
| | | 001 Sorting by Largest or Smallest.mp4 | 7.14 MB |
| | | 002 Sort an Item Row Left to Right.mp4 | 6.27 MB |
| | | 006 Sort row from A-Z and sales from Z-A.mp4 | 5.84 MB |
| | | 005 Override a Custom List sort.mp4 | 4.97 MB |
| | | 007 TIP Sort new items added to your data source.mp4 | 4.71 MB |
| | | 008 TIP Clear a sort.mp4 | 2.7 MB |
| | | 009 TIP Sort Largest to Smallest Grand Totals.mp4 | 2.24 MB |
| | | 001 Identify the steps to creating a Custom List Quiz.html | 7.04 KB |
| | | 001 WORKBOOKS.html | 1.31 KB |
| | | 001 Filter by Dates.mp4 | 25.11 MB |
| | | 008 Filter by Report Filter.mp4 | 14.18 MB |
| | | 011 TIP Filter by Text wildcards and.mp4 | 12.39 MB |
| | | 003 Filter by Labels - Numerical Text.mp4 | 11.11 MB |
| | | 019 CASE STUDY FINANCIAL Top 25 of Channel Partners.mp4 | 9.96 MB |
| | | 002 Filter by Labels - Text.mp4 | 9.73 MB |
| | | 018 CASE STUDY ACCOUNTING Top 5 Expenses report.mp4 | 9.47 MB |
| | | 005 Filter by Values - Top or Bottom 10 Items.mp4 | 8.12 MB |
| | | 015 TIP Include new items in manual filter.mp4 | 8.08 MB |
| | | 006 Filter by Values - Top or Bottom.mp4 | 7.65 MB |
| | | 011 TIP Interactive employee photos with Slicers FUN.mp4 | 31.08 MB |
| | | 003 Creating a custom style.mp4 | 22.9 MB |
| | | 013 CASE STUDY FINANCIAL Base, Best Worst case Forecast.mp4 | 22.65 MB |
| | | 005 Slicer Settings.mp4 | 21.98 MB |
| | | 012 CASE STUDY ACCOUNTING Select a Monthly PL report with a Slicer.mp4 | 20.95 MB |
| | | 001 Insert a Slicer.mp4 | 13.79 MB |
| | | 007 Slicer Connections for multiple pivot tables.mp4 | 13.76 MB |
| | | 006 Slicer Size Properties.mp4 | 10.64 MB |
| | | 002 Slicer Styles.mp4 | 10.05 MB |
| | | 010 TIP Lock the workbook but not the slicer.mp4 | 6.92 MB |
| | | 015 CASE STUDY ACCOUNTING Creating a PL Pivot Table Report.mp4 | 58.6 MB |
| | | 016 CASE STUDY FINANCIAL Actuals v Plan with Calculated Fields.mp4 | 50.99 MB |
| | | 011 TIP Solve Order for Calculated Items.mp4 | 21.37 MB |
| | | 005 Creating a Calculated Item.mp4 | 17.67 MB |
| | | 001 Creating a Calculated Field.mp4 | 17.09 MB |
| | | 004 Excel formulas Calculated Fields.mp4 | 13.99 MB |
| | | 007 Editing a Calculated Item.mp4 | 13.79 MB |
| | | 002 Use an existing Calculated Field in a new calculation.mp4 | 12.79 MB |
| | | 003 Editing a Calculated Field.mp4 | 12.77 MB |
| | | 009 Calculated Item on Column Labels.mp4 | 11.2 MB |
| | | 021 CASE STUDY FINANCIAL Pivot Table Slicer Chart Dashboard.mp4 | 67.81 MB |
| | | 020 CASE STUDY ACCOUNTING PL Pivot Table report with Graphs.mp4 | 38.49 MB |
| | | 018 TIP Change Chart Type with Slicers FUN.mp4 | 28.79 MB |
| | | 004 Pivot Chart Layouts.mp4 | 20.35 MB |
| | | 005 Pivot Chart Formats.mp4 | 20.07 MB |
| | | 003 Pivot Chart Designs.mp4 | 15.04 MB |
| | | 001 Insert a Pivot Chart.mp4 | 12.12 MB |
| | | 019 TIP Workaround to creating an interactive Scatter graph.mp4 | 10.73 MB |
| | | 017 TIP Charts Dos Donts.mp4 | 10.14 MB |
| | | 006 Limitations of Pivot Charts workarounds.mp4 | 8.2 MB |
| | | 016 CASE STUDY ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 | 27.31 MB |
| | | 006 Data Bars, Color Scales Icon Sets NEW IN EXCEL 2010.mp4 | 24.18 MB |
| | | 014 Show text in the Pivot Table Values area.mp4 | 22.3 MB |
| | | 005 Top Bottom Rules.mp4 | 17.07 MB |
| | | 017 CASE STUDY FINANCIAL Conditionally Format your sales results.mp4 | 15.55 MB |
| | | 001 Intro to Conditional Formatting.mp4 | 13.75 MB |
| | | 013 Control Conditional Formatting with Slicers.mp4 | 10.47 MB |
| | | 010 TIP Use a formula to determine which cells to format.mp4 | 9.45 MB |
| | | 011 Use selected cells to format multiple fields.mp4 | 8.73 MB |
| | | 008 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 | 8.6 MB |
| | | 007 CASE STUDY ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 | 31.02 MB |
| | | 008 CASE STUDY FINANCIAL Channel Analysis with GETPIVOTDATA.mp4 | 24.99 MB |
| | | 001 Intro to GETPIVOTDATA.mp4 | 22.06 MB |
| | | 006 TIP Grand Totals to the left of the pivot table.mp4 | 13.42 MB |
| | | 004 Data validation with GETPIVOTDATA.mp4 | 12.68 MB |
| | | 003 Reference Dates with GETPIVOTDATA.mp4 | 11.04 MB |
| | | 005 Shortfalls of GETPIVOTDATA.mp4 | 6.03 MB |
| | | 002 Create a custom report with GETPIVOTDATA.mp4 | 1.08 MB |
| | | 001 Define when to use the GETPIVOTDATA function Quiz.html | 6.99 KB |
| | | 001 WORKBOOKS.html | 1.31 KB |
| | | 004 Different pivot table views macro.mp4 | 19.08 MB |
| | | 002 Record a simple macro to Refresh a pivot table.mp4 | 17.51 MB |
| | | 003 Date filter macro.mp4 | 15.07 MB |
| | | 005 Top 10 macro.mp4 | 11.4 MB |
| | | 006 Add macro to quick access toolbar.mp4 | 7.14 MB |
| | | 001 Adding the Developer tab disabling macros.mp4 | 3.78 MB |
| | | 001 Recall how to assign a macro Quiz.html | 6.96 KB |
| | | 001 WORKBOOKS.html | 1.31 KB |
| | | 002 Reducing file memory by deleting the data source.mp4 | 12.23 MB |
| | | 004 Reducing file memory by keeping data source in MS Access.mp4 | 10.37 MB |
| | | 001 Reducing file memory by copying existing pivot table.mp4 | 8.75 MB |
| | | 006 Sharing a Pivot Table via OneDrive.mp4 | 8.57 MB |
| | | 003 Reducing file memory by saving file as Excel Binary Workbook.mp4 | 6.27 MB |
| | | 005 Compatibility Issues with Excel 2007 and Excel 2010.mp4 | 4.27 MB |
| | | 001 List the ways to reduce the memory size of an Excel file Quiz.html | 6.95 KB |
| | | 001 WORKBOOKS.html | 1.26 KB |
| | | 006 Interactive Balance Sheet Pivot Table.mp4 | 47.83 MB |
| | | 007 Monthly Sales Manager Performance Report.mp4 | 27.67 MB |
| | | 002 Consolidate with a Pivot Table.mp4 | 22.14 MB |
| | | 001 Sales Forecasting with Calculated Fields.mp4 | 21.27 MB |
| | | 003 Frequency distribution with a Pivot Table.mp4 | 10.02 MB |
| | | 004 Break Even Model.mp4 | 9.42 MB |
| | | 005 Several Slicer custom styles for you to use.mp4 | 6.87 MB |
| | | 008 Reconciling customer payments.mp4 | 6.45 MB |
| | | 009 THANK YOU.mp4 | 1.63 MB |
| | | 001 WORKBOOKS.html | 1.31 KB |