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