Download Udemy - Excel with Excel Pivot Tables! Torrent

Torrent Contents Size: 2.49 GB

Udemy - Excel with Excel Pivot Tables!

00 None

000 BONUS PIVOT TABLE CHEAT SHEET.pdf	PDF	995.35 KB
000 COURSE TRACKER WORKBOOK.html	HTML	1.62 KB
000 INTRODUCTION.mp4	MP4	2.31 MB
001 BONUS EXCEL RESOURCE BLOG.pdf	PDF	278.59 KB
001 BONUS TOP 20 EXCEL SHORTCUTS.html	HTML	1.73 KB
002 BONUS MY EXCEL PODCAST SHOW.pdf	PDF	30.44 KB

01 CUSTOMIZING YOUR PIVOT TABLE

001 ARRANGING YOUR DATA SET Tabular Format.mp4	MP4	1.92 MB
001 Recognize which button is used to update a Pivot Table Quiz.html	HTML	6.84 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 ARRANGING YOUR DATA SET No Gaps.mp4	MP4	1.11 MB
003 ARRANGING YOUR DATA SET Formatting.mp4	MP4	6.72 MB
004 ARRANGING YOUR DATA SET Tables.mp4	MP4	15.78 MB
005 ARRANGING YOUR DATA SET TIP Clean Your Data Set.mp4	MP4	9.9 MB
006 CREATING A PIVOT TABLE Inserting a Pivot Table.mp4	MP4	3 MB
007 CREATING A PIVOT TABLE Field List - Activate, move, resize layout.mp4	MP4	6.56 MB
008 CREATING A PIVOT TABLE Field List Areas.mp4	MP4	19.24 MB
009 CREATING A PIVOT TABLE Drill down to audit.mp4	MP4	11.11 MB
010 CREATING A PIVOT TABLE Sort Field List from A to Z.mp4	MP4	2.93 MB
011 CREATING A PIVOT TABLE TIP Double click on any labels to show more Fields.mp4	MP4	3.49 MB
012 CREATING A PIVOT TABLE TIP Defer Layout Update.mp4	MP4	3.43 MB
013 OPTIONS DATA Pivot Cache explained.mp4	MP4	4.38 MB
014 OPTIONS DATA Refresh.mp4	MP4	5.07 MB
015 OPTIONS DATA Refresh All.mp4	MP4	9.84 MB
016 OPTIONS DATA Refresh External Data.mp4	MP4	21.4 MB
017 OPTIONS DATA Import from Access database.mp4	MP4	11.57 MB
018 OPTIONS DATA Change Data Source.mp4	MP4	19.1 MB
019 OPTIONS ACTIONS Clear Filters Clear Pivot.mp4	MP4	4.82 MB
020 OPTIONS ACTIONS Select format.mp4	MP4	19.1 MB
021 OPTIONS ACTIONS Move a Pivot Table.mp4	MP4	4.23 MB
022 DESIGN STYLES Pivot Table Styles.mp4	MP4	22.5 MB
023 DESIGN STYLES Customising a Pivot Table Style.mp4	MP4	23.18 MB
024 DESIGN STYLES Use a customised style in another workbook.mp4	MP4	7.44 MB
025 DESIGN LAYOUT Subtotals.mp4	MP4	4.19 MB
026 DESIGN LAYOUT Grand Totals.mp4	MP4	4.81 MB
027 DESIGN LAYOUT Report Layouts.mp4	MP4	13.9 MB
028 DESIGN LAYOUT Blank Rows.mp4	MP4	2.81 MB
029 DESIGN LAYOUT TIP Show the Classic Pivot Table Layout.mp4	MP4	5.79 MB
030 OPTIONS SHOW Expand Collapse buttons.mp4	MP4	23.94 MB
031 OPTIONS SHOW Move Remove Fields and Items.mp4	MP4	11.67 MB
032 OPTIONS SHOW ShowHide Field List.mp4	MP4	1.68 MB
033 OPTIONS SHOW ShowHide Field Headers.mp4	MP4	1.74 MB
034 CUSTOMISATION Change Count of to Sum of.mp4	MP4	5.48 MB
035 CUSTOMISATION Number formatting.mp4	MP4	7.49 MB
036 CUSTOMISATION Field name formatting.mp4	MP4	9.57 MB
037 CUSTOMISATION TIP Predetermined number formatting.mp4	MP4	5.59 MB
038 CUSTOMISATION TIP Change Sum views in Label areas.mp4	MP4	3.11 MB
039 LAYOUT FORMAT Indent rows in compact layout.mp4	MP4	5.77 MB
040 LAYOUT FORMAT Change the layout of a report filter.mp4	MP4	6.02 MB
041 LAYOUT FORMAT Format error values.mp4	MP4	3.45 MB
042 LAYOUT FORMAT Format empty cells.mp4	MP4	7 MB
043 LAYOUT FORMAT Keep column widths upon refresh.mp4	MP4	4.66 MB
044 LAYOUT FORMAT TIP Automatic Refresh a Pivot Table.mp4	MP4	4.18 MB
045 LAYOUT FORMAT TIP Printing a pivot table on two pages.mp4	MP4	6.14 MB
046 LAYOUT FORMAT TIPShow report filter on multiple pages.mp4	MP4	12.74 MB

