Curriculum
- 5 Sections
- 40 Lessons
- 1100 Days
Expand all sectionsCollapse all sections
- Power Query24
- 2.1Power Query Intro and Excel version3 Minutes
- 2.1Power Query and Query Editor Ribbon9 Minutes
- 2.1Trim5 Minutes
- 2.1Format Dates and Values2 Minutes
- 2.1Parsing URLs5 Minutes
- 2.1Split Text Fields10 Minutes
- 2.1Group By3 Minutes
- 2.1Import From Folder8 Minutes
- 2.1Doing Auto Cleanup8 Minutes
- 2.1Extract Data from Forms13 Minutes
- 2.1Extract – Multiple Criteria5 Minutes
- 2.1Extract Multiple Worksheets4 Minutes
- 2.1Unpivoting Columns5 Minutes
- 2.1Pivoting Columns2 Minutes
- 2.1Split Columns into Other Columns4 Minutes
- 2.1Filtering Rows5 Minutes
- 2.1Sorting Columns2 Minutes
- 2.1Transform and Add Columns7 Minutes
- 2.1Intro to Joins4 Minutes
- 2.1Merging8 Minutes
- 2.1Full Outer Join6 Minutes
- 2.1Right Anti Join9 Minutes
- 2.1Convert Reports into Pivot Tables5 Minutes
- 2.1Modulo6 Minutes
- M Language12
- 3.1M Introduction3 Minutes
- 3.1Enabling M in Power Query2 Minutes
- 3.1Simple Expressions8 Minutes
- 3.1Simple Expressions – Nested Expressions3 Minutes
- 3.1Variables8 Minutes
- 3.1Functions6 Minutes
- 3.1Functions – Reusable Functions2 Minutes
- 3.1Functions – Invoking1 Minute
- 3.1Passing Functions9 Minutes
- 3.1Passing Functions – keyword each3 Minutes
- 3.1Finding the list of M functions2 Minutes
- 3.1Using M Functions10 Minutes
- Resources2
- Resource1
- Premium Certificate & Transcript1