{"product_id":"1094457_acca-learning","title":"Excel tips and tricks","description":"\u003ch2\u003eWhat you will learn\u003c\/h2\u003e \u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003etime saving tips and tricks\u003c\/li\u003e\n\u003cli\u003ecritical keyboard shortcuts\u003c\/li\u003e\n\u003cli\u003ethe different types of tables available\u003c\/li\u003e\n\u003cli\u003ecustom number formatting\u003c\/li\u003e\n\u003cli\u003estyles vs. formats\u003c\/li\u003e\n\u003cli\u003edata validation\u003c\/li\u003e\n\u003cli\u003ekey functions, including why VLOOKUP is not as good as you think it is, and combinations you should master.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch2\u003eAbout this pack\u003c\/h2\u003eAre you using Excel as efficiently and effectively as you could be? Do you find yourself relying on just a handful of functions for all your modeling needs? Are you spending too much time on building calculations? Or have you heard about new features such as LET, LAMBDA and dynamic arrays, but don't understand what they are?\u003cbr\u003e\n\u003cbr\u003e\nIf you want to enhance your Excel capabilities, then this introduction to Excel is for you. Crafted by the SumProduct development team, this pack provides instructional videos and practical Excel files to guide you in the skills every finance professional should use on a day to day basis.\u003cp\u003e \u003c\/p\u003e\u003ch4\u003eKey information\u003c\/h4\u003e\u003cul\u003e\n\u003cli\u003eThis pack contains a collection of videos for you to follow, and exercises for you to complete within Excel.\u003c\/li\u003e\n\u003cli\u003eThis pack 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 pack requires you to have a basic understanding of Microsoft Excel.\u003c\/li\u003e\n\u003cli\u003eCPD certificate is available upon successful completion of the pack.\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003cimg alt=\"ACCA SumProduct joint logo\" src=\"${PICTURE_CONTEXT_PATH}ckeditor_uploads\/ACCA_SumProduct_sml_3168087.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning","offers":[{"title":"Standard price \/ 0","offer_id":44762753368315,"sku":"100184","price":400.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":44762753466619,"sku":"100184","price":400.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":44762753433851,"sku":"100184","price":400.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":44762753401083,"sku":"100184","price":400.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/Image___financial_modelling_1078647_61982f38-f995-4975-9b77-93b60de1c9e7.jpg?v=1780723037","url":"https:\/\/acca-learning.myshopify.com\/products\/1094457_acca-learning","provider":"acca-learning","version":"1.0","type":"link"}