02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY

001 Create multiple subtotals.mp4	MP4	8.29 MB
001 Recall the way to change a Count Of to a Sum Of Quiz.html	HTML	7.21 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Count.mp4	MP4	15.08 MB
003 Average.mp4	MP4	16.86 MB
004 Maximum.mp4	MP4	10.62 MB
005 Minimum.mp4	MP4	7.68 MB
006 Product.mp4	MP4	12.25 MB
007 Count Numbers.mp4	MP4	8.07 MB
008 Std Dev.mp4	MP4	24.78 MB
009 Varp.mp4	MP4	18.3 MB
010 TIP Show various Grand Totals.mp4	MP4	12.76 MB
011 TIP Shortcuts to Field Value Field Settings.mp4	MP4	11.01 MB
012 TIP See all pivot Items.mp4	MP4	20.2 MB
013 TIP Show a unique count.mp4	MP4	14.09 MB

03 VALUE FIELD SETTINGS SHOW VALUES AS

001 of Grand Total.mp4	MP4	12.48 MB
001 Identify the steps to showing the values as a Year to Date accumulation Quiz.html	HTML	7.3 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 of Column Total.mp4	MP4	11.31 MB
003 of Row Total.mp4	MP4	9.75 MB
004 Of.mp4	MP4	18.49 MB
005 of Parent Row Total NEW IN EXCEL 2010.mp4	MP4	590.57 KB
006 of Parent Column Total NEW IN EXCEL 2010.mp4	MP4	11.88 MB
007 of Parent Total NEW IN EXCEL 2010.mp4	MP4	16.57 MB
008 Difference From.mp4	MP4	24.2 MB
009 Difference From.mp4	MP4	20.05 MB
010 Running Total in.mp4	MP4	10.53 MB
011 Running Total in NEW IN EXCEL 2010.mp4	MP4	11.61 MB
012 Rank Smallest to Largest NEW IN EXCEL 2010.mp4	MP4	8.38 MB
013 Rank Largest to Smallest NEW IN EXCEL 2010.mp4	MP4	9.91 MB
014 Index.mp4	MP4	15.34 MB
015 TIP Shortcuts to Show Values As.mp4	MP4	4.84 MB
016 CASE STUDY ACCOUNTING of Revenue Margins.mp4	MP4	10.65 MB
017 CASE STUDY FINANCIAL Actual v Plan Variance Report.mp4	MP4	23.1 MB

04 GROUPING

001 Group by Date.mp4	MP4	14.65 MB
001 State which command is used to group a PivotTable report by weeks Quiz.html	HTML	6.79 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Group by Months.mp4	MP4	8.32 MB
003 Group by Quarters Years.mp4	MP4	7.22 MB
004 Group by Sales ranges.mp4	MP4	13.89 MB
005 Group by Text fields.mp4	MP4	6.71 MB
006 Group by Time.mp4	MP4	6.74 MB
007 TIP Shortcuts to Grouping.mp4	MP4	5.75 MB
008 TIP Grouping by Half Years.mp4	MP4	5.46 MB
009 TIP Group by a Date that starts on a Monday.mp4	MP4	7.73 MB
010 TIP Grouping by a custom date.mp4	MP4	10.49 MB
011 TIP Group by fiscal years quarters.mp4	MP4	20.95 MB
012 TIP Errors when grouping by dates.mp4	MP4	11.7 MB
013 TIP Group two pivot tables independently.mp4	MP4	7.34 MB
014 TIP Fixing the problem of counting grouped sales.mp4	MP4	2.7 MB
015 TIP Display dates that have no data.mp4	MP4	6.36 MB
016 CASE STUDY ACCOUNTING Quarterly Comparative Report.mp4	MP4	37.65 MB
017 CASE STUDY FINANCIAL Min Max Bank Balance.mp4	MP4	20.14 MB

