Join us for a session to illustrate how the capturing & processing of data can be automated through Excel’s Power Query tool.
What is Power Query
- Where to find Power Query in Excel.
- Scenarios where Power Query can be used.
Using Power Query
- How to import data into Power Query.
- Transform problematic data using Power Query e.g. remove/replace incorrect data
- add custom columns
- merge or split columns
- set data types – text, number, date
- Refreshing a Power Query
Other Power Query Types:
- Folder Queries
- Unpivoting Data
Speaker - Niamh Loftus
https://www.linkedin.com/in/niamhloftus/
Niamh has over 22 years of training experience and in addition to training services, is a developer of bespoke Excel and Power BI solutions, working with clients to get the most out of their data.
Email: training@smartskills.ie