Power Query
Enquire About This Course
Power Query is a business intelligence tool available in Excel that you can use to clean & prepare your data, then perform data analysis & create sophisticated data models.
We are currently delivering our Excel Power Query courses via:
Why Use Power Query?
- With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, making it ready for output/ visualisation
- Import/ load data from a wide range of sources - you can connect to & incorporate multiple data sources in a single report - inc other excel files. CSV files, SQL, Online databases, etc
PREREQUISTES
- A working knowledge of Windows is required
- A good working knowledge of excel is required - including: creating & formatting simple spreadsheets with basic formulas using + - * / and using basic, using basic functions inc SUM, COUNT, AVERAGE, etc
- OR attendance of our Excel Introduction/ Intermediate Courses
Enquire About This Course