05 SORTING

001 Identify the steps to creating a Custom List Quiz.html	HTML	7.04 KB
001 Sorting by Largest or Smallest.mp4	MP4	7.14 MB
001 WORKBOOKS.html	HTML	1.31 KB
002 Sort an Item Row Left to Right.mp4	MP4	6.27 MB
003 Sort manually drag, write, right click.mp4	MP4	7.35 MB
004 Sort using a Custom List.mp4	MP4	11.65 MB
005 Override a Custom List sort.mp4	MP4	4.97 MB
006 Sort row from A-Z and sales from Z-A.mp4	MP4	5.84 MB
007 TIP Sort new items added to your data source.mp4	MP4	4.71 MB
008 TIP Clear a sort.mp4	MP4	2.7 MB
009 TIP Sort Largest to Smallest Grand Totals.mp4	MP4	2.24 MB

06 FILTERING

001 Filter by Dates.mp4	MP4	25.11 MB
001 Recall the command to search for a wildcard entry Quiz.html	HTML	6.81 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Filter by Labels - Text.mp4	MP4	9.73 MB
003 Filter by Labels - Numerical Text.mp4	MP4	11.11 MB
004 Filter by Values.mp4	MP4	5.52 MB
005 Filter by Values - Top or Bottom 10 Items.mp4	MP4	8.12 MB
006 Filter by Values - Top or Bottom .mp4	MP4	7.65 MB
007 Filter by Values - Top or Bottom Sum.mp4	MP4	6.63 MB
008 Filter by Report Filter.mp4	MP4	14.18 MB
009 TIP Shortcuts to filters.mp4	MP4	7.1 MB
010 TIP Keep or hide selected items.mp4	MP4	3.77 MB
011 TIP Filter by Text wildcards and .mp4	MP4	12.39 MB
012 TIP Filter by multiple fields.mp4	MP4	4.37 MB
013 TIP Apply multiple filters.mp4	MP4	7.4 MB
014 TIP Filter by multiple values.mp4	MP4	4.98 MB
015 TIP Include new items in manual filter.mp4	MP4	8.08 MB
016 TIP Clear filters with one click.mp4	MP4	6.37 MB
017 TIP Add a filter for the column items.mp4	MP4	3.03 MB
018 CASE STUDY ACCOUNTING Top 5 Expenses report.mp4	MP4	9.47 MB
019 CASE STUDY FINANCIAL Top 25 of Channel Partners.mp4	MP4	9.96 MB

07 SLICERS NEW IN EXCEL 2010

001 Identify the steps for customizing a Slicer Quiz.html	HTML	7.45 KB
001 Insert a Slicer.mp4	MP4	13.79 MB
001 WORKBOOKS.html	HTML	1.31 KB
002 Slicer Styles.mp4	MP4	10.05 MB
003 Creating a custom style.mp4	MP4	22.9 MB
004 Copy a custom style into a new workbook.mp4	MP4	6.89 MB
005 Slicer Settings.mp4	MP4	21.98 MB
006 Slicer Size Properties.mp4	MP4	10.64 MB
007 Slicer Connections for multiple pivot tables.mp4	MP4	13.76 MB
008 TIP Different ways to filter a Slicer.mp4	MP4	4.57 MB
009 TIP Use one slicer for two pivot tables.mp4	MP4	6.58 MB
010 TIP Lock the workbook but not the slicer.mp4	MP4	6.92 MB
011 TIP Interactive employee photos with Slicers FUN.mp4	MP4	31.08 MB
012 CASE STUDY ACCOUNTING Select a Monthly PL report with a Slicer.mp4	MP4	20.95 MB
013 CASE STUDY FINANCIAL Base, Best Worst case Forecast.mp4	MP4	22.65 MB

08 CALCULATED FIELDS ITEMS

