{"product_id":"1104768_acca-learning","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\u003cimg alt=\"ACCA SumProduct joint logo\" src=\"${PICTURE_CONTEXT_PATH}ckeditor_uploads\/ACCA_SumProduct_sml_3168170.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning","offers":[{"title":"Standard price \/ 0","offer_id":45282214838523,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":45282214871291,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":45282214904059,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":45282214936827,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/Image___financial_modelling_1078647_778ab328-cfe6-4f42-b773-fc66d979a5d7.jpg?v=1780723148","url":"https:\/\/acca-learning.myshopify.com\/products\/1104768_acca-learning","provider":"acca-learning","version":"1.0","type":"link"}