Duration
2 days
Introduction
Be a Microsoft Excel Macro Expert in Just 2 days. Excel VBA Macro course concentrates on programming aspects of Excel Including Recorded Macros, Editor, Variables, Custom Forms, Excel Objects and more to make you Automate your daily tasks in Excel by yourself. This training courses will arm you with the knowledge of how to use Excel more effectively and efficiently and ultimately help you make smarter decisions. Boosts your productivity, simplify data management and streamline everyday tasks using the latest version of this powerful software.
Audience
This course is intended for those who have been using Excel and are looking to get into Macros, or those that are planning to take up courses in VBA, this course will provide a good foundation to build upon.
Prerequisites
Before attending this course, students should have experience:
- A basic Macro programming knowledge
Course Outlines
Form Controls
- What is a Form Control?
- Adding a Control to a Worksheet
- Assigning a Macro to a Control
- Using Form Controls
- Step-By-Step
User Forms and ActiveX Controls
- Creating a Blank User Form
- Adding Controls to the Form
- Adding Buttons and VBA Code
- Starting the User Form with a Macro
- Step-By-Step
Referring to a Range
- Refer to a Range by Using an Address
- Refer to a Range as a Collection of Cells
- Refer to a Range as a Collection of Rows or Columns
- Refer to a Range Based on the Active Cell
- Refer to Subsets of a Range
- Refer to a Relative Range
Working with PivotTable Reports
- Create a PivotTable Report from an Internal Source
- Create a PivotTable Report from an External Source
- Record a Macro to Set the PivotTable Structure
- Set the PivotTable Structure
- Record a Macro to Customize a PivotTable Layout
- Customize a PivotTable Layout
- Record a Macro to Customize a PivotTable Style
- Customize a PivotTable Style
- Key Points
Exploring Chart Objects
- Create a Chart
- Synchronize Two Charts
- Format the Plot Area of a Chart
Creating User-Defined Function
- Understand Function Syntax
- Create a User-Defined Function
- Using User-Defined Function
- Handling Errors
Creating a Form’s User Interface
- Create the Form
- Add Option Buttons
- Add a Check Box with a Related Text Box
- Initialize the Text Box
- Add Command Buttons
- Set the Tab Order for Controls
VBA Programming Techniques
- Using Conditional Statement
- Creating Loops Using Different Structure
Programme scope, delivery arrangements and suitability are confirmed during enquiry.