001 Creating a Calculated Field.mp4	MP4	17.09 MB
001 State the steps to creating a Calculated Item Quiz.html	HTML	7.16 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Use an existing Calculated Field in a new calculation.mp4	MP4	12.79 MB
003 Editing a Calculated Field.mp4	MP4	12.77 MB
004 Excel formulas Calculated Fields.mp4	MP4	13.99 MB
005 Creating a Calculated Item.mp4	MP4	17.67 MB
006 Use an existing Calculated Item in a new calculation.mp4	MP4	8.57 MB
007 Editing a Calculated Item.mp4	MP4	13.79 MB
008 Excel formulas Calculated Items.mp4	MP4	9.76 MB
009 Calculated Item on Column Labels.mp4	MP4	11.2 MB
010 Shortcomings of Calculated Items.mp4	MP4	8.34 MB
011 TIP Solve Order for Calculated Items.mp4	MP4	21.37 MB
012 TIP List Calculated Field Item formulas.mp4	MP4	4.88 MB
013 TIP Remove a Calculated Field temporarily.mp4	MP4	3.94 MB
014 TIP Order of operations.mp4	MP4	4.52 MB
015 CASE STUDY ACCOUNTING Creating a PL Pivot Table Report.mp4	MP4	58.6 MB
016 CASE STUDY FINANCIAL Actuals v Plan with Calculated Fields.mp4	MP4	50.99 MB

09 PIVOT CHARTS

001 Insert a Pivot Chart.mp4	MP4	12.12 MB
001 State the button to format a Pivot Chart Quiz.html	HTML	6.89 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Insert a Slicer with a Pivot Chart.mp4	MP4	7.42 MB
003 Pivot Chart Designs.mp4	MP4	15.04 MB
004 Pivot Chart Layouts.mp4	MP4	20.35 MB
005 Pivot Chart Formats.mp4	MP4	20.07 MB
006 Limitations of Pivot Charts workarounds.mp4	MP4	8.2 MB
007 Saving a Pivot Chart template.mp4	MP4	6.41 MB
008 TIP Shortcuts to formatting a Pivot Chart.mp4	MP4	5.65 MB
009 TIP Link chart title to a pivot cell.mp4	MP4	3.88 MB
010 TIP Copying a second chart.mp4	MP4	3.56 MB
011 TIP Put a chart on a separate page with F11.mp4	MP4	2.53 MB
012 TIP Insert Pivot Chart straight from the data source.mp4	MP4	4.58 MB
013 TIP Paste Pivot Chart to your email as a picture.mp4	MP4	3.52 MB
014 TIP Paste Pivot Chart to PowerPoint make live updates.mp4	MP4	5.88 MB
015 TIP Printing a Pivot Chart.mp4	MP4	5.89 MB
016 TIP Include a Sparkline with your pivot table.mp4	MP4	5.54 MB
017 TIP Charts Dos Donts.mp4	MP4	10.14 MB
018 TIP Change Chart Type with Slicers FUN.mp4	MP4	28.79 MB
019 TIP Workaround to creating an interactive Scatter graph.mp4	MP4	10.73 MB
020 CASE STUDY ACCOUNTING PL Pivot Table report with Graphs.mp4	MP4	38.49 MB
021 CASE STUDY FINANCIAL Pivot Table Slicer Chart Dashboard.mp4	MP4	67.81 MB

10 CONDITIONAL FORMATTING PIVOT TABLES

001 Intro to Conditional Formatting.mp4	MP4	13.75 MB
001 Recognize the option that conditionally formats all values except the Subtotals Quiz.html	HTML	7.03 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Highlight Cell Rules based on values.mp4	MP4	6.45 MB
003 Highlight Cell Rules based on text labels.mp4	MP4	4.41 MB
004 Highlight Cell Rules based on date labels.mp4	MP4	5.74 MB
005 Top Bottom Rules.mp4	MP4	17.07 MB
006 Data Bars, Color Scales Icon Sets NEW IN EXCEL 2010.mp4	MP4	24.18 MB
007 TIP Format only cells that contain - For Bonuses.mp4	MP4	7.3 MB
008 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4	MP4	8.6 MB
009 TIP Format values that are above or below the average - For Promotions.mp4	MP4	5.91 MB
010 TIP Use a formula to determine which cells to format.mp4	MP4	9.45 MB
011 Use selected cells to format multiple fields.mp4	MP4	8.73 MB
012 All cells showing values to format multiple fields.mp4	MP4	7.58 MB
013 Control Conditional Formatting with Slicers.mp4	MP4	10.47 MB
014 Show text in the Pivot Table Values area.mp4	MP4	22.3 MB
015 Cond Format blank cells or cells.mp4	MP4	5.65 MB
016 CASE STUDY ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4	MP4	27.31 MB
017 CASE STUDY FINANCIAL Conditionally Format your sales results.mp4	MP4	15.55 MB

11 GETPIVOTDATA Formula

