Power Query Training | Live Online or Onsite

Introduction to Power Query – 1 Day Course

Apologies - this course is not currently available.

Established in 2005, Blue Pecan delivers Excel Power Query training at customers' business premises or online. Our one day Power Query training course gives delegates a good introduction to Power Query as a data connection technology. Delegates will learn how to discover, connect, combine, and refine data sources and so meet their data analysis requirements.

Introduction to Power Query - 1 Day Course

Power Query allows you to automate data tasks in three stages: extract, transform and load. This course gives a comprehensive introduction to these tools. By the end of the course, delegates will be able to effectively extract data from Excel workbooks, CSV and text files, Access databases and folders. Delegates will also be able to effectively clean, integrate and enrich data. Finally, delegates will be able to load data to a connection, an Excel table or a Pivot report. Download the course outline in pdf format.

Navigate the Power Query Editor (PQE)

Query Settings task pane
Formula bar
Query dependencies

Select the Source Data for Your Query

Table/Range in current workbook
Data in another workbook
Text/CSV files
Files in folder
Access database
Blank query
Existing connections
Referencing existing queries

Close and Load Queries

Load to a table
Load to PivotTable or Pivot Chart
Only create connection
Add to data model

Edit a Query

Edit a query – launch the PQE
Understand steps in the Query Settings task pane
Delete steps
Modify steps
Name/rename a query
Delete a query
Refresh a query

Transformations

Change a field’s data type
Remove rows/columms
Move to the top or bottom of a worksheet
Change a field’s data type
Remove rows/columns
Split columns
Merge columns
Sort columns
Filter columns
Perform calculations on columns
Create conditional column
Create new columns by example
Group columns
Fill data
Use first row as headers
Extract text
Trim/clean
Change case
Create index

Append Data

Append all tables in the current workbook
Append specific worksheets within the current workbook
Append all worksheets in an external workbook
Append specific worksheets from an external workbook

Combine Files in a Folder

Combine files in a folder where the sheet or table name are the same
Combine files in a folder where neither the sheet or table name are the same
Import Text/CSV files within a folder

Other Transformations

Merge data across tables
- Match columns
- Select the correct join kind
Pivot data
Unpivot data

Share Queries

Export a query as a connection file
Import a query as a connection file

M Functions and M Language

View the M code for your query
Write M formula
Use M Text functions
Use M Date functions
Use more M functions
- CurrentWorkbook
- Workbook
- Combine

We deliver Excel Power Query training to businesses in Berkshire, Buckinghamshire, East Sussex, Essex, Dorset, Hampshire, Hertfordshire, Kent, London, Oxfordshire, Surrey, West Sussex & Wiltshire.

ON-SITE OR ONLINE TRAINING
info@bluepecan.co.uk
0800 612 4105

          
   Tina McGrath 
 
 
 
   Chester was a great trainer, I personally learnt so much in one day and it was all down to his calm, friendly demeanour and huge knowledge - we covered many areas which will help us to develop ourselves and the work we do.  Thank you Chester, was lovely to meet you :-)
  
 
 
       
   emmie BL 
 
 
 
   Myself and my team had an absolutely fab day with Chester going over excel - it was quite revelatory, with lots of really helpful hints & tips, great clear explanations and plenty of time to ask questions. Being able to work on things in real time, use our own data spreadsheets and his practice ones and have things properly explained has been so useful. Chester's a great instructor/facilitator - pitches to your needs and is very flexible. I would completely recommend him if you're needing to get a grip on all things excel!
Thanks very much, Chester!
  
 
 
       
   Martyn Lee 
 
 
 
   Chester was a great tutor understanding our needs and allowing time to understand and digest. Great humor too which always lightens a training day. Look forward to another session soon.
  
 
 
       
   Angus Brown 
 
 
 
   Detailed, informative and fun, Chester made the class enjoyable and engaging - i have learnt a huge amount from the time we had together
  
 
 
       
   Sisii de Winter 
 
 
 
   We booked Chester for several in-house training sessions including Fundamentals, Intermediate and Advanced Excel. He was brilliant with each, very inclusive and patient with all team members. Would fully recommend.
  
 
 
       
   Lucy Maxwell Scott 
 
 
 
   A great online one on one intermediate training session in excel - the tools and activities Chester has developed and used are great.  His teaching style was highly responsive to my needs (applications I wanted, my learning style).  I would strongly recommend him - whatever your level of excel expertise and whatever level you are aiming for!
  
 
 
       
   Louise Walpole 
 
 
 
   The online Excel Intermediate course I attended was really high quality. It was pitched at the right level with opportunity to work through examples as part of the course. Course material and follow up support has been excellent. I would highly recommend.
  
 
 
       
   Savannah Baldry 
 
 
 
   Excellent training with Chester who's both knowledgeable and a great teacher. He takes the time to make sure you've understood before moving on and I was lucky enough to get some bespoke training specific to my needs. Thanks very much
  
 
 
       
   ECA Account 
 
 
 
   I had an intermediate/bespoke excel course with Chester back last year, and enjoyed it so much and thought so highly of the course, I subsequently arranged beginners, fundamentals, intermediate excel courses and Microsoft PP/word courses for my colleagues. Even in a virtual setting Chester is clear in his delivery and guidance, exceptionally knowledgeable, and very adaptable to ever changing attendee lists or capabilities and requirements within the team. It will be great to put our new skills to good use. My advise to people, would be to take notes!

Thanks Chester! Kathryn P.
  
 
 
       
   Roofing Contractors Cambridge Ltd 
 
 
 
   An employee recently completed an online days training with Chester. He thoroughly enjoyed it and had a great learning experience. Fully recommend Blue Pecan Computer Training and would definitely use them again for future training.
  
 
 
  
  Load more