Excel VBA (Macro)

Intellisoft Training Pte. Ltd. was setup by industry leading experts from the Education industry for the sole purpose of providing quality training to companies and individuals, which lead to Best-in-Class Industry Certifications.These short training courses help companies to improve their productivity, efficiency and save time.Intellisoft Training Pte. Ltd. has partnered with ICDL Asia to highest rated International Computer Driving Test Accreditation to Singapore. We are an Approved ICDL Test Center to conduct all ICDL Core and ICDL Advanced Courses in Singapore.

Intellisoft Training

Module 1: Realizing the potential of Excel using VBA

<ul><li>Recognizing the Power of Excel
</li><li>Identifying workbooks that support macros
</li><li>Showing the Developer Tab
</li><li>Understanding Macro Security
</li><li>Recording and Running a Macro
</li></ul>Module 2: Understanding the Basics

<ul><li>Exploring the VB Editor
</li><li>Examining Recorded Macro Code
</li><li>Introducing the Selection Object
</li><li>Understanding Properties, Methods and Parameters
</li><li>Using the Line Continuation Character
</li><li>Using the With… End With statement
</li><li>Writing Comments
</li></ul>Module 3: Working with Variables and Constants

<ul><li>Understanding the Scope of Variables
</li><li>Identifying the different Data Types
</li><li>Working with Variables
</li><li>Exploring Object Variables
</li><li>Declaring and using Constants
</li></ul>Module 4: User Interaction Techniques: Part 1

<ul><li>Using the InputBox
</li><li>Using the Msgbox
</li></ul>Module 5: Overview of Objects

<ul><li>Introducing the Application Object
</li><li>Exploring Workbooks and Workbook Object
</li><li>Exploring Worksheets and Worksheets Object
</li></ul>Module 6: Referring to Ranges

<ul><li>Introducing the Range Object
</li><li>Referencing a range using the CurrentRegion Property
</li><li>Accessing a range using the UsedRange Property
</li><li>Finding the First Cell with data
</li><li>Referencing the Last Row and Column in the data range
</li><li>Using the Cells Property
</li><li>Utilizing the Offset Property while working with Range
</li><li>Employing the Resize Property to Change the Size of a Range
</li></ul>Module 7: Control Structures

<ul><li>Using Loop Constructs: For Loop Statement
</li><li>Using Loop Constructs: For…Next Loop
</li><li>Using Loop Constructs: Do While…Loop
</li><li>Using Loop Constructs: Do Until…Loop
</li><li>Exiting a Loop Early
</li><li>Nesting Loops
</li><li>Working with Conditional Constructs: If…Then…Else
</li><li>Working with Conditional Constructs: Select Case
</li></ul>Module 8: User-Defined Functions

<ul><li>Exploring Commonly Used VBA Functions
</li><li>Creating User-Defined Functions
</li><li>Executing User-Defined Functions
</li><li>Sharing User-Defined Functions
</li></ul>Module 9: Event Programming

<ul><li>Creating a Custom Button to execute code
</li><li>Understanding Event Parameters
</li><li>Working with Worksheet Events
</li><li>Working with Workbook Events
</li></ul>Module 10: Using VBA to Create Pivot Tables

<ul><li>Introducing Pivot Tables
</li><li>Building and Editing Pivot Tables using VBA
</li><li>Auto Refreshing Pivot Tables using VBA
</li></ul>Module 11: User Interaction Techniques: Part 2

<ul><li>Creating UserForms
</li><li>Understanding and Using ActiveX Controls
</li><li>Programming the ActiveX Controls
</li></ul>Module 12: Creating Charts

<ul><li>Charting in Excel
</li><li>Referencing Charts Objects using VBA
</li><li>Creating and Modifying the Chart
</li></ul>Module 13: Handling Errors

<ul><li>Identifying the Different Types of Errors
</li><li>Debugging Tools: Stepping through Code
</li><li>Debugging Tools: Breakpoint
</li><li>Debugging Tools: Immediate Window
</li><li>Debugging Tools: Watch Window
</li><li>Handling Errors by Choosing to Ignore Them
</li><li>Employing Basic Error Handling with the On Error GoTo Syntax
</li></ul>Module 14: Useful Macros

<ul><li>Selecting Special Cells
</li><li>Using Autofilter instead of Loops
</li><li>Combining Workbooks
</li><li>Separating data into different Worksheets</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel VBA (Macro)

More events from Intellisoft Training

Discover more events from Intellisoft Training, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in Singapore and filter by date, category, and more to find the perfect fit.

Excel VBA (Macro)

More events from Intellisoft Training

Discover more events from Intellisoft Training, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Singapore and filter by date, category, and more to find the perfect fit.