001 Define when to use the GETPIVOTDATA function Quiz.html	HTML	6.99 KB
001 Intro to GETPIVOTDATA.mp4	MP4	22.06 MB
001 WORKBOOKS.html	HTML	1.31 KB
002 Create a custom report with GETPIVOTDATA.mp4	MP4	1.08 MB
003 Reference Dates with GETPIVOTDATA.mp4	MP4	11.04 MB
004 Data validation with GETPIVOTDATA.mp4	MP4	12.68 MB
005 Shortfalls of GETPIVOTDATA.mp4	MP4	6.03 MB
006 TIP Grand Totals to the left of the pivot table.mp4	MP4	13.42 MB
007 CASE STUDY ACCOUNTING Live forecasting with GETPIVOTDATA.mp4	MP4	31.02 MB
008 CASE STUDY FINANCIAL Channel Analysis with GETPIVOTDATA.mp4	MP4	24.99 MB

12 MACROS PIVOT TABLES

001 Adding the Developer tab disabling macros.mp4	MP4	3.78 MB
001 Recall how to assign a macro Quiz.html	HTML	6.96 KB
001 WORKBOOKS.html	HTML	1.31 KB
002 Record a simple macro to Refresh a pivot table.mp4	MP4	17.51 MB
003 Date filter macro.mp4	MP4	15.07 MB
004 Different pivot table views macro.mp4	MP4	19.08 MB
005 Top 10 macro.mp4	MP4	11.4 MB
006 Add macro to quick access toolbar.mp4	MP4	7.14 MB

13 DATA MANAGEMENT

001 List the ways to reduce the memory size of an Excel file Quiz.html	HTML	6.95 KB
001 Reducing file memory by copying existing pivot table.mp4	MP4	8.75 MB
001 WORKBOOKS.html	HTML	1.26 KB
002 Reducing file memory by deleting the data source.mp4	MP4	12.23 MB
003 Reducing file memory by saving file as Excel Binary Workbook.mp4	MP4	6.27 MB
004 Reducing file memory by keeping data source in MS Access.mp4	MP4	10.37 MB
005 Compatibility Issues with Excel 2007 and Excel 2010.mp4	MP4	4.27 MB
006 Sharing a Pivot Table via OneDrive.mp4	MP4	8.57 MB

14 BONUS VIDEOS

001 Sales Forecasting with Calculated Fields.mp4	MP4	21.27 MB
001 WORKBOOKS.html	HTML	1.31 KB
002 Consolidate with a Pivot Table.mp4	MP4	22.14 MB
003 Frequency distribution with a Pivot Table.mp4	MP4	10.02 MB
004 Break Even Model.mp4	MP4	9.42 MB
005 Several Slicer custom styles for you to use.mp4	MP4	6.87 MB
006 Interactive Balance Sheet Pivot Table.mp4	MP4	47.83 MB
007 Monthly Sales Manager Performance Report.mp4	MP4	27.67 MB
008 Reconciling customer payments.mp4	MP4	6.45 MB
009 THANK YOU.mp4	MP4	1.63 MB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Mastering Microsoft Excel and Visual Basic Posted by freecoursewb in Other Posted in Other 0 943.6 MB 3 months ago freecoursewb	Size 943.6 MB	Files 7	Age 3 months ago	Seeds 0	Leechs 0	Source
Udemy - Beginner hip hop with new york choreographer excel garner Posted by freecoursewb in Other Posted in Other 4 1.1 GB 4 months ago freecoursewb	Size 1.1 GB	Files 14	Age 4 months ago	Seeds 4	Leechs 1	Source
Udemy - Reporting Aesthetically in Excel Posted by freecoursewb in Other Posted in Other 11 1.1 GB 5 months ago freecoursewb	Size 1.1 GB	Files 29	Age 5 months ago	Seeds 11	Leechs 25	Source
Udemy - Microsoft Excel Pivot Table and Pivot Chart Posted by freecoursewb in Other Posted in Other 14 894.7 MB 5 months ago freecoursewb	Size 894.7 MB	Files 17	Age 5 months ago	Seeds 14	Leechs 2	Source
Udemy - Microsoft Excel Formulas and Functions - Learn Fast and Smart Posted by freecoursewb in Other Posted in Other 23 1.9 GB 5 months ago freecoursewb	Size 1.9 GB	Files 39	Age 5 months ago	Seeds 23	Leechs 5	Source

Udemy - Excel with Excel Pivot Tables!

Torrent Contents Size: 2.49 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce