{"product_id":"1100755_acca-learning","title":"PivotTables","description":"\u003ch2\u003eWhat you will learn\u003c\/h2\u003e \u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003ehow PivotTables turn data into information\u003c\/li\u003e\n\u003cli\u003ehow to master creating formulae out of PivotTables in seconds\u003c\/li\u003e\n\u003cli\u003ean understanding of how to sort, group and filter elements others tell you can’t be done\u003c\/li\u003e\n\u003cli\u003ePivotTable formatting\u003c\/li\u003e\n\u003cli\u003ean understanding of how Calculated Fields and PivotCharts can make great interactive dashboards.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch2\u003eAbout this course\u003c\/h2\u003eThis course dives deep into one of the most powerful data presentation tools available to Excel.  There are no pre-requisites prior to taking this course.  At the end of this course, you should be confident in producing quality PivotTables and PivotTable dashboards that will efficiently provide solutions for data analysis.\u003cbr\u003e\n\u003cbr\u003e\nThis course presents the key points in building PivotTables using video guides and Excel walkthrough files. It will highlight key mistakes and design aspects to avoid when creating PivotTables, and give insight on the design approaches to take to ensure that your PivotTables are not only robust, but efficiently highlight trends in data. We also give you tips on what sort of Tables to create depending on the type of data you are working with. Covering what a PivotTable is, how to format and set value fields, apply filters, grouping and slicers, create PivotCharts and develop an interactive dashboard.\u003cp\u003e \u003c\/p\u003e\u003ch4\u003eKey information\u003c\/h4\u003e\u003cul\u003e\n\u003cli\u003eThis course contains a collection of 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_3168132.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning","offers":[{"title":"Standard price \/ 0","offer_id":45366660104443,"sku":"100184","price":150.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":45366660137211,"sku":"100184","price":150.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":45366660169979,"sku":"100184","price":150.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":45366660202747,"sku":"100184","price":150.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/Image___financial_modelling_1078647_72f938ed-b167-47cd-a894-c43405319036.jpg?v=1780723195","url":"https:\/\/acca-learning.myshopify.com\/products\/1100755_acca-learning","provider":"acca-learning","version":"1.0","type":"link"}