Course curriculum

  • 1

    Power Query Extracting

    • Exercise File

    • Power Query _Evolution

      FREE PREVIEW

    • Extract CSV File

    • Extract Data Base File

    • Power Query _Extract_Current Workbook

    • Power Query _Extract_Web Page

    • Power Query _Extract_Excel file Power BI

    • PowerQuery_Compare To VBA and SQL

    • Power Query_Closed-Loop

    • PowerQuery_ETL language

    • Power Query _Extract_Excel file Excel 2019
  • 2

    Power Query Transform

    • Power Query _Transform_Cleaning_Data Type

    • Transform - Data cleaning - Date

    • Transform - Data cleaning - Fill Down and Grouping

    • Transform - Data cleaning - Row and Column

    • Transform - Data enrichment - Split_Trim and Number To Text

    • Power Query _Transform_Enrichment_Formula and IF

    • Transform - Data enrichment - Number To Text Function
  • 3

    Power Query Integration

    • Transform - Data Integration - Append CSV folder

    • Transform - Data Integration - Append Current Workbook and Unpivot

    • Transform - Data Integration - Append Current Workbook PrintArea

    • Transform - Data Integration - Append Excel folder

    • Transform - Data Integration - Workbook _Unpivot

    • Transform - Data Integration - Append Workbook Mismatched Headers

    • Transform - Data Integration - Merge with multiple fields

    • Transform - Data Integration - Merge 6 Ways

    • Appending Multiple Worksheet Folder