Master Excel Pivot Tables: Advanced Data Analysis 2024
Focused View
10:14:00
1 - All-Workbooks-Xtreme-PivotTable-Course.zip
1 - Tabular Format.mp4
02:16
2 - No Gaps.mp4
02:22
3 - Formatting.mp4
01:19
4 - Tables.mp4
02:37
5 - Clean Your Data Set.mp4
02:10
6 - Inserting a Pivot Table.mp4
03:13
7 - Field List.mp4
01:32
8 - Field List Areas.mp4
05:17
9 - Drill Down to Audit.mp4
01:33
10 - Sort Field List from A to Z.mp4
00:36
11 - Double Click on any Label to Show More Fields.mp4
00:45
12 - Defer Layout Update.mp4
00:46
13 - Pivot Cache.mp4
00:52
14 - Refresh.mp4
01:11
15 - Refresh All.mp4
02:19
16 - Refresh External Data.mp4
04:50
17 - Import from Access Database.mp4
02:18
18 - Change Data Source.mp4
03:01
19 - Clear Filter and Clear Pivot.mp4
01:09
20 - Select and Format.mp4
03:07
21 - Move a Pivot Table.mp4
00:52
22 - Pivot Table Styles.mp4
03:34
23 - Customize Styles.mp4
04:04
24 - Use a Customized Style in Another Workbook.mp4
01:19
25 - Subtotals.mp4
00:47
26 - Grand Totals.mp4
00:53
27 - Report Layout.mp4
02:40
28 - Blank Rows.mp4
00:31
29 - TIPS Show the Classic Pivot Table Layout.mp4
00:59
30 - Expand and Collapse Buttons.mp4
04:18
31 - Move and Remove Fields and Items.mp4
02:31
32 - Show or Hide Field List.mp4
00:19
33 - Show or Hide Field Field Headers.mp4
00:18
34 - Change Count Of to Sum Of.mp4
01:00
35 - Number Formatting.mp4
01:33
36 - Field Name Formatting.mp4
02:08
37 - Predetermined Number Formatting.mp4
01:20
38 - TIPS Change SUM Views in Label Areas.mp4
00:43
39 - Indent Rows in Compact Layouts.mp4
00:51
40 - Change Layout of a Report Filter.mp4
01:17
41 - Format Error Values.mp4
00:41
42 - Format Empty Cells.mp4
01:19
43 - Keep Column Widths Upon Refresh.mp4
00:45
44 - Automatically Refresh a Pivot Table.mp4
00:47
45 - TIPS Printing a Pivot Table on Two Pages.mp4
01:12
46 - TIPS Show Report Filters on Multiple Pages.mp4
02:14
47 - Create Multiple Subtotals.mp4
01:35
48 - Count.mp4
02:18
49 - Average.mp4
02:34
50 - Maximum.mp4
01:54
51 - MINimum.mp4
01:18
52 - Product.mp4
03:30
53 - Count Numbers.mp4
02:17
54 - StdDevp.mp4
06:58
55 - VarP.mp4
03:27
56 - Show Various Grand Totals.mp4
02:27
57 - Shortcuts to Value Field Settings.mp4
02:11
58 - See All Pivot Items.mp4
05:51
59 - Show a Unique Count.mp4
02:28
60 - Percentage of Grand Total.mp4
02:00
61 - Percentage of Column Total.mp4
02:07
62 - Percentage of Row Total.mp4
01:46
63 - Percentage Of.mp4
03:55
64 - Percentage of Parent Row Total.mp4
03:11
65 - Percentage of Parent Column Total.mp4
02:15
66 - Percentage of Parent Total.mp4
02:44
67 - Difference From.mp4
04:46
68 - Percentage Difference From.mp4
04:10
69 - Running Total In.mp4
02:12
70 - Percentage Running Total In.mp4
02:50
71 - Rank Smallest to Largest.mp4
02:06
72 - Rank Largest to Smallest.mp4
02:13
73 - Index.mp4
03:36
74 - Shortcuts to Show Values As.mp4
01:07
75 - Percentage of Revenue.mp4
02:30
76 - Actual v Plan Variation.mp4
04:35
77 - Group by Date.mp4
02:37
78 - Grouping by Months.mp4
01:43
79 - Grouping by Quarters and Years.mp4
01:40
80 - Group by Sales Ranges.mp4
03:11
81 - Group by Text Fields.mp4
02:08
82 - Group by Time.mp4
01:37
83 - Shortcuts to Grouping.mp4
01:31
84 - Grouping by Half Years.mp4
01:47
85 - Grouping by a Date that starts on a Monday.mp4
01:52
86 - Grouping by a Custom Date.mp4
01:40
87 - Grouping by a Fiscal Year and Quarter.mp4
06:28
88 - Errors when Grouping by Dates.mp4
02:45
89 - Group Two Pivot Tables in the Same Workbook.mp4
03:44
90 - Fixing the Problem of Counting Grouped Sales.mp4
00:37
91 - Display Dates that Have No Data.mp4
00:51
92 - Quarterly Comparative Report.mp4
06:36
93 - FINANCIAL Min and Max Bank Balance.mp4
04:34
94 - Sorting by Largest or Smallest.mp4
01:50
95 - Sort an Item Row.mp4
01:23
96 - Sort Manually.mp4
01:52
97 - Sort using a Custom List.mp4
03:12
98 - Override a Custom List Sort.mp4
01:19
99 - Sort rows from A to Z and values by Z to A.mp4
01:15
100 - Sort New Items Added to Your Data Source.mp4
01:10
101 - TIPS Clear a Sort.mp4
00:20
102 - TIPS Sort Largest to Smallest Grand Totals.mp4
00:18
103 - Filter by Dates.mp4
06:40
104 - Filter by Labels Text.mp4
02:34
105 - Filter by Labels Numerical Text.mp4
02:43
106 - Filter by Values.mp4
03:49
107 - Filter by Values Top or Bottom 10 Items.mp4
02:05
108 - Filter by Values Top or Bottom Percent.mp4
01:38
109 - Filter by Values Top or Bottom Sum.mp4
01:41
110 - Filter by Report Filter.mp4
03:30
111 - Shortcuts to Filter.mp4
01:35
112 - Keep or Hide Selected Items.mp4
00:49
113 - Filter by Text Wildcards.mp4
03:19
114 - TIPS Filter by Multiple Fields.mp4
00:59
115 - Apply Multiple Filters.mp4
01:44
116 - TIPS Filter by Multiple Values.mp4
01:05
117 - Include New Items in Manual Filter.mp4
01:49
118 - Clear Filters with One Click.mp4
01:29
119 - TIPS Add a Filter for the Column Items.mp4
00:32
120 - Top 5 Expense Report.mp4
02:22
121 - Top 25 percent of Channel Partners.mp4
02:10
122 - Insert a Slicer.mp4
03:53
123 - Slicer Styles.mp4
02:17
124 - Creating a Custom Style.mp4
05:30
125 - Copying a Custom Style in to a New Workbook.mp4
01:32
126 - Slicer Settings.mp4
04:41
127 - Slicer Size and Properties.mp4
02:55
128 - Slicer Connections for Multiple Pivot Tables.mp4
03:15
129 - Different ways to Filter a Slicer.mp4
01:13
130 - Use One Slicer for Two Pivot Tables.mp4
01:18
131 - Lock the Workbook but not the Slicer.mp4
01:24
132 - Interactive Employee Photos with Slicers.mp4
09:19
133 - Select a Monthly PnL Report with a Slicer.mp4
04:12
134 - Base Best and Worst Case Forecast.mp4
05:01
135 - Creating a Calculated Field.mp4
03:57
136 - Use an Existing Calculated Field.mp4
02:15
137 - Editing a Calculated Field.mp4
01:55
138 - Excel formulas and Calculated Fields.mp4
02:58
139 - Creating a Calculated Item.mp4
04:04
140 - Use an Existing Calculated Item.mp4
01:34
141 - Editing a Calculated Item.mp4
02:17
142 - Excel Formulas and Calculated Items.mp4
01:49
143 - Calculated Item on Column Labels.mp4
02:05
144 - Shortcomings of Calculated Items.mp4
01:55
145 - Solve Order for Calculated Items.mp4
04:03
146 - List Formulas.mp4
01:03
147 - Remove a Calculated Field temporarily.mp4
00:51
148 - Order of Operations.mp4
01:47
149 - Creating a PnL Pivot Table Report.mp4
08:17
150 - Actual v Plan with Calculated Fields.mp4
06:28
151 - Insert a Pivot Chart.mp4
03:16
152 - Insert a Slicer with a Pivot Chart.mp4
01:50
153 - Pivot Chart Designs.mp4
03:47
154 - Pivot Chart Layouts.mp4
04:55
155 - Pivot Chart Formats.mp4
05:49
156 - Limitations of Pivot Charts and Workarounds.mp4
01:53
157 - Saving a Pivot Chart Template.mp4
01:27
158 - Shortcuts to formatting a Pivot Chart.mp4
01:15
159 - TIPS Link Chart Title To a Pivot Cell.mp4
00:57
160 - Copying a Second Chart.mp4
00:43
161 - Put a Chart on a Separate Page with F11.mp4
00:39
162 - Insert Pivot Chart Straight from the Data Source.mp4
00:50
163 - Paste Pivot Chart to your Email as a Picture.mp4
01:03
164 - TIPS Paste Pivot Chart to Powerpoint.mp4
01:26
165 - TIPS Printing a Pivot Chart.mp4
01:19
166 - Include a Sparkline with Your Pivot Table.mp4
01:15
167 - Chart Dos and Donts.mp4
02:37
168 - FUN Use Slicers to Change Chart Types.mp4
07:59
169 - Workaround to creating a Scatter Graph.mp4
02:19
170 - PnL Pivot table report with Graphs.mp4
08:12
171 - Pivot Table Slicer and Chart Dashboard.mp4
15:46
172 - Intro to Conditional Formatting.mp4
02:34
173 - Highlight Cell Rules based on Values.mp4
01:19
174 - Highlight Cell Rules based on Text Labels.mp4
00:46
175 - Highlight Cell Rules based on Date Labels.mp4
01:14
176 - Top and Bottom Rules.mp4
03:23
177 - Data Bars Color Scales and Icon Sets.mp4
05:41
178 - Format cells that contain.mp4
01:37
179 - Format Top Ranked Values.mp4
01:31
180 - Format Values Above the Average.mp4
01:36
181 - Use a Formula to Determine Which Cells to Format.mp4
02:30
182 - TIPS Use Selected Cells to Format Multiple Fields.mp4
01:30
183 - All Cells Showing Values.mp4
01:30
184 - Control Conditional Formatting with Slicers.mp4
02:46
185 - TIP Show text in the Pivot Table Values Area.mp4
04:42
186 - Conditionally Formatting Blank Cells.mp4
01:05
187 - Accounts Receivable Ageing Report Matrix.mp4
06:08
188 - Conditionally Format your sales results.mp4
03:24
189 - Intro to GET PIVOT DATA.mp4
04:50
190 - Create a custom report with GET PIVOT DATA.mp4
05:16
191 - Reference Dates with GET PIVOT DATA.mp4
03:08
192 - Data validation with GET PIVOT DATA.mp4
02:43
193 - Shortfalls of GET PIVOT DATA.mp4
01:39
194 - Grand Totals to the left of the pivot table.mp4
03:10
195 - Live forecasting with GET PIVOT DATA.mp4
07:16
196 - Channel analysis with GET PIVOT DATA.mp4
05:21
197 - Adding the Developer tab.mp4
02:31
198 - Record a simple macro to Refresh a Pivot Table.mp4
04:17
199 - Date filter macro.mp4
04:19
200 - Different Pivot Table Views Macro.mp4
04:35
201 - Top 10 macro.mp4
03:22
202 - Add macro to quick access toolbar.mp4
01:12
203 - Reducing File Memory by Copying Existing Pivot Table.mp4
01:20
204 - Reducing File Memory by Deleting the Data Source.mp4
01:37
205 - Reducing file memory by saving file as XLSB.mp4
00:49
206 - Reducing file memory by keeping data in Access.mp4
02:03
207 - Compatibility Issues with Excel 2007 and Excel 2010.mp4
01:11
208 - Sharing a Pivot Table via OneDrive.mp4
02:40
209 - Sales Forecasting with Calculated Fields.mp4
04:10
210 - Consolidate with a Pivot Table.mp4
04:37
211 - Frequency Distribution with a Pivot Table.mp4
02:08
212 - Break Even Model with a Pivot Table.mp4
02:55
213 - Several slicer custom styles for you to use.mp4
01:54
214 - Interactive Balance Sheet Pivot Table.mp4
12:12
215 - Monthly Sales Manager Performance.mp4
04:26
216 - 14.8-reconciling-customer-payments.mp4-720p.mp4
01:32
216 - Reconciling customer payments.mp4
01:32
217 - Cosmetic Changes.mp4
02:04
218 - Recommended Pivot Tables.mp4
01:57
219 - Distinct Count.mp4
01:49
220 - Timeline Slicer.mp4
04:14
221 - Data Model.mp4
06:56
222 - Group Periods.mp4
01:45
223 - Multiselect Slicers.mp4
00:32
224 - Pivot Chart Expand and Collapse.mp4
01:10
225 - 3D Maps.mp4
01:43
226 - Which Excel Version.mp4
01:51
227 - Personalize the default Pivot Table layout.mp4
05:28
228 - Automatic relationship detection.mp4
05:37
229 - Automatic time grouping.mp4
02:52
230 - Search in the Pivot Table.mp4
01:24
More details
Course Overview
Master advanced PivotTable techniques to analyze, summarize, and present large datasets for confident, data-driven decision-making. Transform complex data into actionable insights with Excel's most powerful tool.
What You'll Learn
- Design and customize professional PivotTables for any business scenario
- Apply advanced grouping, sorting, and filtering techniques
- Create dynamic dashboards with PivotCharts and Slicers
Who This Is For
- Data Analysts looking to elevate their reporting skills
- Business Analysts needing deeper data insights
- Managers who rely on data for strategic decisions
Key Benefits
- Turn raw data into clear, impactful reports in minutes
- Master time-saving techniques for large datasets
- Learn 2019/365 exclusive features for modern analysis
Curriculum Highlights
- PivotTable Design & Customization
- Advanced Value Field Settings
- Interactive Dashboards with Slicers
Focused display
Category
- language english
- Training sessions 231
- duration 10:14:00
- Release Date 2025/04/26
