Macros with Microsoft Excel

Course Objectives
The objective of this programme will enable participants to record their first macro and create dynamic Excel macros that adjust to their data. Using Excel to create powerful user interfaces. Editing their Excel macro code and introducing looping and logic into their VBA code.
Course Duration
2 Days
Who should attend
For everyone wanting to know how to use a combination of Microsoft Excel and VBA to improve his/her productivity, adding power and flexibility to spreadsheets by creating user-defined functions.
Prerequisites
Participants should be fully conversant with Excel and other windows applications but need not have learnt any programming before, although obviously the course is also useful for programmers in other programming languages who wish to learn VBA.
Course Modules
Module 1: Developing Macros
  • Create a Macro with the Macro Recorder
  • Visual Basic for Applications (VBA)
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbook
  • Edit a Macro
  • Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • Debug a Macro
  • The Debugging Process
  • Debugging Tools
  • Customize the Quick Access Toolbar and Hot-keys
  • Work with Macro Security
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
Module 2: Formatting Worksheets Using Macros
  • Insert Text
  • The Selection Object
  • The Active Sheet Object
  • The Name Property
  • The Value Property
  • Concatenation
  • Format Text
  • Sort Data
  • The Range Object
  • The Select Method
  • The Current Region Property
  • Duplicate Data
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • The Do Loop
  • The Worksheets Collection Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • Generate a Report
  • The Columns Object
  • The AutoFit Method
  • The Address Property
  • The Call Command
  • The Font Property
  • The End Property
Module 3: Creating an Interactive Worksheet
  • Determine the Dialog Box Type
  • Message Boxes
  • Input Boxes
  • Capture User Input
  • The Input Box Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Character
  • Decision Structures
  • The Select Case Structure
  • The If Then Structure
Module 4: Working with Multiple Worksheets
  • Insert,Copy, and Delete Worksheets
  • The Add Method
  • The Copy Method
  • The Delete Method
  • Rename Worksheets
  • Expressions
  • The Date Serial Function
  • The Format Function
  • Modify the Order of Worksheets
  • The Move Method
  • Print Worksheets
  • The Print Preview Method
  • The Print Out Method
Module 5: Performing Calculations
  • Create User-Defined Functions
  • User-Defined Functions
  • Types of Functions
  • Arguments
  • The Else Clause
  • Automate SUM Functions
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings

For further enquiries, please call us at +6 (06) 8500888.

SIGN-UP EARLY TO AVOID DISAPPOINTMENT!
Register NOW!


Registration can be made by filling and submitting the online form below or email us at hello@lccm.asia

Payment shall be made payable to LOGICA CENTRE OF COMPUTER & MANAGEMENT SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration
IndividualCorporate

PART A: For ALL Types of Course Registration:

Your Choice of Program (required)

I / We would like to register for the above choice of program for:
Public CourseIn-house CourseOne-to-one Intensive Program

Your Name (required)

Your Company/Organization

Address

Tel. No. (required)

Email (required)

PART B: For Corporate Registration ONLY:
Please fill in Approving Manager details for attendee(s) below.

Authorised By

No. of Delegates you want to register?

*Note: Payment can be made before or on the commencement date.

Terms & Conditions

Registration & Fees Policy:
Registration is confirmed once registration form is received via online form/email/mail. Letter of Approval (For Corporate Registration ONLY) must be made available and presented prior to the course.

Cancellation Policy:
Any cancellation must be received in writing within 5 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.