[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course - 2048BT - 全球最新最全bt种子资源在线搜索库，实时索引全球磁力链接资源

BT种子名称

分享给好友

BT种子基本信息

种子哈希：6c6241888fecf181e290306744ced45d259ea548
文档大小：1.5 GB
文档个数：516个文档
下载次数：2456次
下载速度：极快
收录时间：2020-02-17
最近下载：2024-09-25
DMCA/屏蔽：DMCA/屏蔽

下载磁力链接

magnet:?xt=urn:btih:6C6241888FECF181E290306744CED45D259EA548
复制磁力链接到utorrent、Bitcomet、迅雷、115、百度网盘、PIKPAK等下载工具进行下载。

下载BT种子

磁力链接种子下载迅雷下载二维码含羞草 51品茶 91视频逼哩逼哩欲漫涩草榴社区抖阴破解版成人快手暗网禁区缅北禁地 TikTok成人版暗网解密

[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course的二维码

文档列表

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

==查看完整文档列表==

上一个：TVBOXNOW 花樣爺爺 IV1.0 GB
下一个：Lindemann - 2019 - Steh auf (Single) [FLAC] 46.9 MB

种子标签

种子评价

优质的种子 (0) 假种子 (0) 有密码 (0) 低质量 (0) 有病毒 (0) 无法下载 (0)
欢迎对种子质量进行评价。

人气女优

北川ゆい Akira COCOLO Saiko あいだももあさのくるみあまいれもんいしかわ愛里いとうしいなうさみ恭香うちだまひろかぐやひめかとりこのみかないかほくすのき琴美クミコグレースくらもとまい（葉月ありさ）さとみ中村あみしいな純菜しのざきさとみ（三沢亜也）牧本千幸（つかもと友希）眞木ありさデヴィテラパトリックドミニカともさかまいともさか愛なごみもえひなこ

分享BT种子/磁力链接

亲，你知道吗？下载的人越多速度越快，赶快把本页面分享给好友一起下载吧^_^

2048BT

BT种子名称

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

分享给好友

BT种子基本信息

下载磁力链接

下载BT种子

文档列表

猜你喜欢

种子标签

种子评价

最近搜索

人气女优

最新番号

分享BT种子/磁力链接

友情链接