Excel Xtreme Pivot Tables

Focused View

10:14:00

0 View

1 - Design Customize Your Pivot Tables

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

2 - Value Field Settings Summarize Values By

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

3 - Value Field Settings Show Values As

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

4 - Grouping

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

5 - Sort

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

6 - Filter

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

7 - Slicers New in Excel 2010

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

8 - Calculated Fields Items

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

9 - Pivot Charts

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

10 - Conditional Formatting of Pivot Tables

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

11 - GETPIVOTDATA Formula

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

12 - Macros

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

13 - Data Management

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

14 - More learnings

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

15 - New Excel 2013 Pivot Table Features

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

16 - New Excel 2019 Office 365 Pivot Table Features

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

Description

Pivot Table, Microsoft Excel

What You'll Learn?

Master advanced PivotTable techniques to analyze, summarize, and present large datasets, making data-driven decisions confidently.
Learn to unleash PivotTables’ full potential with advanced techniques, transforming complex datasets into actionable insights.
Discover deep PivotTable skills to turn large datasets into clear, impactful reports that drive strategic business decisions.
Conquer Excel with Xtreme Pivot Tables, learning to analyze and summarize large data for confident, data-backed decision-making.

Who is this for?

Data Analysts: Professionals ready to elevate their skills by diving into advanced PivotTable techniques for in-depth data analysis.

Business Analysts: Those looking to deepen their analytical capabilities, creating more impactful reports using Excel’s PivotTables.

Managers and Decision Makers: Leaders who rely on large datasets for strategic insights and want to learn advanced methods for data-driven decisions.

Excel Power Users: Users who are comfortable with Excel and want to take their PivotTable skills to the next level with advanced techniques.

Students and Professionals: Anyone aiming to become proficient in data analysis for career growth or new opportunities in data-intensive roles.

What You Need to Know?

Basic Excel Skills: Familiarity with Excel’s interface, basic formulas, and general PivotTable use.

Understanding of Data Analysis: A foundational understanding of data concepts, such as summarizing data and generating reports, will be helpful.

Access to Excel: Excel 2016 or a later version is recommended for the best experience, as you’ll need it to follow along with advanced techniques.

More details

Description
Maybe youâ€™ve been working with Excel for years, or perhaps youâ€™re new to it. Either way, if you deal with data, youâ€™ve probably used PivotTables. Theyâ€™re powerful tools, and you may even have a few tricks up your sleeve.
I was the same. I could create PivotTables to get the basics done, but I knew I was barely scratching the surface. I realized that, while I could pull numbers together, I wasnâ€™t truly getting the most out of my data. I was simply presenting numbers without diving into the deeper insights hiding in my datasets.
Sound familiar? If so, youâ€™re not alone.
Thatâ€™s why I created this course. Itâ€™s for people like usâ€”professionals who work with data day in and day out and want to go beyond the basics. You can already create a simple PivotTable, sure. But what about using advanced grouping, calculated fields, or dynamic PivotCharts? If these arenâ€™t in your current toolkit, then this course is for you.
In Xtreme Pivot Tables, Iâ€™ll take you through:
Techniques to create calculated fields and items that make your reports go from good to great. When someone challenges your data, youâ€™ll have the skills to answer confidently.
Advanced grouping and filtering options so that youâ€™re only showing what matters most. If youâ€™ve ever spent time just scrolling through your data, this will be a game changer.
How to bring your data to life visually with PivotCharts. Excelâ€™s native charts are just the beginning; Iâ€™ll show you how to customize them in ways you probably didnâ€™t know were possible.
Tips for structuring large datasets effectively, so youâ€™re spending less time in the weeds and more time interpreting.
No VBA or complicated macrosâ€”just the practical, advanced skills you need to master PivotTables and make a real impact with your data.
If youâ€™re ready to transform your data analysis in Excel and make informed, data-driven decisions with confidence, this is the course for you.
Looking forward to seeing you there!
Who this course is for:
Data Analysts: Professionals ready to elevate their skills by diving into advanced PivotTable techniques for in-depth data analysis.
Business Analysts: Those looking to deepen their analytical capabilities, creating more impactful reports using Excelâ€™s PivotTables.
Managers and Decision Makers: Leaders who rely on large datasets for strategic insights and want to learn advanced methods for data-driven decisions.
Excel Power Users: Users who are comfortable with Excel and want to take their PivotTable skills to the next level with advanced techniques.
Students and Professionals: Anyone aiming to become proficient in data analysis for career growth or new opportunities in data-intensive roles.

User Reviews

Rating

average 0

Total votes0

Focused display

Pivot Tables

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.