DesireCourse Com Udemy Microsoft Excel The Xtreme Excel Pivot Tables Course

DesireCourse Com Udemy Microsoft Excel The Xtreme Excel Pivot Tables Course

Name	[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course	DOWNLOAD Copy Link
Total Size	1.5 GB
Total Files	516
Hash	6C6241888FECF181E290306744CED45D259EA548

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