• 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
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • 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

Blog Categories

  • 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
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

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.