Excel 2016

Hi Maylene,

Thank you for the forum question.

PowerQuery in Excel 2016 is a very new interesting tool.

PowerQuery works fine together with PowerPivot. The imported tables can be added to the data model in PowerPivot. All queries will be in Excel in dynamic ranges which can be used in PowerPivot reports.

You have more options to link to external data sources using PowerQuery than PowerPivot.

I have found some interesting videos on YouTube which can be useful to understand PowerQuey.


https://www.youtube.com/watch?v=Jzt-I4mt8sQ

https://www.youtube.com/watch?v=tObdiGDDNds

https://www.youtube.com/watch?v=zjnFKS9iXPs

The link below is to Microsoft's introduction to PowerQuery

https://support.office.com/en-us/article/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector