Microsoft Excel Macro VBA Training

This course is intended for current Microsoft Excel users who wish to automate their regular task with the help of macros.

This course covers how to create macros, create button & coding to automate regular tasks.

img
Details for This Course
Date Duration Location Price Booking Enquiry
Jan 13 - Jan 14 2 days Dubai 2100.00 AED Book Now Enquiry
Feb 03 - Feb 04 2 days Dubai 2100.00 AED Book Now Enquiry
  • Overview
  • Course Objectives
  • Course Exam(s)
  • Who Should Attend
  • Course topics

Microsoft Excel Macro VBA Training

Macros VBA Training

Microsoft Excel Macros VBA for report automation

This 2 day course is intended for current Microsoft Excel users who wish to automate their regular task with the help of macros. This course covers how to create macros, create button & coding to automate regular tasks.

Upon successful completion of this course, students will be able to:

  • Record the macros
  • Can create buttons & QAT to run the macro
  • Delete & change the shortcut of the macro
  • Write his own code to automate the regular task
  • Will be able to write the code for consolidating multiple sheets or files.
  • Softcopy of training manual, shortcut keys and formulas
  • 3 Months FREE email support for queries

This course will significantly  benefit

This course covers how to create macros, create button & coding to automate regular tasks.

Unit 1

  • Recording & Running Macros
  • Creating Button to run the macros
  • Correct methods of recording macros

Unit 2

  • Overview of Excel VBA Editor
  • Adding & Deleting Modules
  • Sub & End Sub

Unit 3

  • Protecting your Macro Codes)
  • Working with Workbooks & Worksheets
  • Understanding Ranges coding
  • Declaring Variables

 Unit 4

  • Using IF & Multiple IF in macro

Unit 5

  • Understanding Looping
  • Practically using looping in macro

Unit 6

  • Taking Backup of Modules
  • Debugging Code & Break Points
  • Commenting Codes

 Unit 7

  • Creating Message Box for interaction
  • Using different types of Message boxes
  • Using IF Condition in Message Box

 Unit 8 (Practical Projects)

  1. Formatting regular reports
  2. Auto Filtering & Separating Data
  3. Consolidating Multiple Sheet into one
  4. Consolidating Multiple files into one