{"product_id":"268265_acca-learning-china","title":"Power Pivot","description":"\u003ch2\u003eWhat you will learn\u003c\/h2\u003e \u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003ehow to load, link and update data in Power Pivot\u003c\/li\u003e\n\u003cli\u003ehow to write formulae in Power Pivot’s Data Analysis Expressions (DAX) language\u003c\/li\u003e\n\u003cli\u003ethe use of Time Intelligence functions to analyse data across periods.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch2\u003eAbout this course\u003c\/h2\u003ePower Pivot is more than just a more powerful version of PivotTables. Power Pivot includes a Data Model which allows you to build relationships between data tables and create PivotTables from multiple data sources. Using hands-on examples throughout, you will learn how to create a data model, manage relationships between data tables and create integrated dashboards.\u003cp\u003e \u003c\/p\u003e\u003ch4\u003eKey information\u003c\/h4\u003e\u003cul\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_470566.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning-china","offers":[{"title":"Standard price \/ 0","offer_id":46008561467643,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":46008561565947,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":46008561533179,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":46008561500411,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/shutterstock_483694630__1__209512_a8404047-06ca-4728-8daf-0e0fa41c72c3.jpg?v=1780723276","url":"https:\/\/acca-learning.myshopify.com\/products\/268265_acca-learning-china","provider":"acca-learning","version":"1.0","type":"link"}