MS Power Query for Excel

Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more. 

With Power Query, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. 

Course Structure 

1 x 2.5hr live webinar per week for 2 weeksLive webinars will be recorded and uploaded to the eLearning platform where delegates will be able to review them.   

Hands on Online Course 

Real world data sets 

Instruction manual to complete online examples 

Post course-exercises 

Post-course instructional videos 

Access to presenter for a 1 month period after the course for Power Query related questions. 

 

Who should attend? 

Anybody that imports data into Excel 

Anybody that analyses data in Excel 

Analysists, accountants, auditors, payroll, CFOs, database administrator, marketing, sales, traders (equity, commodities, derivatives), developers, budgeting, risk analysts, insurance, bankers… anybody that works with data. 

 

Requirements 

Excel 2016, 2019 or Excel 365 Desktop on a Windows Installation. 

Excel 365 for Web not allowed. 

Power Query on Mac won’t be officially supported on the course.  Power Query on Mac lags behind the Windows functionality.  

Be able to download practice files from external site (Icap Training Solutions’ website).  Some IT departments may have disabled access to external sites. 

two monitor setup is recommended 

1 Monitor for the Presentation 

1 Monitor for Excel. 

 

Excel skills requirements 

Excel intermediate/advanced users 

Good working knowledge of the following: Excel tablesPivot TablesNamed ranges 

Contact Us For More Info