• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Power Query Syllabus Sales

You are here: Home / Excel Power Query Syllabus Sales

Excel Power Query Course Syllabus - 6hrs 33min


Session 1: Introduction 0:10:04

1.01 What is Power Query 0:03:11
1.02 Installing Power Query 0:02:23
1.03 Interface 0:04:30

Session 2: Data Sources1:04:29

2.01 From Web 0:06:35
2.02 From Excel File 0:07:41
2.03 From Current Workbook 0:05:02
2.04 From CSV or Text File 0:03:29
2.05 From Folder 0:11:41
2.06 From Database (SQL) 0:06:53
2.07 From Other Sources (OData Feed) 0:02:13
2.08 Data Catalog Search 0:05:22
2.09 From OneDrive and SharePoint Online 0:15:33

Session 3: Combining Multiple Sources 0:37:18

3.01 Multiple Excel Tables or Named Ranges 0:03:33
3.02 Worksheets not Correctly Formatted 0:07:00
3.03 Appending Queries 0:07:24
3.04 Merging Queries 0:15:18
3.05 Query Dependencies View 0:04:03

Session 4: Transforming and Cleaning Data 1:52:27

4.01 Editing Queries 0:02:47
4.02 Data Types 0:03:17
4.03 Fixing Dates with the Locale Setting 0:04:45
4.04 Columns - Move, Remove, Rename & Duplicate 0:02:34
4.05 Splitting Columns and Extracting Text 0:09:08
4.06 Merging Columns 0:01:24
4.07 Filtering Rows 0:04:55
4.08 Remove Duplicates & Errors 0:03:23
4.09 Sorting 0:01:56
4.10 Replace & Fill 0:01:58
4.11 Transforming Text & Numbers 0:03:19
4.12 Transforming Dates 0:05:35
4.13 Adding Custom & Index Columns 0:07:43
4.14 Adding Custom Calculated Columns 0:04:25
4.15 Adding Custom Date & Time Columns 0:05:49
4.16 Grouping 0:06:28
4.17 Unpivot 0:17:09
4.18 Transpose 0:02:53
4.19 Duplicating & Referencing Another Query 0:03:53
4.20 Add Column From Examples 0:05:49
4.21 Reuse and Share Queries 0:09:18
4.22 Data Profiling 0:03:59

Session 5: Data Destinations & Refereshing Queries 0:17:51

5.01 Loading to the Workbook Options 0:05:54
5.02 Loading to the Data Model or Power Pivot 0:04:20
5.03 Load Settings & Automatic Refresh 0:02:40
5.04 Load Directly into Power Pivot in Excel 2010 0:04:57

Session 6: M Language 1:05:48

6.01 Introduction to M 0:02:24
6.02 Where to Edit and Write M 0:02:59
6.03 Using a Function to add a Custom Column 0:07:58
6.04 Reading M 0:05:52
6.05 Writing M 0:03:34
6.06 Type System 0:02:45
6.07 Lists and Records 0:08:33
6.08 Splitting Text 0:06:19
6.09 Tips for Writing M 0:05:43
6.10 Commenting Code 0:01:52
6.11 Error Trapping 0:04:12
6.12 if and Nested if Function 0:04:03
6.13 Replicating IF OR and IF AND in Power Query 0:05:28
6.14 Conditional Columns 0:02:56

Session 7: Parameter Tables & Custom Functions1:24:36

7.01 Parameter Tables for Filtering 0:11:08
7.02 Scrape Data from Multiple Web Pages 0:10:32
7.03 Dynamic Folder Paths 0:11:39
7.04 Dynamic File Paths 0:08:07
7.05 Formula Firewall Errors 0:05:26
7.06 Manage Parameters 0:13:10
7.07 Variables 0:08:08
7.08 Add or Expand Rows 0:08:26
7.09 Referencing Another Query in M Code 0:08:02
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x