{"product_id":"213347_acca-learning-china","title":"Charts and dashboards","description":"\u003ch2\u003eWhat you will learn\u003c\/h2\u003e\u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003ethe types of charts that are available in Excel and when to use them\u003c\/li\u003e\n\u003cli\u003ehow to present data effectively\u003c\/li\u003e\n\u003cli\u003ehow to create bespoke and dynamic charts, using the latest Excel functions\u003c\/li\u003e\n\u003cli\u003ehow to create effective dashboards that tell a story.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch2\u003eAbout this course\u003c\/h2\u003eDo you need to know what charts are available in Excel and when to use them to get your message across? Are you able to modify chart elements so that your dashboards are easy to understand immediately? We explain how to create each type of standard chart, from column charts to waterfall charts, and show you how to create complex bespoke charts. We demonstrate how to make charts dynamic and create an effective dashboard design, including some tips on how to use VBA to enhance the user experience. If you want to make your Excel dashboards more exciting with eye-catching visuals, this is the course for you.\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_469829.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning-china","offers":[{"title":"Standard price \/ 0","offer_id":44803493134587,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":44803493232891,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":44803493200123,"sku":"100184","price":200.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":44803493167355,"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_7305ceb9-7f23-42df-ab68-a4fe49eb0525.jpg?v=1779883718","url":"https:\/\/acca-learning.myshopify.com\/products\/213347_acca-learning-china","provider":"acca-learning","version":"1.0","type":"link"}