🏡

Power Query and M in Excel

Outline: Outline
Training Material:

DayModulesSharing
1
  • Power Query Basics
  • Power Query and Query Editor Ribbon
  • Understanding Column-Level Actions
  • Understanding Table Actions
  • Importing Data from Files
  • Importing Data from Database Systems
  • Getting data from The Web
  • Managing Data Source Settings
  • Data Profiling with Power Query
  • Rename Columns
  • Replace Values
  • Change Column Type
  • Sort Column
  • Filter Records
  • Split Columns
  • Reduce Rows
  • Reorder Columns
  • Insert Index Column
  • Promote/Demote header
  • Completing Common Transformation Tasks
  • Creating Custom Columns
  • Grouping and Aggregating Data
  • Working with Custom Data Types
2
  • Transpose
  • Pivot/Unpivot
  • Advanced Editor
  • M Expressions
  • M Functions
  • Passing M Functions
  • M Variables
  • Creating and Using a Basic Custom Function
  • Creating a Function to Merge Data from Multiple Excel Files
  • Creating Parameter Queries
  • Automation in Excel VBA
  • Script to involve M script in VBA code
  • Trigger the activation of M script in VBA
  • Getting Quick Information from the Queries & Connections Pane
  • Organizing Queries in Groups
  • Selecting Columns in Queries Faster
  • Renaming Query Steps
  • Quickly Creating Reference Tables
  • Viewing Query Dependencies
  • Setting a Default Load Behavior
  • Preventing Automatic Data Type Changes
  • Disabling Privacy Settings to Improve Performance
  • Disabling Relationship Detection

Recommanded Books
TitleCollect, Combine, and Transform Data Using Power Query in Power BI and Excel, Second Edition
ISBN978-0-138-11586-9
AuthorDaniil Maslyuk; Gil Raviv
Year2025
Publisher Microsoft Press
TitleThe Definitive Guide to Power Query (M): Mastering Complex Data Transformation with Power Query
ISBN978-1-835-08972-9
AuthorGregory Deckler, Rick de Groot, Melissa de Korte
Year2024
Publisher Packt Publishing
TitleMastering Power Query in Power BI and Excel: Learning real-world Power Query and M Techniques for a better data analysis
ISBNB09DTLC4S2
AuthorReza Rad, Leila Etaati
Year2021
Publisher RADACAD Systems Limited
TitleCollect, Combine, and Transform Data Using Power Query in Excel and Power BI
ISBN978-1-509-30795-1
AuthorGil Raviv
Year2018
Publisher Microsoft Press
TitleExcel Power Pivot and Power Query for dummies
ISBN978-1-119-84448-8
AuthorMichael Alexander
Year2022
Publisher For Dummies; 2nd edition
TitlePro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
ISBN978-1-484-28577-0
AuthorAdam Asprin
Year2022
Publisher Apress
TitlePower Query Cookbook: Use effective and powerful queries in Power BI Desktop and Dataflows to prepare and transform your data
ISBN978-1-800-56948-5
AuthorAndrea Janicijevic
Year2021
Publisher Packt Publishing
TitleLearn Power Query: A low-code approach to connect and transform data from multiple sources for Power BI and Excel
ISBN978-1-839-21971-9
AuthorLinda Foulkes, Warren Sparrow
Year2020
Publisher Packt Publishing
TitleData Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
ISBN978-1-484-26017-3
AuthorAdam Aspin
Year2020
Publisher Apress
TitleMaster Your Data with Power Query in Excel and Power BI
ISBN978-1-615-47358-8
AuthorKen Puls;Miguel Escobar
Year2019
Publisher Holy Macro! Books
TitleCleaning Excel Data With Power Query Straight to the Point
ISBN978-1-615-47149-2
Author Du Soleil, Oz
Year2019
Publisher Independent Publishers Group
TitleCollect, Transform and Combine Data using Power BI and Power Query in Excel
ISBN978-1-509-30795-1
AuthorGil Raviv
Year2018
Publisher Microsoft Press