Excel – Power Query Short-Shot

Price: $150.00

Days: 0.5

Course Dates:

October 14 , December 16 , February 17

Learn Excel – Power Query Short-Shot

Manage your information all in one

Excel – Power Query Short-Shot

Course EXPQ: 0.5 Days; Instructor-led by Michael Ouchi (Master Office Instructor)

 

PowerQuery is the data transformation capacity of Excel. Introduced in Excel 2013, PowerQuery will allow you to shape and transform data from single and multiple datasources.

  • Connect to a single or multiple datasources
  • Shape and transform queries
  • Merge two queries together
  • Add custom columns to queries
  • Transform columns in queries
  • Unpivot queries