[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course

Creation Time	Nov. 8, 2023, 4:21 a.m.
Last Access Time	Nov. 22, 2024, 4:40 p.m.
File Size	1.4 GB
Keywords	Tables DesireCourse - Excel Udemy Course Pivot The Xtreme Com Microsoft
Total Requests	45
Total Files	516
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

14. DATA MANAGEMENT/1.1 CHAPTER_13.zip.zip 108.7 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/6. Data Models.mp4 75.2 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/5. Timelime Slicers.mp4 38.6 MB
10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.mp4 27.6 MB
1. Chapter 1/1. INTRODUCTION.mp4 26.2 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/3. Recommended Pivot Tables.mp4 25.4 MB
18. BONUS THE MYEXCELONLINE ACADEMY!/1. The MyExcelOnline Academy Online Course.mp4 22.2 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/2. Cosmetic changes in the PivotTable Tools Ribbon Menu.mp4 21.5 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/4. Distinct Count.mp4 20.3 MB
9. CALCULATED FIELDS & ITEMS/16. CASE STUDY ~ ACCOUNTING Creating a P&L Pivot Table Report.mp4 20.1 MB
15. BONUS VIDEOS/7. Interactive Balance Sheet Pivot Table.mp4 19.1 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/2. Group Periods.mp4 18.2 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/5. 3D Maps.mp4 18.2 MB
9. CALCULATED FIELDS & ITEMS/17. CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.mp4 17.2 MB
10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.mp4 14.9 MB
5. GROUPING/17. CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.mp4 14.3 MB
8. SLICERS (NEW IN EXCEL 2010)/12. TIP Interactive employee photos with Slicers! FUN!.mp4 13.3 MB
12. GETPIVOTDATA Formula/8. CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 12.4 MB
10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.mp4 12.1 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/4. Pivot Chart - Expand and Collapse fields.mp4 11.7 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 10.8 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/9. Std Dev.mp4 10.7 MB
7. FILTERING/2. Filter by Dates.mp4 10.2 MB
15. BONUS VIDEOS/8. Monthly Sales Manager Performance Report.mp4 10.1 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).mp4 9.8 MB
12. GETPIVOTDATA Formula/9. CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.mp4 9.7 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/9. Difference From.mp4 9.4 MB
8. SLICERS (NEW IN EXCEL 2010)/4. Creating a custom style.mp4 9.3 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/18. CASE STUDY ~ FINANCIAL Actual v Plan Variance Report.mp4 9.2 MB
5. GROUPING/12. TIP Group by fiscal years & quarters.mp4 9.1 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/31. OPTIONS SHOW ~ Expand & Collapse buttons.mp4 8.9 MB
12. GETPIVOTDATA Formula/3. Create a custom report with GETPIVOTDATA.mp4 8.9 MB
8. SLICERS (NEW IN EXCEL 2010)/14. CASE STUDY ~ FINANCIAL Base, Best & Worst case Forecast.mp4 8.8 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.mp4 8.7 MB
12. GETPIVOTDATA Formula/2. Intro to GETPIVOTDATA.mp4 8.7 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/13. TIP See all pivot Items.mp4 8.6 MB
8. SLICERS (NEW IN EXCEL 2010)/6. Slicer Settings.mp4 8.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/24. DESIGN STYLES ~ Customising a Pivot Table Style.mp4 8.6 MB
10. PIVOT CHARTS/6. Pivot Chart Formats.mp4 8.6 MB
15. BONUS VIDEOS/3. Consolidate with a Pivot Table.mp4 8.5 MB
9. CALCULATED FIELDS & ITEMS/12. TIP Solve Order for Calculated Items.mp4 8.4 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/17. OPTIONS DATA ~ Refresh External Data.mp4 8.3 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/23. DESIGN STYLES ~ Pivot Table Styles.mp4 8.2 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/6. % of Parent Row Total (NEW IN EXCEL 2010).mp4 8.2 MB
5. GROUPING/18. CASE STUDY ~ FINANCIAL Min & Max Bank Balance.mp4 8.1 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/9. CREATING A PIVOT TABLE ~ Field List & Areas.mp4 8.1 MB
15. BONUS VIDEOS/2. Sales Forecasting with Calculated Fields.mp4 8.1 MB
10. PIVOT CHARTS/5. Pivot Chart Layouts.mp4 8.0 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/10. % Difference From.mp4 8.0 MB
8. SLICERS (NEW IN EXCEL 2010)/13. CASE STUDY ~ ACCOUNTING Select a Monthly P&L report with a Slicer.mp4 7.9 MB
5. GROUPING/14. TIP Group two pivot tables independently.mp4 7.8 MB
13. MACROS & PIVOT TABLES/5. Different pivot table views macro.mp4 7.6 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/5. % Of.mp4 7.5 MB
9. CALCULATED FIELDS & ITEMS/6. Creating a Calculated Item.mp4 7.4 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/21. OPTIONS ACTIONS ~ Select & format.mp4 7.2 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/19. OPTIONS DATA ~ Change Data Source.mp4 7.2 MB
13. MACROS & PIVOT TABLES/3. Record a simple macro to Refresh a pivot table.mp4 7.2 MB
9. CALCULATED FIELDS & ITEMS/2. Creating a Calculated Field.mp4 7.1 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/10. Varp.mp4 6.8 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/1.1 New Excel 2013 Features.zip.zip 6.8 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.mp4 6.6 MB
10. PIVOT CHARTS/4. Pivot Chart Designs.mp4 6.3 MB
13. MACROS & PIVOT TABLES/4. Date filter macro.mp4 6.3 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/15. Index.mp4 6.3 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/8. % of Parent Total (NEW IN EXCEL 2010).mp4 6.2 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.mp4 6.1 MB
7. FILTERING/5. Filter by Values.mp4 6.1 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/4. Average.mp4 5.9 MB
8. SLICERS (NEW IN EXCEL 2010)/2. Insert a Slicer.mp4 5.9 MB
7. FILTERING/9. Filter by Report Filter.mp4 5.9 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/5. ARRANGING YOUR DATA SET ~ Tables.mp4 5.8 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/7. CREATING A PIVOT TABLE ~ Inserting a Pivot Table.mp4 5.8 MB
5. GROUPING/5. Group by Sales ranges.mp4 5.7 MB
9. CALCULATED FIELDS & ITEMS/5. Excel formulas & Calculated Fields.mp4 5.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/3. ARRANGING YOUR DATA SET ~ No Gaps.mp4 5.6 MB
5. GROUPING/2. Group by Date.mp4 5.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/2. ARRANGING YOUR DATA SET ~ Tabular Format.mp4 5.6 MB
8. SLICERS (NEW IN EXCEL 2010)/8. Slicer Connections for multiple pivot tables.mp4 5.6 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/3. Count.mp4 5.5 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/14. TIP Show a unique count.mp4 5.5 MB
12. GETPIVOTDATA Formula/7. TIP Grand Totals to the left of the pivot table.mp4 5.4 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.mp4 5.3 MB
9. CALCULATED FIELDS & ITEMS/8. Editing a Calculated Item.mp4 5.3 MB
7. FILTERING/12. TIP Filter by Text wildcards and .mp4 5.2 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/28. DESIGN LAYOUT ~ Report Layouts.mp4 5.2 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/7. Product.mp4 5.2 MB
10. PIVOT CHARTS/2. Insert a Pivot Chart.mp4 5.1 MB
9. CALCULATED FIELDS & ITEMS/3. Use an existing Calculated Field in a new calculation.mp4 5.0 MB
12. GETPIVOTDATA Formula/5. Data validation with GETPIVOTDATA.mp4 5.0 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/47. LAYOUT & FORMAT ~ TIPShow report filter on multiple pages.mp4 4.9 MB
6. SORTING/5. Sort using a Custom List.mp4 4.9 MB
1. Chapter 1/5.1 5 Speedy Steps to an Excel Pivot Table.pdf.pdf 4.8 MB
13. MACROS & PIVOT TABLES/6. Top 10 macro.mp4 4.8 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/11. TIP Show various Grand Totals.mp4 4.8 MB
9. CALCULATED FIELDS & ITEMS/4. Editing a Calculated Field.mp4 4.8 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/12. % Running Total in (NEW IN EXCEL 2010).mp4 4.8 MB
5. GROUPING/13. TIP Errors when grouping by dates.mp4 4.7 MB
12. GETPIVOTDATA Formula/4. Reference Dates with GETPIVOTDATA.mp4 4.7 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/2. % of Grand Total.mp4 4.6 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/7. % of Parent Column Total (NEW IN EXCEL 2010).mp4 4.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/32. OPTIONS SHOW ~ Move & Remove Fields and Items.mp4 4.6 MB
8. SLICERS (NEW IN EXCEL 2010)/7. Slicer Size & Properties.mp4 4.6 MB
7. FILTERING/4. Filter by Labels - Numerical Text.mp4 4.5 MB
9. CALCULATED FIELDS & ITEMS/10. Calculated Item on Column Labels.mp4 4.5 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.mp4 4.4 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/18. OPTIONS DATA ~ Import from Access database.mp4 4.4 MB
10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.mp4 4.4 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/3. % of Column Total.mp4 4.4 MB
14. DATA MANAGEMENT/3. Reducing file memory by deleting the data source.mp4 4.4 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/17. CASE STUDY ~ ACCOUNTING % of Revenue Margins.mp4 4.4 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/11. Running Total in.mp4 4.3 MB
10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.mp4 4.2 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/12. TIP Shortcuts to Field & Value Field Settings.mp4 4.2 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/4. % of Row Total.mp4 4.2 MB
15. BONUS VIDEOS/5. Break Even Model.mp4 4.1 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/14. Rank Largest to Smallest (NEW IN EXCEL 2010).mp4 4.1 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.mp4 4.1 MB
8. SLICERS (NEW IN EXCEL 2010)/3. Slicer Styles.mp4 4.1 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/5. Maximum.mp4 4.0 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/10. CREATING A PIVOT TABLE ~ Drill down to audit.mp4 4.0 MB
5. GROUPING/11. TIP Grouping by a custom date.mp4 4.0 MB
15. BONUS VIDEOS/4. Frequency distribution with a Pivot Table.mp4 4.0 MB
7. FILTERING/3. Filter by Labels - Text.mp4 4.0 MB
14. DATA MANAGEMENT/5. Reducing file memory by keeping data source in MS Access.mp4 4.0 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/16. OPTIONS DATA ~ Refresh All.mp4 4.0 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/6. ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set.mp4 4.0 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/3. Multi-Select Slicer items.mp4 3.9 MB
7. FILTERING/20. CASE STUDY ~ FINANCIAL Top 25% of Channel Partners.mp4 3.9 MB
9. CALCULATED FIELDS & ITEMS/9. Excel formulas & Calculated Items.mp4 3.9 MB
7. FILTERING/19. CASE STUDY ~ ACCOUNTING Top 5 Expenses report.mp4 3.8 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/37. CUSTOMISATION ~ Field name formatting.mp4 3.8 MB
13. MACROS & PIVOT TABLES/2. Adding the Developer tab & disabling macros.mp4 3.7 MB
14. DATA MANAGEMENT/7. Sharing a Pivot Table via OneDrive.mp4 3.7 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/13. Rank Smallest to Largest (NEW IN EXCEL 2010).mp4 3.6 MB
9. CALCULATED FIELDS & ITEMS/7. Use an existing Calculated Item in a new calculation.mp4 3.5 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/8. Count Numbers.mp4 3.4 MB
10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.mp4 3.4 MB
7. FILTERING/6. Filter by Values - Top or Bottom 10 Items.mp4 3.4 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 3.3 MB
9. CALCULATED FIELDS & ITEMS/11. Shortcomings of Calculated Items.mp4 3.3 MB
5. GROUPING/3. Group by Months.mp4 3.3 MB
7. FILTERING/16. TIP Include new items in manual filter.mp4 3.3 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.mp4 3.3 MB
14. DATA MANAGEMENT/2. Reducing file memory by copying existing pivot table.mp4 3.3 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/2. Create multiple subtotals.mp4 3.2 MB
5. GROUPING/10. TIP Group by a Date that starts on a Monday.mp4 3.2 MB
10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.mp4 3.1 MB
6. SORTING/4. Sort manually (drag, write, right click).mp4 3.1 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.mp4 3.0 MB
7. FILTERING/7. Filter by Values - Top or Bottom %.mp4 3.0 MB
5. GROUPING/4. Group by Quarters & Years.mp4 3.0 MB
5. GROUPING/6. Group by Text fields.mp4 3.0 MB
7. FILTERING/14. TIP Apply multiple filters.mp4 3.0 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.mp4 3.0 MB
6. SORTING/2. Sorting by Largest or Smallest.mp4 2.9 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/36. CUSTOMISATION ~ Number formatting.mp4 2.9 MB
15. BONUS VIDEOS/6. Several Slicer custom styles for you to use.mp4 2.9 MB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/6. Minimum.mp4 2.9 MB
13. MACROS & PIVOT TABLES/7. Add macro to quick access toolbar.mp4 2.9 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/25. DESIGN STYLES ~ Use a customised style in another workbook.mp4 2.8 MB
5. GROUPING/7. Group by Time.mp4 2.8 MB
8. SLICERS (NEW IN EXCEL 2010)/5. Copy a custom style into a new workbook.mp4 2.8 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/8. CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout.mp4 2.8 MB
7. FILTERING/10. TIP Shortcuts to filters.mp4 2.8 MB
8. SLICERS (NEW IN EXCEL 2010)/11. TIP Lock the workbook but not the slicer.mp4 2.7 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/43. LAYOUT & FORMAT ~ Format empty cells.mp4 2.7 MB
7. FILTERING/8. Filter by Values - Top or Bottom Sum.mp4 2.7 MB
10. PIVOT CHARTS/8. Saving a Pivot Chart template.mp4 2.6 MB
15. BONUS VIDEOS/9. Reconciling customer payments.mp4 2.6 MB
8. SLICERS (NEW IN EXCEL 2010)/10. TIP Use one slicer for two pivot tables.mp4 2.6 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.mp4 2.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/4. ARRANGING YOUR DATA SET ~ Formatting.mp4 2.6 MB
12. GETPIVOTDATA Formula/6. Shortfalls of GETPIVOTDATA.mp4 2.6 MB
6. SORTING/3. Sort an Item Row (Left to Right).mp4 2.6 MB
7. FILTERING/17. TIP Clear filters with one click.mp4 2.6 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/1.1 CHAPTER 1.zip.zip 2.5 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.mp4 2.5 MB
10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.mp4 2.5 MB
5. GROUPING/9. TIP Grouping by Half Years.mp4 2.5 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/46. LAYOUT & FORMAT ~ TIP Printing a pivot table on two pages.mp4 2.4 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/41. LAYOUT & FORMAT ~ Change the layout of a report filter.mp4 2.4 MB
5. GROUPING/8. TIP Shortcuts to Grouping.mp4 2.4 MB
1. Chapter 1/4. BONUS #2 PIVOT TABLE CHEAT SHEET.pdf 2.4 MB
6. SORTING/7. Sort row from A-Z and sales from Z-A.mp4 2.4 MB
10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.mp4 2.3 MB
10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.mp4 2.3 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.mp4 2.3 MB
10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.mp4 2.3 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/38. CUSTOMISATION ~ TIP Predetermined number formatting.mp4 2.3 MB
14. DATA MANAGEMENT/4. Reducing file memory by saving file as Excel Binary Workbook.mp4 2.3 MB
5. GROUPING/16. TIP Display dates that have no data.mp4 2.3 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.mp4 2.3 MB
9. CALCULATED FIELDS & ITEMS/15. TIP Order of operations.mp4 2.3 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/30. DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout.mp4 2.2 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/35. CUSTOMISATION ~ Change Count of to Sum of.mp4 2.1 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/40. LAYOUT & FORMAT ~ Indent rows in compact layout.mp4 2.1 MB
6. SORTING/6. Override a Custom List sort.mp4 2.1 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/15. OPTIONS DATA ~ Refresh.mp4 2.1 MB
9. CALCULATED FIELDS & ITEMS/13. TIP List Calculated Field & Item formulas.mp4 2.0 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/20. OPTIONS ACTIONS ~ Clear Filters & Clear Pivot.mp4 2.0 MB
6. SORTING/8. TIP Sort new items added to your data source.mp4 2.0 MB
7. FILTERING/15. TIP Filter by multiple values.mp4 2.0 MB
1. Chapter 1/6.1 Keyboard_Shortcuts_Bonus.pdf.pdf 2.0 MB
18. BONUS THE MYEXCELONLINE ACADEMY!/2. THANK YOU!.mp4 2.0 MB
4. VALUE FIELD SETTINGS SHOW VALUES AS/16. TIP Shortcuts to Show Values As.mp4 1.9 MB
8. SLICERS (NEW IN EXCEL 2010)/9. TIP Different ways to filter a Slicer.mp4 1.9 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/27. DESIGN LAYOUT ~ Grand Totals.mp4 1.9 MB
10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.mp4 1.9 MB
14. DATA MANAGEMENT/6. Compatibility Issues with Excel 2007 and Excel 2010.mp4 1.8 MB
7. FILTERING/13. TIP Filter by multiple fields.mp4 1.8 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/44. LAYOUT & FORMAT ~ Keep column widths upon refresh.mp4 1.8 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/14. OPTIONS DATA ~ Pivot Cache explained.mp4 1.7 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.mp4 1.7 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/22. OPTIONS ACTIONS ~ Move a Pivot Table.mp4 1.7 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/45. LAYOUT & FORMAT ~ TIP Automatic Refresh a Pivot Table.mp4 1.7 MB
10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.mp4 1.7 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/26. DESIGN LAYOUT ~ Subtotals.mp4 1.7 MB
9. CALCULATED FIELDS & ITEMS/14. TIP Remove a Calculated Field temporarily.mp4 1.6 MB
10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.mp4 1.6 MB
10. PIVOT CHARTS/1.1 CHAPTER 9.zip 1.6 MB
7. FILTERING/11. TIP Keep or hide selected items.mp4 1.5 MB
10. PIVOT CHARTS/11. TIP Copying a second chart.mp4 1.5 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/13. CREATING A PIVOT TABLE ~ TIP Defer Layout Update.mp4 1.5 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/12. CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields.mp4 1.5 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/42. LAYOUT & FORMAT ~ Format error values.mp4 1.4 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/39. CUSTOMISATION ~ TIP Change Sum views in Label areas.mp4 1.3 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/11. CREATING A PIVOT TABLE ~ Sort Field List from A to Z.mp4 1.2 MB
7. FILTERING/18. TIP Add a filter for the column items.mp4 1.2 MB
5. GROUPING/15. TIP Fixing the problem of counting grouped sales.mp4 1.2 MB
10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.mp4 1.2 MB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/29. DESIGN LAYOUT ~ Blank Rows.mp4 1.2 MB
11. CONDITIONAL FORMATTING PIVOT TABLES/1.1 CHAPTER 10.zip 1.1 MB
7. FILTERING/1.1 CHAPTER 6.zip 1.1 MB
6. SORTING/9. TIP Clear a sort.mp4 1.1 MB
5. GROUPING/1.1 CHAPTER 4.zip 1009.5 KB
9. CALCULATED FIELDS & ITEMS/1.1 CHAPTER 8.zip 1008.7 KB
8. SLICERS (NEW IN EXCEL 2010)/1.1 CHAPTER 7.zip 997.4 KB
6. SORTING/10. TIP Sort Largest to Smallest Grand Totals.mp4 913.1 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/1.1 CHAPTER 2.zip 905.3 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/1.1 CHAPTER 3.zip 837.0 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/34. OPTIONS SHOW ~ ShowHide Field Headers.mp4 813.7 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/33. OPTIONS SHOW ~ ShowHide Field List.mp4 779.4 KB
12. GETPIVOTDATA Formula/1.1 CHAPTER 11.zip 589.0 KB
13. MACROS & PIVOT TABLES/1.1 CHAPTER 12.zip 521.5 KB
6. SORTING/1.1 CHAPTER 5.zip 465.2 KB
15. BONUS VIDEOS/1.1 CHAPTER 14.zip 332.1 KB
1. Chapter 1/9. BONUS EXCEL RESOURCE BLOG.pdf 278.6 KB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/1.1 New Excel 2016 New Feature.zip.zip 278.3 KB
1. Chapter 1/3.1 Xtreme Pivot Table Course Outline.xlsx.xlsx 63.2 KB
18. BONUS THE MYEXCELONLINE ACADEMY!/1.1 Academy Course Upgrade COUPON.pdf.pdf 61.6 KB
10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.vtt 16.7 KB
15. BONUS VIDEOS/7. Interactive Balance Sheet Pivot Table.vtt 12.1 KB
8. SLICERS (NEW IN EXCEL 2010)/12. TIP Interactive employee photos with Slicers! FUN!.vtt 9.5 KB
9. CALCULATED FIELDS & ITEMS/16. CASE STUDY ~ ACCOUNTING Creating a P&L Pivot Table Report.vtt 9.2 KB
10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.vtt 8.5 KB
10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.vtt 7.9 KB
12. GETPIVOTDATA Formula/8. CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.vtt 7.6 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/9. Std Dev.vtt 7.4 KB
5. GROUPING/17. CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.vtt 7.2 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.vtt 7.0 KB
7. FILTERING/2. Filter by Dates.vtt 7.0 KB
9. CALCULATED FIELDS & ITEMS/17. CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.vtt 6.9 KB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/6. Data Models.vtt 6.6 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).vtt 6.4 KB
10. PIVOT CHARTS/6. Pivot Chart Formats.vtt 6.3 KB
5. GROUPING/12. TIP Group by fiscal years & quarters.vtt 6.1 KB
8. SLICERS (NEW IN EXCEL 2010)/4. Creating a custom style.vtt 5.8 KB
12. GETPIVOTDATA Formula/3. Create a custom report with GETPIVOTDATA.vtt 5.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/9. CREATING A PIVOT TABLE ~ Field List & Areas.vtt 5.6 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/13. TIP See all pivot Items.vtt 5.5 KB
12. GETPIVOTDATA Formula/2. Intro to GETPIVOTDATA.vtt 5.5 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/17. OPTIONS DATA ~ Refresh External Data.vtt 5.5 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/18. CASE STUDY ~ FINANCIAL Actual v Plan Variance Report.vtt 5.4 KB
12. GETPIVOTDATA Formula/9. CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.vtt 5.4 KB
8. SLICERS (NEW IN EXCEL 2010)/14. CASE STUDY ~ FINANCIAL Base, Best & Worst case Forecast.vtt 5.3 KB
8. SLICERS (NEW IN EXCEL 2010)/6. Slicer Settings.vtt 5.3 KB
15. BONUS VIDEOS/3. Consolidate with a Pivot Table.vtt 5.1 KB
15. BONUS VIDEOS/8. Monthly Sales Manager Performance Report.vtt 5.0 KB
5. GROUPING/18. CASE STUDY ~ FINANCIAL Min & Max Bank Balance.vtt 4.8 KB
13. MACROS & PIVOT TABLES/3. Record a simple macro to Refresh a pivot table.vtt 4.8 KB
13. MACROS & PIVOT TABLES/5. Different pivot table views macro.vtt 4.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/31. OPTIONS SHOW ~ Expand & Collapse buttons.vtt 4.5 KB
8. SLICERS (NEW IN EXCEL 2010)/13. CASE STUDY ~ ACCOUNTING Select a Monthly P&L report with a Slicer.vtt 4.3 KB
7. FILTERING/5. Filter by Values.vtt 4.3 KB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/5. Timelime Slicers.vtt 4.2 KB
8. SLICERS (NEW IN EXCEL 2010)/2. Insert a Slicer.vtt 4.2 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/9. Difference From.vtt 4.2 KB
15. BONUS VIDEOS/2. Sales Forecasting with Calculated Fields.vtt 4.2 KB
13. MACROS & PIVOT TABLES/4. Date filter macro.vtt 4.1 KB
9. CALCULATED FIELDS & ITEMS/2. Creating a Calculated Field.vtt 4.1 KB
9. CALCULATED FIELDS & ITEMS/6. Creating a Calculated Item.vtt 4.1 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/24. DESIGN STYLES ~ Customising a Pivot Table Style.vtt 4.0 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/10. % Difference From.vtt 4.0 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.vtt 3.9 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.vtt 3.8 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/7. CREATING A PIVOT TABLE ~ Inserting a Pivot Table.vtt 3.7 KB
5. GROUPING/14. TIP Group two pivot tables independently.vtt 3.7 KB
9. CALCULATED FIELDS & ITEMS/12. TIP Solve Order for Calculated Items.vtt 3.7 KB
10. PIVOT CHARTS/4. Pivot Chart Designs.vtt 3.6 KB
10. PIVOT CHARTS/5. Pivot Chart Layouts.vtt 3.6 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.vtt 3.6 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/5. % Of.vtt 3.6 KB
7. FILTERING/9. Filter by Report Filter.vtt 3.6 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/7. Product.vtt 3.5 KB
8. SLICERS (NEW IN EXCEL 2010)/8. Slicer Connections for multiple pivot tables.vtt 3.4 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/23. DESIGN STYLES ~ Pivot Table Styles.vtt 3.4 KB
10. PIVOT CHARTS/2. Insert a Pivot Chart.vtt 3.4 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/15. Index.vtt 3.3 KB
12. GETPIVOTDATA Formula/4. Reference Dates with GETPIVOTDATA.vtt 3.3 KB
6. SORTING/5. Sort using a Custom List.vtt 3.2 KB
13. MACROS & PIVOT TABLES/6. Top 10 macro.vtt 3.2 KB
5. GROUPING/5. Group by Sales ranges.vtt 3.2 KB
7. FILTERING/12. TIP Filter by Text wildcards and .vtt 3.1 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/10. Varp.vtt 3.1 KB
12. GETPIVOTDATA Formula/7. TIP Grand Totals to the left of the pivot table.vtt 3.0 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/19. OPTIONS DATA ~ Change Data Source.vtt 3.0 KB
15. BONUS VIDEOS/5. Break Even Model.vtt 3.0 KB
5. GROUPING/13. TIP Errors when grouping by dates.vtt 3.0 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/5. ARRANGING YOUR DATA SET ~ Tables.vtt 2.9 KB
9. CALCULATED FIELDS & ITEMS/5. Excel formulas & Calculated Fields.vtt 2.9 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/6. % of Parent Row Total (NEW IN EXCEL 2010).vtt 2.9 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.vtt 2.9 KB
14. DATA MANAGEMENT/7. Sharing a Pivot Table via OneDrive.vtt 2.9 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/14. TIP Show a unique count.vtt 2.8 KB
8. SLICERS (NEW IN EXCEL 2010)/7. Slicer Size & Properties.vtt 2.8 KB
5. GROUPING/2. Group by Date.vtt 2.7 KB
10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.vtt 2.7 KB
7. FILTERING/4. Filter by Labels - Numerical Text.vtt 2.7 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/21. OPTIONS ACTIONS ~ Select & format.vtt 2.7 KB
13. MACROS & PIVOT TABLES/2. Adding the Developer tab & disabling macros.vtt 2.7 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/12. % Running Total in (NEW IN EXCEL 2010).vtt 2.7 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/32. OPTIONS SHOW ~ Move & Remove Fields and Items.vtt 2.6 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.vtt 2.6 KB
7. FILTERING/3. Filter by Labels - Text.vtt 2.6 KB
10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.vtt 2.6 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/8. % of Parent Total (NEW IN EXCEL 2010).vtt 2.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/3. ARRANGING YOUR DATA SET ~ No Gaps.vtt 2.6 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/17. CASE STUDY ~ ACCOUNTING % of Revenue Margins.vtt 2.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/6. ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set.vtt 2.5 KB
9. CALCULATED FIELDS & ITEMS/3. Use an existing Calculated Field in a new calculation.vtt 2.5 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/3. Count.vtt 2.5 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.vtt 2.5 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/11. TIP Show various Grand Totals.vtt 2.4 KB
12. GETPIVOTDATA Formula/5. Data validation with GETPIVOTDATA.vtt 2.4 KB
7. FILTERING/20. CASE STUDY ~ FINANCIAL Top 25% of Channel Partners.vtt 2.4 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/28. DESIGN LAYOUT ~ Report Layouts.vtt 2.4 KB
7. FILTERING/19. CASE STUDY ~ ACCOUNTING Top 5 Expenses report.vtt 2.4 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/2. ARRANGING YOUR DATA SET ~ Tabular Format.vtt 2.4 KB
9. CALCULATED FIELDS & ITEMS/8. Editing a Calculated Item.vtt 2.4 KB
14. DATA MANAGEMENT/5. Reducing file memory by keeping data source in MS Access.vtt 2.4 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/47. LAYOUT & FORMAT ~ TIPShow report filter on multiple pages.vtt 2.4 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/4. Average.vtt 2.4 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/37. CUSTOMISATION ~ Field name formatting.vtt 2.4 KB
8. SLICERS (NEW IN EXCEL 2010)/3. Slicer Styles.vtt 2.4 KB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/2. Cosmetic changes in the PivotTable Tools Ribbon Menu.vtt 2.4 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/12. TIP Shortcuts to Field & Value Field Settings.vtt 2.3 KB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/3. Recommended Pivot Tables.vtt 2.3 KB
7. FILTERING/6. Filter by Values - Top or Bottom 10 Items.vtt 2.2 KB
15. BONUS VIDEOS/4. Frequency distribution with a Pivot Table.vtt 2.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/18. OPTIONS DATA ~ Import from Access database.vtt 2.2 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/7. % of Parent Column Total (NEW IN EXCEL 2010).vtt 2.1 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/14. Rank Largest to Smallest (NEW IN EXCEL 2010).vtt 2.1 KB
9. CALCULATED FIELDS & ITEMS/4. Editing a Calculated Field.vtt 2.1 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/16. OPTIONS DATA ~ Refresh All.vtt 2.1 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/11. Running Total in.vtt 2.1 KB
9. CALCULATED FIELDS & ITEMS/10. Calculated Item on Column Labels.vtt 2.1 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/13. Rank Smallest to Largest (NEW IN EXCEL 2010).vtt 2.0 KB
9. CALCULATED FIELDS & ITEMS/15. TIP Order of operations.vtt 2.0 KB
7. FILTERING/16. TIP Include new items in manual filter.vtt 2.0 KB
5. GROUPING/10. TIP Group by a Date that starts on a Monday.vtt 2.0 KB
5. GROUPING/6. Group by Text fields.vtt 2.0 KB
10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.vtt 2.0 KB
15. BONUS VIDEOS/9. Reconciling customer payments.vtt 2.0 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/5. Maximum.vtt 1.9 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/8. Count Numbers.vtt 1.9 KB
9. CALCULATED FIELDS & ITEMS/11. Shortcomings of Calculated Items.vtt 1.9 KB
15. BONUS VIDEOS/6. Several Slicer custom styles for you to use.vtt 1.9 KB
18. BONUS THE MYEXCELONLINE ACADEMY!/2. THANK YOU!.vtt 1.9 KB
6. SORTING/4. Sort manually (drag, write, right click).vtt 1.9 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/3. % of Column Total.vtt 1.8 KB
7. FILTERING/7. Filter by Values - Top or Bottom %.vtt 1.8 KB
5. GROUPING/3. Group by Months.vtt 1.8 KB
7. FILTERING/17. TIP Clear filters with one click.vtt 1.8 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.vtt 1.8 KB
5. GROUPING/4. Group by Quarters & Years.vtt 1.8 KB
10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.vtt 1.8 KB
5. GROUPING/11. TIP Grouping by a custom date.vtt 1.8 KB
7. FILTERING/14. TIP Apply multiple filters.vtt 1.7 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/8. CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout.vtt 1.7 KB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/2. Group Periods.vtt 1.7 KB
6. SORTING/2. Sorting by Largest or Smallest.vtt 1.7 KB
14. DATA MANAGEMENT/3. Reducing file memory by deleting the data source.vtt 1.7 KB
5. GROUPING/9. TIP Grouping by Half Years.vtt 1.7 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.vtt 1.7 KB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/5. 3D Maps.vtt 1.6 KB
12. GETPIVOTDATA Formula/6. Shortfalls of GETPIVOTDATA.vtt 1.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/36. CUSTOMISATION ~ Number formatting.vtt 1.6 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/2. % of Grand Total.vtt 1.6 KB
7. FILTERING/10. TIP Shortcuts to filters.vtt 1.6 KB
10. PIVOT CHARTS/8. Saving a Pivot Chart template.vtt 1.6 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/4. ARRANGING YOUR DATA SET ~ Formatting.vtt 1.6 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/2. Create multiple subtotals.vtt 1.6 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.vtt 1.6 KB
5. GROUPING/7. Group by Time.vtt 1.6 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.vtt 1.5 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/10. CREATING A PIVOT TABLE ~ Drill down to audit.vtt 1.5 KB
7. FILTERING/8. Filter by Values - Top or Bottom Sum.vtt 1.5 KB
6. SORTING/6. Override a Custom List sort.vtt 1.5 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/4. % of Row Total.vtt 1.5 KB
8. SLICERS (NEW IN EXCEL 2010)/11. TIP Lock the workbook but not the slicer.vtt 1.5 KB
10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.vtt 1.5 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.vtt 1.5 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.vtt 1.5 KB
10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.vtt 1.4 KB
18. BONUS THE MYEXCELONLINE ACADEMY!/1. The MyExcelOnline Academy Online Course.vtt 1.4 KB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/4. Distinct Count.vtt 1.4 KB
8. SLICERS (NEW IN EXCEL 2010)/5. Copy a custom style into a new workbook.vtt 1.4 KB
9. CALCULATED FIELDS & ITEMS/9. Excel formulas & Calculated Items.vtt 1.4 KB
5. GROUPING/8. TIP Shortcuts to Grouping.vtt 1.4 KB
14. DATA MANAGEMENT/2. Reducing file memory by copying existing pivot table.vtt 1.4 KB
9. CALCULATED FIELDS & ITEMS/7. Use an existing Calculated Item in a new calculation.vtt 1.4 KB
10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.vtt 1.3 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.vtt 1.3 KB
13. MACROS & PIVOT TABLES/7. Add macro to quick access toolbar.vtt 1.3 KB
8. SLICERS (NEW IN EXCEL 2010)/10. TIP Use one slicer for two pivot tables.vtt 1.3 KB
14. DATA MANAGEMENT/6. Compatibility Issues with Excel 2007 and Excel 2010.vtt 1.3 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/41. LAYOUT & FORMAT ~ Change the layout of a report filter.vtt 1.3 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/25. DESIGN STYLES ~ Use a customised style in another workbook.vtt 1.3 KB
6. SORTING/8. TIP Sort new items added to your data source.vtt 1.3 KB
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/6. Minimum.vtt 1.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/38. CUSTOMISATION ~ TIP Predetermined number formatting.vtt 1.2 KB
10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.vtt 1.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/43. LAYOUT & FORMAT ~ Format empty cells.vtt 1.2 KB
8. SLICERS (NEW IN EXCEL 2010)/9. TIP Different ways to filter a Slicer.vtt 1.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/46. LAYOUT & FORMAT ~ TIP Printing a pivot table on two pages.vtt 1.2 KB
1. Chapter 1/8. BONUS #6 MY EXCEL PODCAST SHOW.html 1.2 KB
11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.vtt 1.2 KB
9. CALCULATED FIELDS & ITEMS/13. TIP List Calculated Field & Item formulas.vtt 1.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/35. CUSTOMISATION ~ Change Count of to Sum of.vtt 1.2 KB
6. SORTING/3. Sort an Item Row (Left to Right).vtt 1.2 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/15. OPTIONS DATA ~ Refresh.vtt 1.1 KB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/4. Pivot Chart - Expand and Collapse fields.vtt 1.1 KB
10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.vtt 1.1 KB
1. Chapter 1/1. INTRODUCTION.vtt 1.1 KB
7. FILTERING/15. TIP Filter by multiple values.vtt 1.1 KB
7. FILTERING/13. TIP Filter by multiple fields.vtt 1.1 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/30. DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout.vtt 1.0 KB
4. VALUE FIELD SETTINGS SHOW VALUES AS/16. TIP Shortcuts to Show Values As.vtt 1.0 KB
10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.vtt 1.0 KB
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/14. OPTIONS DATA ~ Pivot Cache explained.vtt 979 bytes
6. SORTING/7. Sort row from A-Z and sales from Z-A.vtt 932 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/13. CREATING A PIVOT TABLE ~ TIP Defer Layout Update.vtt 930 bytes
5. GROUPING/16. TIP Display dates that have no data.vtt 920 bytes
1. Chapter 1/2. EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ).html 914 bytes
9. CALCULATED FIELDS & ITEMS/14. TIP Remove a Calculated Field temporarily.vtt 889 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/20. OPTIONS ACTIONS ~ Clear Filters & Clear Pivot.vtt 887 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/39. CUSTOMISATION ~ TIP Change Sum views in Label areas.vtt 859 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/22. OPTIONS ACTIONS ~ Move a Pivot Table.vtt 856 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/45. LAYOUT & FORMAT ~ TIP Automatic Refresh a Pivot Table.vtt 839 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/44. LAYOUT & FORMAT ~ Keep column widths upon refresh.vtt 835 bytes
14. DATA MANAGEMENT/4. Reducing file memory by saving file as Excel Binary Workbook.vtt 822 bytes
11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.vtt 815 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/12. CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields.vtt 815 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/27. DESIGN LAYOUT ~ Grand Totals.vtt 798 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/40. LAYOUT & FORMAT ~ Indent rows in compact layout.vtt 784 bytes
10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.vtt 782 bytes
7. FILTERING/11. TIP Keep or hide selected items.vtt 773 bytes
[DesireCourse.Com].txt 754 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/26. DESIGN LAYOUT ~ Subtotals.vtt 729 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/42. LAYOUT & FORMAT ~ Format error values.vtt 714 bytes
10. PIVOT CHARTS/11. TIP Copying a second chart.vtt 703 bytes
5. GROUPING/15. TIP Fixing the problem of counting grouped sales.vtt 670 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/11. CREATING A PIVOT TABLE ~ Sort Field List from A to Z.vtt 598 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/29. DESIGN LAYOUT ~ Blank Rows.vtt 583 bytes
10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.vtt 569 bytes
7. FILTERING/18. TIP Add a filter for the column items.vtt 567 bytes
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/3. Multi-Select Slicer items.vtt 525 bytes
1. Chapter 1/7. BONUS #5 EXCEL RESOURCE BLOG.html 474 bytes
1. Chapter 1/3. BONUS #1 COURSE TRACKER EXCEL WORKBOOK.html 431 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/34. OPTIONS SHOW ~ ShowHide Field Headers.vtt 358 bytes
6. SORTING/9. TIP Clear a sort.vtt 352 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/33. OPTIONS SHOW ~ ShowHide Field List.vtt 286 bytes
1. Chapter 1/6. BONUS #4 50+ EXCEL KEYBOARD SHORTCUTS (IN KEYBOARD LAYOUT).html 266 bytes
6. SORTING/10. TIP Sort Largest to Smallest Grand Totals.vtt 205 bytes
10. PIVOT CHARTS/23. State the button to format a Pivot Chart.html 135 bytes
11. CONDITIONAL FORMATTING PIVOT TABLES/19. Recognize the option that conditionally formats all values except the Subtotals.html 135 bytes
12. GETPIVOTDATA Formula/10. Define when to use the GETPIVOTDATA function.html 135 bytes
13. MACROS & PIVOT TABLES/8. Recall how to assign a macro.html 135 bytes
14. DATA MANAGEMENT/8. List the ways to reduce the memory size of an Excel file.html 135 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/48. Recognize which button is used to update a Pivot Table.html 135 bytes
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/15. Recall the way to change a Count Of to a Sum Of.html 135 bytes
4. VALUE FIELD SETTINGS SHOW VALUES AS/19. Identify the steps to showing the values as a Year to Date accumulation.html 135 bytes
5. GROUPING/19. State which command is used to group a PivotTable report by weeks.html 135 bytes
6. SORTING/11. Identify the steps to creating a Custom List.html 135 bytes
7. FILTERING/21. Recall the command to search for a wildcard entry.html 135 bytes
8. SLICERS (NEW IN EXCEL 2010)/15. Identify the steps for customizing a Slicer.html 135 bytes
9. CALCULATED FIELDS & ITEMS/18. State the steps to creating a Calculated Item.html 135 bytes
18. BONUS THE MYEXCELONLINE ACADEMY!/1.2 The MyExcelOnline Academy Online Course.html 102 bytes
14. DATA MANAGEMENT/1. WORKBOOKS.html 80 bytes
10. PIVOT CHARTS/1. WORKBOOKS.html 76 bytes
11. CONDITIONAL FORMATTING PIVOT TABLES/1. WORKBOOKS.html 76 bytes
12. GETPIVOTDATA Formula/1. WORKBOOKS.html 76 bytes
13. MACROS & PIVOT TABLES/1. WORKBOOKS.html 76 bytes
15. BONUS VIDEOS/1. WORKBOOKS.html 76 bytes
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/1. WORKBOOKS.html 76 bytes
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/1. WORKBOOKS.html 76 bytes
3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/1. WORKBOOKS.html 76 bytes
4. VALUE FIELD SETTINGS SHOW VALUES AS/1. WORKBOOKS.html 76 bytes
5. GROUPING/1. WORKBOOKS.html 76 bytes
6. SORTING/1. WORKBOOKS.html 76 bytes
7. FILTERING/1. WORKBOOKS.html 76 bytes
8. SLICERS (NEW IN EXCEL 2010)/1. WORKBOOKS.html 76 bytes
9. CALCULATED FIELDS & ITEMS/1. WORKBOOKS.html 76 bytes
2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/1. WORKBOOKS.html 73 bytes
[DesireCourse.Com].url 51 bytes
1. Chapter 1/5. BONUS #3 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE INFORGRAPHIC.html 24 bytes

[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course

File List

Download Torrent

Related Resources

Copyright Infringement