Buying for a team?Choose 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. Develop practical knowledge and confidence in Excel 2016 Macros and VBA. Excel 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. Why this course matters This 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. What you will gain Use the key features and workflows covered in Excel 2016 Macros and VBA with greater confidence. Apply the tools and techniques to practical business tasks. Recognise common mistakes and work more efficiently in day-to-day use. Who is this course for? This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools. Course at a glance Format: self-paced online learning. Professional development: CPD course. Excel 2016 Macros and VBAObjectives: 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. Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology. Unit Contents: 1. Getting StartedIn this topic you will cover a basic introduction to the course unit and its objectives. 2. Introduction & the Macro RecorderIn this topic you will cover: Introduction & the Macro Recorder IntroductionDemonstrationThe Excel Macro RecorderRelative and Absolute RecordingMacro StorageMacro Shortcut KeysDeleting MacrosExcel’s New File FormatSelf-test Quiz 3. Creating & Editing Macros With VBAIn this topic you will cover: Creating & Editing Macros With VBA Macro Storage ConceptsThe VB EditorWorking With ModulesEditing MacrosCopying MacrosLinking MacrosUser-Defined FunctionsGlobally Available User-Defined FunctionsAuto Executable MacrosSelf-test Quiz 4. Objects and Dialog BoxesIn this topic you will cover: Objects and Dialog Boxes ObjectsThe VBA Object BrowserBuilt-In Dialog BoxesCustom Dialog BoxesSelf-test Quiz 5. Introduction to ControlsIn this topic you will cover: Introduction to Controls Worksheet ControlsIntroduction to User FormsAccessing your Macros in ExcelSelf-test Quiz 6. Wrapping Up / Assessment ResultIn this topic you will cover: Course ConclusionWrapping upTest Results Summary Continue your learning Part of this learning pathway: Microsoft Office & Windows Learners also take: Excel 2016 Advanced | Excel 2016 Master Related training bundle: Excel 2016 Mastery Program Course pathway: eBSI SME Academy > Microsoft Office & Windows > Excel 2016 Macros and VBA Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.
