Power Query Workshop

Duration

3 hours

Power Query Workshop

Power Query is a super powerful tool in Excel that can combine data from different sources, clean it up, and transform it into a well structured format—all without needing to write any code.

It replaces the need for LOTS of formulas, and can make your processes quicker and more robust.

It can be a game changer for the way you work with Spreadsheets!!

The Workshops will be delivered 1 Hour each Week.

Content of this workshop

Workshop 1 : Introduction / Create Queries / Power Query Editor / Load Options / Data Types / Basic Transformation Steps / Refresh Power Query

Workshop 2 : Accessing Power Query Editor / ‘M’ Code & Advanced Editor / Intermediate Transformation Options

Workshop 3 : Updating Links to files / folders / Advanced Transformation Options / Troubleshooting in PQ

Duration

3 hours

Book a Power Query Workshop

Our free and premium Excel products
can help you save time and money!

Excel Ace templates are easy to use and can be customised to your specific needs.
Get started today and see the difference our products can make!

Premium
Products

A range of ACE ready made products, from book-keeping to absence tracking, which you can use straight away to help keep your business moving.

Find Out More

Free Excel
Downloads

Take a look at our range of Free Products ready to download and use today

Find Out More

Sign up for our newsletter today and get FREE Excel tips, along with all the latest Excel Ace news, delivered straight to your inbox.

WEBSITE BY FARM FACTORy

Power Query Workshop