Download link
File List
-
09 PIVOT CHARTS/021 CASE STUDY FINANCIAL Pivot Table Slicer Chart Dashboard.mp4 67.81 MB
08 CALCULATED FIELDS ITEMS/015 CASE STUDY ACCOUNTING Creating a PL Pivot Table Report.mp4 58.6 MB
08 CALCULATED FIELDS ITEMS/016 CASE STUDY FINANCIAL Actuals v Plan with Calculated Fields.mp4 50.99 MB
14 BONUS VIDEOS/006 Interactive Balance Sheet Pivot Table.mp4 47.83 MB
09 PIVOT CHARTS/020 CASE STUDY ACCOUNTING PL Pivot Table report with Graphs.mp4 38.49 MB
04 GROUPING/016 CASE STUDY ACCOUNTING Quarterly Comparative Report.mp4 37.65 MB
07 SLICERS NEW IN EXCEL 2010/011 TIP Interactive employee photos with Slicers FUN.mp4 31.08 MB
11 GETPIVOTDATA Formula/007 CASE STUDY ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 31.02 MB
09 PIVOT CHARTS/018 TIP Change Chart Type with Slicers FUN.mp4 28.79 MB
14 BONUS VIDEOS/007 Monthly Sales Manager Performance Report.mp4 27.67 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/016 CASE STUDY ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 27.31 MB
06 FILTERING/001 Filter by Dates.mp4 25.11 MB
11 GETPIVOTDATA Formula/008 CASE STUDY FINANCIAL Channel Analysis with GETPIVOTDATA.mp4 24.99 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/008 Std Dev.mp4 24.78 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/008 Difference From.mp4 24.2 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/006 Data Bars, Color Scales Icon Sets NEW IN EXCEL 2010.mp4 24.18 MB
01 CUSTOMIZING YOUR PIVOT TABLE/030 OPTIONS SHOW Expand Collapse buttons.mp4 23.94 MB
01 CUSTOMIZING YOUR PIVOT TABLE/023 DESIGN STYLES Customising a Pivot Table Style.mp4 23.18 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/017 CASE STUDY FINANCIAL Actual v Plan Variance Report.mp4 23.1 MB
07 SLICERS NEW IN EXCEL 2010/003 Creating a custom style.mp4 22.9 MB
07 SLICERS NEW IN EXCEL 2010/013 CASE STUDY FINANCIAL Base, Best Worst case Forecast.mp4 22.65 MB
01 CUSTOMIZING YOUR PIVOT TABLE/022 DESIGN STYLES Pivot Table Styles.mp4 22.5 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/014 Show text in the Pivot Table Values area.mp4 22.3 MB
14 BONUS VIDEOS/002 Consolidate with a Pivot Table.mp4 22.14 MB
11 GETPIVOTDATA Formula/001 Intro to GETPIVOTDATA.mp4 22.06 MB
07 SLICERS NEW IN EXCEL 2010/005 Slicer Settings.mp4 21.98 MB
01 CUSTOMIZING YOUR PIVOT TABLE/016 OPTIONS DATA Refresh External Data.mp4 21.4 MB
08 CALCULATED FIELDS ITEMS/011 TIP Solve Order for Calculated Items.mp4 21.37 MB
14 BONUS VIDEOS/001 Sales Forecasting with Calculated Fields.mp4 21.27 MB
04 GROUPING/011 TIP Group by fiscal years quarters.mp4 20.95 MB
07 SLICERS NEW IN EXCEL 2010/012 CASE STUDY ACCOUNTING Select a Monthly PL report with a Slicer.mp4 20.95 MB
09 PIVOT CHARTS/004 Pivot Chart Layouts.mp4 20.35 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/012 TIP See all pivot Items.mp4 20.2 MB
04 GROUPING/017 CASE STUDY FINANCIAL Min Max Bank Balance.mp4 20.14 MB
09 PIVOT CHARTS/005 Pivot Chart Formats.mp4 20.07 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/009 Difference From.mp4 20.05 MB
01 CUSTOMIZING YOUR PIVOT TABLE/008 CREATING A PIVOT TABLE Field List Areas.mp4 19.24 MB
01 CUSTOMIZING YOUR PIVOT TABLE/020 OPTIONS ACTIONS Select format.mp4 19.1 MB
01 CUSTOMIZING YOUR PIVOT TABLE/018 OPTIONS DATA Change Data Source.mp4 19.1 MB
12 MACROS PIVOT TABLES/004 Different pivot table views macro.mp4 19.08 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/004 Of.mp4 18.49 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/009 Varp.mp4 18.3 MB
08 CALCULATED FIELDS ITEMS/005 Creating a Calculated Item.mp4 17.67 MB
12 MACROS PIVOT TABLES/002 Record a simple macro to Refresh a pivot table.mp4 17.51 MB
08 CALCULATED FIELDS ITEMS/001 Creating a Calculated Field.mp4 17.09 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/005 Top Bottom Rules.mp4 17.07 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/003 Average.mp4 16.86 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/007 of Parent Total NEW IN EXCEL 2010.mp4 16.57 MB
01 CUSTOMIZING YOUR PIVOT TABLE/004 ARRANGING YOUR DATA SET Tables.mp4 15.78 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/017 CASE STUDY FINANCIAL Conditionally Format your sales results.mp4 15.55 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/014 Index.mp4 15.34 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/002 Count.mp4 15.08 MB
12 MACROS PIVOT TABLES/003 Date filter macro.mp4 15.07 MB
09 PIVOT CHARTS/003 Pivot Chart Designs.mp4 15.04 MB
04 GROUPING/001 Group by Date.mp4 14.65 MB
06 FILTERING/008 Filter by Report Filter.mp4 14.18 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/013 TIP Show a unique count.mp4 14.09 MB
08 CALCULATED FIELDS ITEMS/004 Excel formulas Calculated Fields.mp4 13.99 MB
01 CUSTOMIZING YOUR PIVOT TABLE/027 DESIGN LAYOUT Report Layouts.mp4 13.9 MB
04 GROUPING/004 Group by Sales ranges.mp4 13.89 MB
07 SLICERS NEW IN EXCEL 2010/001 Insert a Slicer.mp4 13.79 MB
08 CALCULATED FIELDS ITEMS/007 Editing a Calculated Item.mp4 13.79 MB
07 SLICERS NEW IN EXCEL 2010/007 Slicer Connections for multiple pivot tables.mp4 13.76 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/001 Intro to Conditional Formatting.mp4 13.75 MB
11 GETPIVOTDATA Formula/006 TIP Grand Totals to the left of the pivot table.mp4 13.42 MB
08 CALCULATED FIELDS ITEMS/002 Use an existing Calculated Field in a new calculation.mp4 12.79 MB
08 CALCULATED FIELDS ITEMS/003 Editing a Calculated Field.mp4 12.77 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/010 TIP Show various Grand Totals.mp4 12.76 MB
01 CUSTOMIZING YOUR PIVOT TABLE/046 LAYOUT FORMAT TIPShow report filter on multiple pages.mp4 12.74 MB
11 GETPIVOTDATA Formula/004 Data validation with GETPIVOTDATA.mp4 12.68 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/001 of Grand Total.mp4 12.48 MB
06 FILTERING/011 TIP Filter by Text wildcards and .mp4 12.39 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/006 Product.mp4 12.25 MB
13 DATA MANAGEMENT/002 Reducing file memory by deleting the data source.mp4 12.23 MB
09 PIVOT CHARTS/001 Insert a Pivot Chart.mp4 12.12 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/006 of Parent Column Total NEW IN EXCEL 2010.mp4 11.88 MB
04 GROUPING/012 TIP Errors when grouping by dates.mp4 11.7 MB
01 CUSTOMIZING YOUR PIVOT TABLE/031 OPTIONS SHOW Move Remove Fields and Items.mp4 11.67 MB
05 SORTING/004 Sort using a Custom List.mp4 11.65 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/011 Running Total in NEW IN EXCEL 2010.mp4 11.61 MB
01 CUSTOMIZING YOUR PIVOT TABLE/017 OPTIONS DATA Import from Access database.mp4 11.57 MB
12 MACROS PIVOT TABLES/005 Top 10 macro.mp4 11.4 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/002 of Column Total.mp4 11.31 MB
08 CALCULATED FIELDS ITEMS/009 Calculated Item on Column Labels.mp4 11.2 MB
01 CUSTOMIZING YOUR PIVOT TABLE/009 CREATING A PIVOT TABLE Drill down to audit.mp4 11.11 MB
06 FILTERING/003 Filter by Labels - Numerical Text.mp4 11.11 MB
11 GETPIVOTDATA Formula/003 Reference Dates with GETPIVOTDATA.mp4 11.04 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/011 TIP Shortcuts to Field Value Field Settings.mp4 11.01 MB
09 PIVOT CHARTS/019 TIP Workaround to creating an interactive Scatter graph.mp4 10.73 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/016 CASE STUDY ACCOUNTING of Revenue Margins.mp4 10.65 MB
07 SLICERS NEW IN EXCEL 2010/006 Slicer Size Properties.mp4 10.64 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/004 Maximum.mp4 10.62 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/010 Running Total in.mp4 10.53 MB
04 GROUPING/010 TIP Grouping by a custom date.mp4 10.49 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/013 Control Conditional Formatting with Slicers.mp4 10.47 MB
13 DATA MANAGEMENT/004 Reducing file memory by keeping data source in MS Access.mp4 10.37 MB
09 PIVOT CHARTS/017 TIP Charts Dos Donts.mp4 10.14 MB
07 SLICERS NEW IN EXCEL 2010/002 Slicer Styles.mp4 10.05 MB
14 BONUS VIDEOS/003 Frequency distribution with a Pivot Table.mp4 10.02 MB
06 FILTERING/019 CASE STUDY FINANCIAL Top 25 of Channel Partners.mp4 9.96 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/013 Rank Largest to Smallest NEW IN EXCEL 2010.mp4 9.91 MB
01 CUSTOMIZING YOUR PIVOT TABLE/005 ARRANGING YOUR DATA SET TIP Clean Your Data Set.mp4 9.9 MB
01 CUSTOMIZING YOUR PIVOT TABLE/015 OPTIONS DATA Refresh All.mp4 9.84 MB
08 CALCULATED FIELDS ITEMS/008 Excel formulas Calculated Items.mp4 9.76 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/003 of Row Total.mp4 9.75 MB
06 FILTERING/002 Filter by Labels - Text.mp4 9.73 MB
01 CUSTOMIZING YOUR PIVOT TABLE/036 CUSTOMISATION Field name formatting.mp4 9.57 MB
06 FILTERING/018 CASE STUDY ACCOUNTING Top 5 Expenses report.mp4 9.47 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/010 TIP Use a formula to determine which cells to format.mp4 9.45 MB
14 BONUS VIDEOS/004 Break Even Model.mp4 9.42 MB
13 DATA MANAGEMENT/001 Reducing file memory by copying existing pivot table.mp4 8.75 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/011 Use selected cells to format multiple fields.mp4 8.73 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/008 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 8.6 MB
13 DATA MANAGEMENT/006 Sharing a Pivot Table via OneDrive.mp4 8.57 MB
08 CALCULATED FIELDS ITEMS/006 Use an existing Calculated Item in a new calculation.mp4 8.57 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/012 Rank Smallest to Largest NEW IN EXCEL 2010.mp4 8.38 MB
08 CALCULATED FIELDS ITEMS/010 Shortcomings of Calculated Items.mp4 8.34 MB
04 GROUPING/002 Group by Months.mp4 8.32 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 Create multiple subtotals.mp4 8.29 MB
09 PIVOT CHARTS/006 Limitations of Pivot Charts workarounds.mp4 8.2 MB
06 FILTERING/005 Filter by Values - Top or Bottom 10 Items.mp4 8.12 MB
06 FILTERING/015 TIP Include new items in manual filter.mp4 8.08 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/007 Count Numbers.mp4 8.07 MB
04 GROUPING/009 TIP Group by a Date that starts on a Monday.mp4 7.73 MB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/005 Minimum.mp4 7.68 MB
06 FILTERING/006 Filter by Values - Top or Bottom .mp4 7.65 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/012 All cells showing values to format multiple fields.mp4 7.58 MB
01 CUSTOMIZING YOUR PIVOT TABLE/035 CUSTOMISATION Number formatting.mp4 7.49 MB
01 CUSTOMIZING YOUR PIVOT TABLE/024 DESIGN STYLES Use a customised style in another workbook.mp4 7.44 MB
09 PIVOT CHARTS/002 Insert a Slicer with a Pivot Chart.mp4 7.42 MB
06 FILTERING/013 TIP Apply multiple filters.mp4 7.4 MB
05 SORTING/003 Sort manually drag, write, right click.mp4 7.35 MB
04 GROUPING/013 TIP Group two pivot tables independently.mp4 7.34 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/007 TIP Format only cells that contain - For Bonuses.mp4 7.3 MB
04 GROUPING/003 Group by Quarters Years.mp4 7.22 MB
05 SORTING/001 Sorting by Largest or Smallest.mp4 7.14 MB
12 MACROS PIVOT TABLES/006 Add macro to quick access toolbar.mp4 7.14 MB
06 FILTERING/009 TIP Shortcuts to filters.mp4 7.1 MB
01 CUSTOMIZING YOUR PIVOT TABLE/042 LAYOUT FORMAT Format empty cells.mp4 7 MB
07 SLICERS NEW IN EXCEL 2010/010 TIP Lock the workbook but not the slicer.mp4 6.92 MB
07 SLICERS NEW IN EXCEL 2010/004 Copy a custom style into a new workbook.mp4 6.89 MB
14 BONUS VIDEOS/005 Several Slicer custom styles for you to use.mp4 6.87 MB
04 GROUPING/006 Group by Time.mp4 6.74 MB
01 CUSTOMIZING YOUR PIVOT TABLE/003 ARRANGING YOUR DATA SET Formatting.mp4 6.72 MB
04 GROUPING/005 Group by Text fields.mp4 6.71 MB
06 FILTERING/007 Filter by Values - Top or Bottom Sum.mp4 6.63 MB
07 SLICERS NEW IN EXCEL 2010/009 TIP Use one slicer for two pivot tables.mp4 6.58 MB
01 CUSTOMIZING YOUR PIVOT TABLE/007 CREATING A PIVOT TABLE Field List - Activate, move, resize layout.mp4 6.56 MB
14 BONUS VIDEOS/008 Reconciling customer payments.mp4 6.45 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/002 Highlight Cell Rules based on values.mp4 6.45 MB
09 PIVOT CHARTS/007 Saving a Pivot Chart template.mp4 6.41 MB
06 FILTERING/016 TIP Clear filters with one click.mp4 6.37 MB
04 GROUPING/015 TIP Display dates that have no data.mp4 6.36 MB
05 SORTING/002 Sort an Item Row Left to Right.mp4 6.27 MB
13 DATA MANAGEMENT/003 Reducing file memory by saving file as Excel Binary Workbook.mp4 6.27 MB
01 CUSTOMIZING YOUR PIVOT TABLE/045 LAYOUT FORMAT TIP Printing a pivot table on two pages.mp4 6.14 MB
11 GETPIVOTDATA Formula/005 Shortfalls of GETPIVOTDATA.mp4 6.03 MB
01 CUSTOMIZING YOUR PIVOT TABLE/040 LAYOUT FORMAT Change the layout of a report filter.mp4 6.02 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/009 TIP Format values that are above or below the average - For Promotions.mp4 5.91 MB
09 PIVOT CHARTS/015 TIP Printing a Pivot Chart.mp4 5.89 MB
09 PIVOT CHARTS/014 TIP Paste Pivot Chart to PowerPoint make live updates.mp4 5.88 MB
05 SORTING/006 Sort row from A-Z and sales from Z-A.mp4 5.84 MB
01 CUSTOMIZING YOUR PIVOT TABLE/029 DESIGN LAYOUT TIP Show the Classic Pivot Table Layout.mp4 5.79 MB
01 CUSTOMIZING YOUR PIVOT TABLE/039 LAYOUT FORMAT Indent rows in compact layout.mp4 5.77 MB
04 GROUPING/007 TIP Shortcuts to Grouping.mp4 5.75 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/004 Highlight Cell Rules based on date labels.mp4 5.74 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/015 Cond Format blank cells or cells.mp4 5.65 MB
09 PIVOT CHARTS/008 TIP Shortcuts to formatting a Pivot Chart.mp4 5.65 MB
01 CUSTOMIZING YOUR PIVOT TABLE/037 CUSTOMISATION TIP Predetermined number formatting.mp4 5.59 MB
09 PIVOT CHARTS/016 TIP Include a Sparkline with your pivot table.mp4 5.54 MB
06 FILTERING/004 Filter by Values.mp4 5.52 MB
01 CUSTOMIZING YOUR PIVOT TABLE/034 CUSTOMISATION Change Count of to Sum of.mp4 5.48 MB
04 GROUPING/008 TIP Grouping by Half Years.mp4 5.46 MB
01 CUSTOMIZING YOUR PIVOT TABLE/014 OPTIONS DATA Refresh.mp4 5.07 MB
06 FILTERING/014 TIP Filter by multiple values.mp4 4.98 MB
05 SORTING/005 Override a Custom List sort.mp4 4.97 MB
08 CALCULATED FIELDS ITEMS/012 TIP List Calculated Field Item formulas.mp4 4.88 MB
03 VALUE FIELD SETTINGS SHOW VALUES AS/015 TIP Shortcuts to Show Values As.mp4 4.84 MB
01 CUSTOMIZING YOUR PIVOT TABLE/019 OPTIONS ACTIONS Clear Filters Clear Pivot.mp4 4.82 MB
01 CUSTOMIZING YOUR PIVOT TABLE/026 DESIGN LAYOUT Grand Totals.mp4 4.81 MB
05 SORTING/007 TIP Sort new items added to your data source.mp4 4.71 MB
01 CUSTOMIZING YOUR PIVOT TABLE/043 LAYOUT FORMAT Keep column widths upon refresh.mp4 4.66 MB
09 PIVOT CHARTS/012 TIP Insert Pivot Chart straight from the data source.mp4 4.58 MB
07 SLICERS NEW IN EXCEL 2010/008 TIP Different ways to filter a Slicer.mp4 4.57 MB
08 CALCULATED FIELDS ITEMS/014 TIP Order of operations.mp4 4.52 MB
10 CONDITIONAL FORMATTING PIVOT TABLES/003 Highlight Cell Rules based on text labels.mp4 4.41 MB
01 CUSTOMIZING YOUR PIVOT TABLE/013 OPTIONS DATA Pivot Cache explained.mp4 4.38 MB
06 FILTERING/012 TIP Filter by multiple fields.mp4 4.37 MB
13 DATA MANAGEMENT/005 Compatibility Issues with Excel 2007 and Excel 2010.mp4 4.27 MB
01 CUSTOMIZING YOUR PIVOT TABLE/021 OPTIONS ACTIONS Move a Pivot Table.mp4 4.23 MB
01 CUSTOMIZING YOUR PIVOT TABLE/025 DESIGN LAYOUT Subtotals.mp4 4.19 MB
01 CUSTOMIZING YOUR PIVOT TABLE/044 LAYOUT FORMAT TIP Automatic Refresh a Pivot Table.mp4 4.18 MB
08 CALCULATED FIELDS ITEMS/013 TIP Remove a Calculated Field temporarily.mp4 3.94 MB
09 PIVOT CHARTS/009 TIP Link chart title to a pivot cell.mp4 3.88 MB
12 MACROS PIVOT TABLES/001 Adding the Developer tab disabling macros.mp4 3.78 MB
06 FILTERING/010 TIP Keep or hide selected items.mp4 3.77 MB
09 PIVOT CHARTS/010 TIP Copying a second chart.mp4 3.56 MB
09 PIVOT CHARTS/013 TIP Paste Pivot Chart to your email as a picture.mp4 3.52 MB
01 CUSTOMIZING YOUR PIVOT TABLE/011 CREATING A PIVOT TABLE TIP Double click on any labels to show more Fields.mp4 3.49 MB
01 CUSTOMIZING YOUR PIVOT TABLE/041 LAYOUT FORMAT Format error values.mp4 3.45 MB
01 CUSTOMIZING YOUR PIVOT TABLE/012 CREATING A PIVOT TABLE TIP Defer Layout Update.mp4 3.43 MB
01 CUSTOMIZING YOUR PIVOT TABLE/038 CUSTOMISATION TIP Change Sum views in Label areas.mp4 3.11 MB
06 FILTERING/017 TIP Add a filter for the column items.mp4 3.03 MB
01 CUSTOMIZING YOUR PIVOT TABLE/006 CREATING A PIVOT TABLE Inserting a Pivot Table.mp4 3 MB
01 CUSTOMIZING YOUR PIVOT TABLE/010 CREATING A PIVOT TABLE Sort Field List from A to Z.mp4 2.93 MB
01 CUSTOMIZING YOUR PIVOT TABLE/028 DESIGN LAYOUT Blank Rows.mp4 2.81 MB
04 GROUPING/014 TIP Fixing the problem of counting grouped sales.mp4 2.7 MB
05 SORTING/008 TIP Clear a sort.mp4 2.7 MB
09 PIVOT CHARTS/011 TIP Put a chart on a separate page with F11.mp4 2.53 MB
00 None/000 INTRODUCTION.mp4 2.31 MB
05 SORTING/009 TIP Sort Largest to Smallest Grand Totals.mp4 2.24 MB
01 CUSTOMIZING YOUR PIVOT TABLE/001 ARRANGING YOUR DATA SET Tabular Format.mp4 1.92 MB
01 CUSTOMIZING YOUR PIVOT TABLE/033 OPTIONS SHOW ShowHide Field Headers.mp4 1.74 MB
01 CUSTOMIZING YOUR PIVOT TABLE/032 OPTIONS SHOW ShowHide Field List.mp4 1.68 MB
14 BONUS VIDEOS/009 THANK YOU.mp4 1.63 MB
01 CUSTOMIZING YOUR PIVOT TABLE/002 ARRANGING YOUR DATA SET No Gaps.mp4 1.11 MB
11 GETPIVOTDATA Formula/002 Create a custom report with GETPIVOTDATA.mp4 1.08 MB
00 None/000 BONUS PIVOT TABLE CHEAT SHEET.pdf 995.35 KB
03 VALUE FIELD SETTINGS SHOW VALUES AS/005 of Parent Row Total NEW IN EXCEL 2010.mp4 590.57 KB
00 None/001 BONUS EXCEL RESOURCE BLOG.pdf 278.59 KB
00 None/002 BONUS MY EXCEL PODCAST SHOW.pdf 30.44 KB
07 SLICERS NEW IN EXCEL 2010/001 Identify the steps for customizing a Slicer Quiz.html 7.45 KB
03 VALUE FIELD SETTINGS SHOW VALUES AS/001 Identify the steps to showing the values as a Year to Date accumulation Quiz.html 7.3 KB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 Recall the way to change a Count Of to a Sum Of Quiz.html 7.21 KB
08 CALCULATED FIELDS ITEMS/001 State the steps to creating a Calculated Item Quiz.html 7.16 KB
05 SORTING/001 Identify the steps to creating a Custom List Quiz.html 7.04 KB
10 CONDITIONAL FORMATTING PIVOT TABLES/001 Recognize the option that conditionally formats all values except the Subtotals Quiz.html 7.03 KB
11 GETPIVOTDATA Formula/001 Define when to use the GETPIVOTDATA function Quiz.html 6.99 KB
12 MACROS PIVOT TABLES/001 Recall how to assign a macro Quiz.html 6.96 KB
13 DATA MANAGEMENT/001 List the ways to reduce the memory size of an Excel file Quiz.html 6.95 KB
09 PIVOT CHARTS/001 State the button to format a Pivot Chart Quiz.html 6.89 KB
01 CUSTOMIZING YOUR PIVOT TABLE/001 Recognize which button is used to update a Pivot Table Quiz.html 6.84 KB
06 FILTERING/001 Recall the command to search for a wildcard entry Quiz.html 6.81 KB
04 GROUPING/001 State which command is used to group a PivotTable report by weeks Quiz.html 6.79 KB
00 None/001 BONUS TOP 20 EXCEL SHORTCUTS.html 1.73 KB
00 None/000 COURSE TRACKER WORKBOOK.html 1.62 KB
05 SORTING/001 WORKBOOKS.html 1.31 KB
10 CONDITIONAL FORMATTING PIVOT TABLES/001 WORKBOOKS.html 1.31 KB
07 SLICERS NEW IN EXCEL 2010/001 WORKBOOKS.html 1.31 KB
06 FILTERING/001 WORKBOOKS.html 1.31 KB
09 PIVOT CHARTS/001 WORKBOOKS.html 1.31 KB
14 BONUS VIDEOS/001 WORKBOOKS.html 1.31 KB
12 MACROS PIVOT TABLES/001 WORKBOOKS.html 1.31 KB
11 GETPIVOTDATA Formula/001 WORKBOOKS.html 1.31 KB
02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 WORKBOOKS.html 1.31 KB
03 VALUE FIELD SETTINGS SHOW VALUES AS/001 WORKBOOKS.html 1.31 KB
08 CALCULATED FIELDS ITEMS/001 WORKBOOKS.html 1.31 KB
04 GROUPING/001 WORKBOOKS.html 1.31 KB
01 CUSTOMIZING YOUR PIVOT TABLE/001 WORKBOOKS.html 1.31 KB
13 DATA MANAGEMENT/001 WORKBOOKS.html 1.26 KB
Download Info
-
Tips
“microsoft-excel-pivot-tables-for-2007-2010-2013” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.