Microsoft Excel Pivot Tables, Power Query, Power PivotDAX

Start Download


Files Included :

1 - Introduction.mp4 (35.02 MB)
MP4
3 - The Udemy Interface.mp4 (16.69 MB)
MP4
5 - Curriculum.mp4 (50.9 MB)
MP4
73 - Percentage of total.mp4 (107.63 MB)
MP4
74 - Percentage of total Advanced.mp4 (150.51 MB)
MP4
75 - Cumulative totals.mp4 (55.93 MB)
MP4
76 - Rank and Index.mp4 (60.12 MB)
MP4
77 - Difference from.mp4 (25.23 MB)
MP4
78 - Calculated fields.mp4 (28.61 MB)
MP4
79 - Calculated Items.mp4 (38.42 MB)
MP4
80 - Relationship of Pivot Chart with Pivot Table.mp4 (30.35 MB)
MP4
81 - Options and Styles.mp4 (19.86 MB)
MP4
82 - Bubble charts.mp4 (57.21 MB)
MP4
84 - Adding legends.mp4 (55.32 MB)
MP4
85 - Positioning and Resizing charts and graphs inc moving charts into chart sheets.mp4 (34.27 MB)
MP4
86 - Modifying chart and graph parameters.mp4 (77.15 MB)
MP4
87 - Applying chart layouts and styles.mp4 (24.07 MB)
MP4
88 - Conclusion to Part 1.mp4 (10.3 MB)
MP4
89 - Introduction lets Get some more Data.mp4 (80.97 MB)
MP4
90 - Exploring the Power Query Editor interface.mp4 (53.74 MB)
MP4
91 - Introducing the M language.mp4 (123 MB)
MP4
92 - Lets start look at the Home tab.mp4 (69.71 MB)
MP4
93 - Home menu Manage Columns.mp4 (35.48 MB)
MP4
94 - Home menu Reduce Rows and Use First Row as Headers.mp4 (89.19 MB)
MP4
96 - Practice Activity Number 9 The Solution.mp4 (74.09 MB)
MP4
101 - Practice Activity Number 10 The Solution.mp4 (52.6 MB)
MP4
97 - Sort and Filter.mp4 (37.36 MB)
MP4
98 - Split Column.mp4 (140.35 MB)
MP4
99 - Other Transform activities.mp4 (141.27 MB)
MP4
102 - Merge Queries and Expand Table.mp4 (118.75 MB)
MP4
103 - Different types of Joins.mp4 (88.32 MB)
MP4
104 - Merge Queries with Group By.mp4 (24.96 MB)
MP4
105 - Appending two queries together.mp4 (21.08 MB)
MP4
107 - Combine Files getting information from a folder.mp4 (80.58 MB)
MP4
108 - Load To.mp4 (78.93 MB)
MP4
110 - Practice Activity Number 11 The Solution.mp4 (117.41 MB)
MP4
111 - Transform Table and Any Column.mp4 (30.13 MB)
MP4
112 - Pivot Column.mp4 (99.92 MB)
MP4
113 - Unpivot.mp4 (112.88 MB)
MP4
115 - Practice Activity 12 The Solution.mp4 (65.24 MB)
MP4
116 - Unpivot in conjunction with other Transform features.mp4 (132.54 MB)
MP4
118 - Practice Activity 13 The Solution.mp4 (130.84 MB)
MP4
119 - TransformAdd Column Text Format.mp4 (31.77 MB)
MP4
120 - TransformAdd Column Text Merge Columns.mp4 (108.41 MB)
MP4
121 - TransformAdd Column Text Extract.mp4 (38.68 MB)
MP4
122 - TransformAdd Column Text Parse.mp4 (102.53 MB)
MP4
123 - TransformAdd Column Number Column Statistics and Standard.mp4 (41.94 MB)
MP4
124 - TransformAdd Column Other Number Column functions.mp4 (61.53 MB)
MP4
126 - Practice Activity 14 The Solution.mp4 (123.34 MB)
MP4
127 - Creating a list of dates.mp4 (46.37 MB)
MP4
128 - TransformAdd Column Date.mp4 (95.17 MB)
MP4
129 - TransformAdd Column Dates in other cultureslanguages.mp4 (126.82 MB)
MP4
130 - TransformAdd Column Time.mp4 (51.09 MB)
MP4
131 - TransformAdd column Duration.mp4 (18.49 MB)
MP4
133 - Practice Activity Number 15 The Solution.mp4 (111.18 MB)
MP4
134 - Column from examples.mp4 (134.25 MB)
MP4
135 - Conditional Column.mp4 (168 MB)
MP4
136 - Resolving Errors from Conditional Columns.mp4 (61.01 MB)
MP4
137 - Index Column and Duplicate Column.mp4 (67.15 MB)
MP4
138 - Custom Column If Then Else.mp4 (75.14 MB)
MP4
140 - Practice Activity Number 16 The Solution.mp4 (145.65 MB)
MP4
141 - Other M Functions.mp4 (66.36 MB)
MP4
142 - View and Help menus.mp4 (28.98 MB)
MP4
143 - Advanced Editor.mp4 (45.95 MB)
MP4
144 - Custom Functions.mp4 (48.41 MB)
MP4
145 - DateTimeZone date type and Functions.mp4 (39.3 MB)
MP4
146 - Worked Practice Activity 17 Dividing Annual data into Months.mp4 (90.78 MB)
MP4
10 - PivotChart Menus and An Introduction to Practice Activity 1.mp4 (42.73 MB)
MP4
12 - Answer to Practice Activity 1.mp4 (42.93 MB)
MP4
7 - Our first PivotTable.mp4 (75.18 MB)
MP4
8 - PivotTable Menus.mp4 (9.72 MB)
MP4
9 - Our first PivotChart.mp4 (43.34 MB)
MP4
147 - Introduction to SQL Server.mp4 (45.62 MB)
MP4
148 - Importing database data into Get and Transform and Query Folding.mp4 (38.34 MB)
MP4
149 - Expanding multiple tables in SQL Server.mp4 (92.8 MB)
MP4
150 - Importing data from SQL Server Analysis Services SSAS.mp4 (114.95 MB)
MP4
151 - Setting up Azure SQL Database.mp4 (90.68 MB)
MP4
152 - Using Azure SQL Database in Get and Transform.mp4 (46.87 MB)
MP4
153 - Using Big Data.mp4 (75.28 MB)
MP4
154 - Get multiple data sets.mp4 (56.59 MB)
MP4
155 - Connecting multiple data sets together.mp4 (102.08 MB)
MP4
156 - The problems with direction of relationships between data sets.mp4 (59.71 MB)
MP4
158 - Practice Activity Number 18 The Solution.mp4 (60.47 MB)
MP4
159 - Filtering sorting and formatting fields.mp4 (84.97 MB)
MP4
160 - Hiding columns from Client Tools and other column tools.mp4 (81.52 MB)
MP4
161 - Refreshing or processing data.mp4 (44.98 MB)
MP4
162 - Perspectives.mp4 (70.01 MB)
MP4
163 - Creating quick measures.mp4 (31.87 MB)
MP4
164 - Hierarchies.mp4 (49 MB)
MP4
166 - Practice Activity Number 19 The Solution.mp4 (68.14 MB)
MP4
167 - NonVisual Totals.mp4 (40.15 MB)
MP4
168 - Show no data in rows and columns.mp4 (56.75 MB)
MP4
169 - Using formulas to query Data Model.mp4 (25.96 MB)
MP4
170 - DAX functions A useful Resource.mp4 (24.95 MB)
MP4
171 - Calculated columns an introduction.mp4 (69.62 MB)
MP4
172 - Basic operators.mp4 (14.45 MB)
MP4
173 - IF BLANK and ISBLANK.mp4 (114.86 MB)
MP4
174 - AND OR and NOT.mp4 (42.53 MB)
MP4
175 - SWITCH.mp4 (49.56 MB)
MP4
176 - Other functions.mp4 (22.56 MB)
MP4
178 - Practice Activity Number 20 The Solution.mp4 (177.04 MB)
MP4
179 - Measures an introduction with standard aggregations including Countblank.mp4 (99.64 MB)
MP4
180 - Aggregation of calculations.mp4 (85.62 MB)
MP4
181 - Other statistical functions.mp4 (50.18 MB)
MP4
183 - Practice Activity Number 21 The Solution.mp4 (114.95 MB)
MP4
185 - Rounding functions.mp4 (112.92 MB)
MP4
186 - Division functions MOD and QUOTIENT.mp4 (14.15 MB)
MP4
187 - SIGN and use with SWITCH and ABS.mp4 (63.92 MB)
MP4
188 - Exponential functions.mp4 (14.52 MB)
MP4
189 - Other functions.mp4 (20.59 MB)
MP4
191 - Practice Activity Number 22 The Solution.mp4 (101.03 MB)
MP4
192 - Text searching.mp4 (86.74 MB)
MP4
193 - Text extraction and substitution.mp4 (90.19 MB)
MP4
194 - Text conversion.mp4 (157.44 MB)
MP4
195 - Other functions.mp4 (12.18 MB)
MP4
197 - Practice Activity Number 23 The Solution.mp4 (80.56 MB)
MP4
198 - ISERROR and LOOKUPVALUE.mp4 (86.18 MB)
MP4
199 - Other functions.mp4 (25.66 MB)
MP4
201 - Practice Activity Number 24 The Solution.mp4 (64.52 MB)
MP4
202 - RELATED.mp4 (90.08 MB)
MP4
203 - RELATEDTABLE and COUNTROWS.mp4 (55.29 MB)
MP4
204 - Context.mp4 (53.54 MB)
MP4
205 - ALL.mp4 (75.99 MB)
MP4
206 - FILTER.mp4 (50.49 MB)
MP4
207 - CALCULATE.mp4 (29.3 MB)
MP4
208 - ALLEXCEPT.mp4 (84.41 MB)
MP4
209 - ALLSELECTED.mp4 (148.96 MB)
MP4
210 - Other functions.mp4 (27.34 MB)
MP4
212 - Practice Activity Number 25 The Solution.mp4 (70.27 MB)
MP4
13 - Source data requirements.mp4 (112.73 MB)
MP4
14 - Adding additional values.mp4 (84.2 MB)
MP4
15 - Recommended PivotTables.mp4 (28.5 MB)
MP4
16 - Moving PivotTable.mp4 (33.56 MB)
MP4
17 - Refresh PivotTable why it doesnt autoupdate.mp4 (37.43 MB)
MP4
18 - Extracting data.mp4 (71.55 MB)
MP4
19 - Sorting.mp4 (12.49 MB)
MP4
21 - Answer to Practice Activity 2.mp4 (24.52 MB)
MP4
213 - Date and Time Functions.mp4 (34.53 MB)
MP4
214 - Sort by Column.mp4 (51.88 MB)
MP4
215 - FIRSTDATE LASTDATE.mp4 (28 MB)
MP4
216 - Start of and End of.mp4 (52.83 MB)
MP4
217 - Previous and Next.mp4 (143.81 MB)
MP4
218 - DATESINPERIOD.mp4 (75.11 MB)
MP4
219 - DATESMTD DATESQTD DATESYTD TOTALMTD TOTALQTD TOTALYTD.mp4 (82.1 MB)
MP4
220 - Opening Balance and Closing Balance.mp4 (34.85 MB)
MP4
221 - SAMEPERIODLASTYEAR and PARALLELPERIOD.mp4 (82.48 MB)
MP4
222 - Other Time Intelligence Functions.mp4 (15.22 MB)
MP4
224 - Practice Activity Number 26 The Solution.mp4 (123.92 MB)
MP4
225 - Congratulations for finishing the course.mp4 (21.45 MB)
MP4
226 - Bonus Lecture.mp4 (52.73 MB)
MP4
22 - Adding additional row fields.mp4 (43.5 MB)
MP4
23 - Different layouts Compact Outline and Tabular.mp4 (65.83 MB)
MP4
24 - Blank Rows.mp4 (35.29 MB)
MP4
25 - Group Records.mp4 (69.17 MB)
MP4
26 - Showing or hiding additional detail the buttons.mp4 (47.67 MB)
MP4
27 - Adding columns.mp4 (73.79 MB)
MP4
28 - Adding page fields.mp4 (40.46 MB)
MP4
29 - Adding filters.mp4 (54.15 MB)
MP4
30 - Changing source.mp4 (43.66 MB)
MP4
31 - Using a table source.mp4 (56.1 MB)
MP4
32 - Other PivotTable Analyze options.mp4 (53.02 MB)
MP4
33 - Introduction to Practice Activity 3.mp4 (8.91 MB)
MP4
35 - Answers to Practice Activity 3.mp4 (65.8 MB)
MP4
36 - Change aggregate COUNT MIN MAX.mp4 (55.77 MB)
MP4
37 - Repeat All.mp4 (58.92 MB)
MP4
38 - Using Conditional Formatting to hide Repeat All.mp4 (68.81 MB)
MP4
39 - Grand Totals.mp4 (94.2 MB)
MP4
40 - Adding subtotals.mp4 (115.13 MB)
MP4
41 - Show items with no data.mp4 (38.83 MB)
MP4
42 - Other field settings.mp4 (104.41 MB)
MP4
44 - Answers to Practice Activity 4.mp4 (14.7 MB)
MP4
45 - Layout.mp4 (79.9 MB)
MP4
46 - Totals Filters and Alt Text.mp4 (62.93 MB)
MP4
47 - Display.mp4 (20.95 MB)
MP4
48 - Print.mp4 (73.21 MB)
MP4
49 - Data.mp4 (124.22 MB)
MP4
51 - Answers to Practice Activity 5.mp4 (14.28 MB)
MP4
52 - Create slicers.mp4 (26.05 MB)
MP4
53 - Identifying impossible options and selecting more than one option at once.mp4 (44.22 MB)
MP4
54 - Join to multiple PivotTables.mp4 (51.85 MB)
MP4
55 - Options.mp4 (48.31 MB)
MP4
57 - Answer to Practice Activity 6.mp4 (90.32 MB)
MP4
58 - Aggregates.mp4 (66.43 MB)
MP4
59 - Group by time period.mp4 (87.25 MB)
MP4
60 - Timelines.mp4 (61.46 MB)
MP4
62 - Answer to Practice Activity 7.mp4 (48.2 MB)
MP4
63 - Formatting number values.mp4 (37.58 MB)
MP4
64 - Custom Formatting number formatting.mp4 (65.4 MB)
MP4
65 - Custom Formatting dates and text.mp4 (148.01 MB)
MP4
66 - Custom Formatting sections and colors.mp4 (123.09 MB)
MP4
67 - Conditional Formatting Highlighting cells.mp4 (88.54 MB)
MP4
68 - Conditional Formatting Data Bars and Color Sets.mp4 (93.27 MB)
MP4
69 - Formatting printing.mp4 (83.71 MB)
MP4
70 - Styles.mp4 (68.92 MB)
MP4
72 - Answer to Practice Activity 8.mp4 (63.9 MB)
MP4