Introduction:

Power Query is the FREE Excel add-in from Microsoft that will help transform and manipulate your data into a format that is ready for PivotTables, reports, and so much more.

What Will You Learn:

Upon successful completion of this program, participants will be able to:

• Delete rows, columns, or blanks;
• Filter out data you don’t need;
• Fix the layout so it will work in a PivotTable;
• Split or join columns or text;
• Remove spaces and special characters from your data;
• Merge worksheets, text/CSV files together;
• Extract data from an external database;
• Incorporate the next month’s data to an existing report.

Who Should Attend:

This program is designed for below users:

• Excel users – Users that employ Excel on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools to improve their reporting and data crunching capabilities.
• IT & BI Specialists – Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources.

Pre-requisites:

• Participants must have at least advanced knowledge & skill in Microsoft Excel;
• Preferable having PivotTable and PivotChart skills.