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!!
Week 1 : Introduction / Create Queries (From File) / Power Query Editor / Data Types / Basic Transformation Steps / Properties / Load Options / Accessing Power Query Editor / Refresh Power Query / Append
Week 2 : Create Queries (From Folder) / Intermediate Transformation Options / ‘M’ Code & Advanced Editor (with AI) / Merge Queries / Referencing & Duplicating
Week 3 : Add Column / Merge Column / Troubleshooting in Power Query / Updating Links to files and folders / Fill / Pivot / Unpivot / Create Groups
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
