EXCELACE ALL RIGHTS RESERVED.
WEBSITE BY FARM FACTORy
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!!
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
3 hours
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.
Take a look at our range of Free Products ready to download and use today
EXCELACE ALL RIGHTS RESERVED.
WEBSITE BY FARM FACTORy
