Filename | Size |
| 1. Chapter 1/1. INTRODUCTION.mp4 | 26.2 MB |
| 1. Chapter 1/1. INTRODUCTION.vtt | 1.1 KB |
| 1. Chapter 1/2. EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ).html | 914 B |
| 1. Chapter 1/3. BONUS #1 COURSE TRACKER EXCEL WORKBOOK.html | 431 B |
| 1. Chapter 1/3.1 Xtreme Pivot Table Course Outline.xlsx.xlsx | 63.2 KB |
| 1. Chapter 1/4. BONUS #2 PIVOT TABLE CHEAT SHEET.pdf | 2.4 MB |
| 1. Chapter 1/5. BONUS #3 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE INFORGRAPHIC.html | 24 B |
| 1. Chapter 1/5.1 5 Speedy Steps to an Excel Pivot Table.pdf.pdf | 4.8 MB |
| 1. Chapter 1/6. BONUS #4 50+ EXCEL KEYBOARD SHORTCUTS (IN KEYBOARD LAYOUT).html | 266 B |
| 1. Chapter 1/6.1 Keyboard_Shortcuts_Bonus.pdf.pdf | 2 MB |
| 1. Chapter 1/7. BONUS #5 EXCEL RESOURCE BLOG.html | 474 B |
| 1. Chapter 1/8. BONUS #6 MY EXCEL PODCAST SHOW.html | 1.2 KB |
| 1. Chapter 1/9. BONUS EXCEL RESOURCE BLOG.pdf | 278.6 KB |
| 10. PIVOT CHARTS/1. WORKBOOKS.html | 76 B |
| 10. PIVOT CHARTS/1.1 CHAPTER 9.zip | 1.6 MB |
| 10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.mp4 | 1.7 MB |
| 10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.vtt | 1 KB |
| 10. PIVOT CHARTS/11. TIP Copying a second chart.mp4 | 1.5 MB |
| 10. PIVOT CHARTS/11. TIP Copying a second chart.vtt | 703 B |
| 10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.mp4 | 1.2 MB |
| 10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.vtt | 569 B |
| 10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.mp4 | 1.9 MB |
| 10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.vtt | 782 B |
| 10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.mp4 | 1.6 MB |
| 10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.vtt | 1.1 KB |
| 10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.mp4 | 2.5 MB |
| 10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.vtt | 1.5 KB |
| 10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.mp4 | 2.3 MB |
| 10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.vtt | 1.4 KB |
| 10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.mp4 | 2.3 MB |
| 10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.vtt | 1.2 KB |
| 10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.mp4 | 4.2 MB |
| 10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.vtt | 2.7 KB |
| 10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.mp4 | 12.1 MB |
| 10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.vtt | 7.9 KB |
| 10. PIVOT CHARTS/2. Insert a Pivot Chart.mp4 | 5.1 MB |
| 10. PIVOT CHARTS/2. Insert a Pivot Chart.vtt | 3.4 KB |
| 10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.mp4 | 4.4 MB |
| 10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.vtt | 2.6 KB |
| 10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.mp4 | 14.9 MB |
| 10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.vtt | 8.5 KB |
| 10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.mp4 | 27.6 MB |
| 10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.vtt | 16.7 KB |
| 10. PIVOT CHARTS/23. State the button to format a Pivot Chart.html | 135 B |
| 10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.mp4 | 3.1 MB |
| 10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.vtt | 1.8 KB |
| 10. PIVOT CHARTS/4. Pivot Chart Designs.mp4 | 6.3 MB |
| 10. PIVOT CHARTS/4. Pivot Chart Designs.vtt | 3.6 KB |
| 10. PIVOT CHARTS/5. Pivot Chart Layouts.mp4 | 8 MB |
| 10. PIVOT CHARTS/5. Pivot Chart Layouts.vtt | 3.6 KB |
| 10. PIVOT CHARTS/6. Pivot Chart Formats.mp4 | 8.6 MB |
| 10. PIVOT CHARTS/6. Pivot Chart Formats.vtt | 6.3 KB |
| 10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.mp4 | 3.4 MB |
| 10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.vtt | 2 KB |
| 10. PIVOT CHARTS/8. Saving a Pivot Chart template.mp4 | 2.6 MB |
| 10. PIVOT CHARTS/8. Saving a Pivot Chart template.vtt | 1.6 KB |
| 10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.mp4 | 2.3 MB |
| 10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.vtt | 1.3 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/1. WORKBOOKS.html | 76 B |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/1.1 CHAPTER 10.zip | 1.1 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.mp4 | 2.5 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.vtt | 1.8 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.mp4 | 4.1 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.vtt | 2.6 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.mp4 | 3.3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.vtt | 1.6 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.mp4 | 3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.vtt | 1.5 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.mp4 | 4.4 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.vtt | 2.5 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.mp4 | 8.7 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.vtt | 3.9 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.mp4 | 2.3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.vtt | 1.2 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 | 10.8 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.vtt | 7 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.mp4 | 6.1 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.vtt | 3.8 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/19. Recognize the option that conditionally formats all values except the Subtotals.html | 135 B |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.mp4 | 5.3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.vtt | 2.9 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.mp4 | 2.6 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.vtt | 1.5 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.mp4 | 1.7 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.vtt | 815 B |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.mp4 | 2.3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.vtt | 1.3 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.mp4 | 6.6 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.vtt | 3.6 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).mp4 | 9.8 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).vtt | 6.4 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.mp4 | 3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.vtt | 1.7 KB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 | 3.3 MB |
| 11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.vtt | 1.5 KB |
| 12. GETPIVOTDATA Formula/1. WORKBOOKS.html | 76 B |
| 12. GETPIVOTDATA Formula/1.1 CHAPTER 11.zip | 589 KB |
| 12. GETPIVOTDATA Formula/10. Define when to use the GETPIVOTDATA function.html | 135 B |
| 12. GETPIVOTDATA Formula/2. Intro to GETPIVOTDATA.mp4 | 8.7 MB |