Microsoft Excel Power Query Training
Excel Power Query Training
We offer private group Excel Power Query training on site at our clients office or at our office in London. We specialise in on-site training and are geared-up to bring the classroom to your site nationwide . Users can use their own laptops or we can bring along a suit of training laptops for your users to use.
Alternatively, we also offer Virtual group training via Zoom or MS teams and are particularly effective for companies working from home or individuals working in different locations.
We deliver:
- Agreed customised topics to suit your group’s learning requirements
- Group sizes to suit your team’s needs
- A qualified instructor who will be flexible in her/his approach and will engage well with your team
- Post Course help and support
Contact Us Today
Introduction Excel Power Query (1-Day)
Overall, this course aims to import, tidy up, transform data and output a workable clean dataset for analysing.
By the end of the session you will be able to:
- Firstly, understand what Power Query and Power Pivot is
- Identify where in the data analysis process Power Query sits
- Import data from various sources
- Restructure and transform data ready for output
- Finally, loading data to a Table Query, Create a Connection only and add to the Data Model
Introduction Excel Power Query Course Outline
Introduction
- What is it?
- The Interface
- Data Sources
- Overview of Process (Txt Import to Load and Refresh)
Importing Data
- Excel Tables
- Excel Workbook
- CSV and Txt Files
- Web Sites
- From Folder
Restructure and Transform Data
- Remove Columns/Rows
- Add Columns
- Format Columns
Load Data & Refresh
- Table
- Connection Only
- Data Model
- Refresh
Additional Transformations
- Merge and Append
- UnPivot
In-Person: 09:30 – 16:30
Virtual: 09:00 – 15:30
| Virtual Classroom | In person on client’s site delivery | In person at our training centre |
|---|---|---|
| 1 user £499 + VAT | 1 user £499 + VAT | 1 user £499+ VAT |
| 2 to 3 users £850 + VAT | 2 to 3 users £899 + VAT | 2 to 3 users £999 + VAT |
| 4 to 6 users £999 + VAT | 4 to 6 users £1,099 + VAT | 4 to 6 users £1,199 + VAT |
| 7 to 8 users £1,199 + VAT | 7 to 8 users £1,299 + VAT | 7 to 8 users £1,499 + VAT |
| – | 9 to 10 users £1,499 + VAT | 9 to 10 users £1,599 + VAT |
To discuss our availability, please call 020 7183 7740 or email enquiries@weareexcel.co.uk
TO BOOK or to discuss our Power Query training in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk
Read here what our customers have said about our Excel Power Query Training courses!
Intermediate Excel Power Query (1-Day)
(VIRTUAL ONLY)
Overall, this course aims to import, tidy up, transform data and output a workable clean dataset for analysing.
By the end of the session you will be able to:
- Restructure and transform data ready for output
- Writing/editing M queries in the advanced query editor
- Parameters and Custom functions
- Group By queries
Intermediate Excel Power Query Course Outline
- Merge queries – understanding inner/outer joins
- Example that combines multiple Excel workbooks from OneDrive/SharePoint folder
- Using data in Excel to filter the Power Query when refreshing (such as entering folder path in a cell)
- Group By queries
- Dynamically refer to columns by position rather than specific column name
- Writing/editing M queries in the advanced query editor
- Parameters and Custom functions
- Useful List functions
Virtual: 09:00 – 15:30
| Virtual Classroom |
|---|
| 1 user £499 + VAT |
| 2 to 3 users £850 + VAT |
| 4 to 6 users £999 + VAT |
| 7 to 8 users £1,199 + VAT |
To discuss our availability, please call 020 7183 7740 or email enquiries@weareexcel.co.uk
TO BOOK or to discuss our Power Query training in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk
Our Approach
Microsoft Excel Power Query training is a specialty of ours. Subsequently, we pride ourselves on covering these Business Intelligence topics in Excel very well. Furthermore, we will not let the subject go over anyone’s head (we feel strongly about this); therefore a potentially complex subject is always broken down into understandable sections which each build on one another as the training course unfolds.
- In-person at our training centre in Liverpool Street, London
- Onsite (in-person) private group courses at customers office
- Virtual/online training via Zoom or MS Teams
