eBSI Export Academy - Corona Virus - COVID-19 Response - Info Resources and 50-80% off Courses. Click to learn more...

Excel 2016 Macros and VBA - eBSI Export Academy
Excel 2016 Macros and VBA - eBSI Export Academy
Excel 2016 Macros and VBA - eBSI Export Academy

Excel 2016 Macros and VBA

Write a review
| Ask a question
Vendor
eBSI Export Academy
Regular price
€40.00
Sale price
€10.00
Tax included. Shipping calculated at checkout.

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.

 

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