{"product_id":"excel-2016-macros-and-vba","title":"Excel 2016 Macros and VBA","description":"\u003cdiv class=\"ebsi-team-licence-note\"\u003e\u003cp\u003e\u003cstrong\u003eBuying for a team?\u003c\/strong\u003e\u003cbr\u003eChoose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.\u003c\/p\u003e\u003c\/div\u003e\n\u003c!-- ebsi-sales-wrapper --\u003e\u003cdiv class=\"ebsi-sales-wrapper\"\u003e\n\u003cp\u003e\u003cstrong\u003eDevelop practical knowledge and confidence in Excel 2016 Macros and VBA.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eExcel 2016 Macros and VBA Objectives: This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). It will also teach learners how to write macros using VB code and assign macros to screen items.\u003c\/p\u003e\n\u003ch3\u003eWhy this course matters\u003c\/h3\u003e\n\u003cp\u003eThis course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.\u003c\/p\u003e\n\u003ch3\u003eWhat you will gain\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eUse the key features and workflows covered in Excel 2016 Macros and VBA with greater confidence.\u003c\/li\u003e\n\u003cli\u003eApply the tools and techniques to practical business tasks.\u003c\/li\u003e\n\u003cli\u003eRecognise common mistakes and work more efficiently in day-to-day use.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWho is this course for?\u003c\/h3\u003e\n\u003cp\u003eThis course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.\u003c\/p\u003e\n\u003ch3\u003eCourse at a glance\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFormat:\u003c\/strong\u003e self-paced online learning.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfessional development:\u003c\/strong\u003e CPD course.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cstrong\u003eExcel 2016 Macros and VBA\u003c\/strong\u003e\u003cbr\u003e\u003cbr\u003eObjectives: This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). It will also teach learners how to write macros using VB code and assign macros to screen items.\u003c\/p\u003e\n\u003cp\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003c\/span\u003e\u003cstrong\u003eContinuous Professional Development\u003c\/strong\u003e\u003cspan\u003e Requirements within organisations operating this kind of staff development methodology.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eUnit Contents:\u003c\/h5\u003e\n\u003cp\u003e\u003cbr\u003e \u003cstrong\u003e1. Getting Started\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover a basic introduction to the course unit and its objectives.\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e2. Introduction \u0026amp; the Macro Recorder\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eIntroduction \u0026amp; the Macro Recorder \u003cbr\u003eIntroduction\u003cbr\u003eDemonstration\u003cbr\u003eThe Excel Macro Recorder\u003cbr\u003eRelative and Absolute Recording\u003cbr\u003eMacro Storage\u003cbr\u003eMacro Shortcut Keys\u003cbr\u003eDeleting Macros\u003cbr\u003eExcel’s New File Format\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e3. Creating \u0026amp; Editing Macros With VBA\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCreating \u0026amp; Editing Macros With VBA \u003cbr\u003eMacro Storage Concepts\u003cbr\u003eThe VB Editor\u003cbr\u003eWorking With Modules\u003cbr\u003eEditing Macros\u003cbr\u003eCopying Macros\u003cbr\u003eLinking Macros\u003cbr\u003eUser-Defined Functions\u003cbr\u003eGlobally Available User-Defined Functions\u003cbr\u003eAuto Executable Macros\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e4. Objects and Dialog Boxes\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eObjects and Dialog Boxes \u003cbr\u003eObjects\u003cbr\u003eThe VBA Object Browser\u003cbr\u003eBuilt-In Dialog Boxes\u003cbr\u003eCustom Dialog Boxes\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e5. Introduction to Controls\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eIntroduction to Controls \u003cbr\u003eWorksheet Controls\u003cbr\u003eIntroduction to User Forms\u003cbr\u003eAccessing your Macros in Excel\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e6. Wrapping Up \/ Assessment Result\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003c!-- ebsi-cross-sell --\u003e\u003cdiv class=\"ebsi-cross-sell\"\u003e\n\u003ch3\u003eContinue your learning\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003ePart of this learning pathway:\u003c\/strong\u003e \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLearners also take:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-advanced\"\u003eExcel 2016 Advanced\u003c\/a\u003e  |  \u003ca href=\"\/products\/excel-2016-master\"\u003eExcel 2016 Master\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eRelated training bundle:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-mastery-program\"\u003eExcel 2016 Mastery Program\u003c\/a\u003e\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c!-- ebsi-academy-breadcrumb --\u003e\n\u003chr\u003e\u003cdiv class=\"ebsi-course-pathway\"\u003e\n\u003cp\u003e\u003cstrong\u003eCourse pathway:\u003c\/strong\u003e \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e \u0026gt; \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e \u0026gt; Excel 2016 Macros and VBA\u003c\/p\u003e\n\u003cp\u003eExplore more \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e training or return to the \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"eBSI Export Academy","offers":[{"title":"Individual Licence (EUR 40)","offer_id":35298296299680,"sku":"ITLU056","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260638789980,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260638822748,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU056Excel2016-MacrosandVBACover.png?v=1595685171","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-macros-and-vba","provider":"eBSI Export Academy","version":"1.0","type":"link"}