Advanced Microsoft Power Query and Power PivotWoodthorpe IT Solutions
If you need to connect to multiple data sources of various types and then analyse the results, then Microsoft Power Query and Power Pivot are the tools of choice.
Power Query and Power Pivot are free add-ins for Microsoft Excel – they significantly extend the functionality of Excel. With these tools you are able to connect to a wide variety of data sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and more. Once the data source(s) is connected to Power Pivot, users can build simple or more complex data models for analysis purposes. Because Power Query and Power Pivot are built directly into the Excel platform, most users feel comfortable with them from day one as their interfaces both closely align with Excel’s look and feel.
Why Woodthorpe IT Solutions?
Suitability - Who should attend?
Attendees should have experience within Microsoft Excel before they attend this course.
Our tutors are very patient and will ensure all attendees leave with increased confidence.
Outcome / Qualification etc.
Each attendee will be able to manipulate data quickly using Power Query and present it using Power Pivot. They will receive an electronic attendance certificate.
Training Course Content
During this 2 day training course you will learn:
The cost for this in-house training is £700+VAT per day.
What is included?
What is not included?
Get Inspired! Watch the Video
Woodthorpe IT Solutions specialise in delivering onsite Microsoft Office training and providing consultancy support to businesses. We are a small and dedicated team who travel the length and breadth of the country providing our service. We have worked, and continue to work for companies such as Burberry, DeBeers, LVMH, John Lewis, Asics and many more.
Provider: Woodthorpe IT Solutions
Woodthorpe IT Solutions - Microsoft Office Training and Consultancy
We are here to help you get the most from Microsoft Office, our industry experts entertain and teach during any day we deliver for you. No question is too small or problem too big for us to help you with, we...
Find a course for you!
Find out more about this Advanced Microsoft Power Query and Power Pivot course - simply fill out your details:
Find more courses here