Power Query and Get & Transform: Intermediate - eLearning
This activity is published by accountingcpd.
All year round, and on every accountingcpd purchase you make, get 10% off as a CA ANZ member. Just use code CAANZ101.
Please note you will be directed to accountingcpd to purchase this product
If you're looking to take your knowledge and application of Power Query to the next level, this course will enable you to do just that. You will look at adding custom, index and conditional columns, as well as using the Column from Examples feature. This course also covers the basics of JSON, working with records and lists, duplicating queries, and changing the source file.
Upon satisfactory completion of this activity you will be able to:
•Add custom, index and conditional columns to your data.
•Confidently transform data structures.
•Understand the basics of reading and writing Mashup (M).
•Use parameters and custom functions.
Elevate your Power Query skills by going beyond simple use cases and using it in more sophisticated ways.
No materials distributed.
Topic: Business Mindset
Sub-Topic: Information & Communication Technology
Proficiency Level: Intermediate, Advanced
CPD: Upto 4 hours