Book a Free Video Consultation!
If you have any questions or would like to speak to one of our team before enrolling feel free to book a free video call with us by clicking the button below, we will be delighted to meet you on Google Meet!
Excel 2016 Macros and VBA
Individual Licence (EUR 40)
€40.00
Skip to product information
Excel 2016 Macros and VBA
€40.00
Reliable shipping
Flexible returns
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 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.
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 Started
In this topic you will cover a basic introduction to the course unit and its objectives.
2. Introduction & the Macro Recorder
In this topic you will cover:
Introduction & the Macro Recorder
Introduction
Demonstration
The Excel Macro Recorder
Relative and Absolute Recording
Macro Storage
Macro Shortcut Keys
Deleting Macros
Excel’s New File Format
Self-test Quiz
3. Creating & Editing Macros With VBA
In this topic you will cover:
Creating & Editing Macros With VBA
Macro Storage Concepts
The VB Editor
Working With Modules
Editing Macros
Copying Macros
Linking Macros
User-Defined Functions
Globally Available User-Defined Functions
Auto Executable Macros
Self-test Quiz
4. Objects and Dialog Boxes
In this topic you will cover:
Objects and Dialog Boxes
Objects
The VBA Object Browser
Built-In Dialog Boxes
Custom Dialog Boxes
Self-test Quiz
5. Introduction to Controls
In this topic you will cover:
Introduction to Controls
Worksheet Controls
Introduction to User Forms
Accessing your Macros in Excel
Self-test Quiz
6. Wrapping Up / Assessment Result
In this topic you will cover:
Course Conclusion
Wrapping up
Test 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.