{"product_id":"268295_acca-learning-china","title":"Power Query","description":"\u003ch2\u003eWhat you will learn\u003c\/h2\u003e \u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003ehow to extract, transform and load data using Power Query from a range of sources\u003c\/li\u003e\n\u003cli\u003ehow to merge and combine data to create integrated tables\u003c\/li\u003e\n\u003cli\u003ehow to format and transform ’dirty’ data into a usable form to enable analysis\u003c\/li\u003e\n\u003cli\u003ean understanding of the Mashup (M) code behind Power Query.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch2\u003eAbout this course\u003c\/h2\u003ePower Query will allow you to transform data into information using an intuitive interface which will record the steps taken so that they can be adapted and applied to new datasets. Learn how you can stop wasting time on repetitive data cleansing tasks. Using hands-on examples throughout, you will learn how to convert vast amounts of data into key business information efficiently.\u003cbr\u003e\n\u003cbr\u003e\nPlease note, this is the same course featured in the Power Query, Power Pivot and Power BI pack.\u003cp\u003e \u003c\/p\u003e\u003ch4\u003eKey information\u003c\/h4\u003e\u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003eThis course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.\u003c\/li\u003e\n\u003cli\u003eThis course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).\u003c\/li\u003e\n\u003cli\u003eThe recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.\u003c\/li\u003e\n\u003cli\u003eThis course requires you to have a basic understanding of Microsoft Excel.\u003c\/li\u003e\n\u003cli\u003eCPD certificate is available upon successful completion of the course.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\n\u003cimg alt=\"ACCA SumProduct joint logo\" src=\"${PICTURE_CONTEXT_PATH}ckeditor_uploads\/ACCA_SumProduct_sml_470578.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning-china","offers":[{"title":"Standard price \/ 0","offer_id":46008501469435,"sku":"100184","price":120.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":46008501567739,"sku":"100184","price":120.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":46008501534971,"sku":"100184","price":120.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":46008501502203,"sku":"100184","price":120.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/shutterstock_483694630__1__209512_317c9102-e6da-471b-9d6a-49e9dfb8428b.jpg?v=1780722072","url":"https:\/\/acca-learning.myshopify.com\/products\/268295_acca-learning-china","provider":"acca-learning","version":"1.0","type":"link"}