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 data analysts, finance, accounting, and advanced Excel users.
Prerequisites
Before attending this course, students should have experience:
- A average Macro programming knowledge
Module 1: Getting Started
- Introducing Visual Basic for Applications
- Displaying the Developer Tab in the Ribbon
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Editing a Macro in the Visual Basic Editor
Module 2: Make a Macro Do Complex Tasks
- Task One: Opening the Report File
- Open a Text File
- Watch a Macro Run by Stepping Through It
- Select a File While Running a Macro
- Task Two: Filling In Missing Labels
- Select Only the Blank Cells
- Fill the Selection with Values
- Record Filling In the Missing Values
- Watch the FillLabels Macro Run
- Task Three: Adding a Column of Dates
- Add a Constant Date
- Step Through the Macro
- Prompt for the Date
- Task Four: Appending to the Database
- Append Data to a Master List
- Step Through the AppendData Macro
- Record a Relative Movement
- Choose Whether to Save Changes While Closing a File
- Task Five: Deleting the Worksheet
- Create a Macro to Delete the Active Worksheet
- Make the Macro Operate Quietly
- Assembling the Pieces
- Record a Macro That Runs Other Macros
- Simplify the Subroutine Statements
Module 3: What Is an Object?
- Objects Come in Collections
- Objects Have Properties
- Objects Have Methods
- Methods Can Change Properties
- Properties Can Involve Actions
Module 4: Understanding Workbooks
- Add a New Workbook
- Count the Workbooks
- Close the Workbooks
- Refer to a Single Workbook
- Refer to a Workbook by Name
- Refer to a Workbook by Pointing
- Change a Workbook Property Value
Module 5: Understanding Worksheets
- Add a New Worksheet
- Rename and Delete a Worksheet
- Look at the Return Value of the Delete Method
- Look at the Result of the Add Method
- Copy a Worksheet
- Manipulate Multiple Worksheets
- Declare Variables to Enable Auto Lists
Module 6: 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
Module 7: Form Controls
- What is a Form Control?
- Adding a Control to a Worksheet
- Assigning a Macro to a Control
- Using Form Controls
Programme scope, delivery arrangements and suitability are confirmed during enquiry.