Use methods to optimize performance in Power Query including early filtering, choosing the correct data types and using parameters.
Learn how to use different Excel commands to increase control of the spreadsheet.
See how Power Query is used to prepare, clean, manipulate and transform data prior to output into Excel tables and PivotTables.
Learn how to import raw data from different Excel locations into Power Query.