Advanced EXCEL MACRO'S Course Rs. 5550/-

Duration : 1 Month Daily

In this course you will learn to write macros in Excel using programming languageVisual Basic Application (VBA).
Recorded macro can be edited to customize it & one can directly go for coding to accomplish the required tasks.

Module 1 : Functions & Procedures

  •  Create Functions & Procedures
  • Design & Create reports
  • Understanding Security Levels
  • Security Levels & Meaning

Module 2 : Functions

  •  What is Function and Subroutine
  • Writing Functions using VBA Editor
  • Calling function in other workbook
  • Relative & Absolute Macros

Module 3 : Recording Macros

  • Recording and running macro
  • Storing macro in different books
  • Creating buttons & assigning macros
  • Creating My Menu

Module 4 : The Visual Basic Editor [ VBE ]

  • Editing macros using VBA Editor
  • Understanding the project explorer
  • Exploring windows properties
  • Modifying code & Debugging code

Module 5 : Programming Fundamentals

  • Variables, Data types &Constants
  • Arrays ,Object Variables
  • Conditional structures (If Then,Select Case)
  • Logical Operators / Looping constructs
  • (For loops, Do loops, While)
  • Built-in functions, Creating Subroutines

Module 6 : User Forms

  • Creating forms, Form events
  • Creating custom menus & toolbars
  • Creating Add-ins

Join Advanced Excel Courses in Mumbai Advanced Excel Professional

INSTANT INQUIRY

captcha

Features & Facilities

Corporate Training Specialist

Trained Over 167+ Corporates

Classroom Training

Training on YOUR Premises and OUR Premises

Certified & Well Qualified Instructors

Certified Instructors with Considerable Industry Experience.

Experience in the Training Industry

Training Industry since over 24 years

Our Centres

At PRIME Locations DADAR – ANDHERI

Convenient Batch Timings

Weekend Workshops/ Batches on various advanced topics

BATCH Timings

Morning: 
7:30-9am, 9-10am,
10-11am, 11-12pm

Afternoon: 
12-1pm, 1:30-3pm,
3-4pm, 4-5pm

Evening: 
5-6pm, 6-7pm,
7-8pm, 8-9pm

Saturday : 11-1pm, 1.30-4pm, 4-6pm, 6-8pm
Sunday : 9-11am, 11-1pm, 1.30-4pm

Corporate Training in Bulk – minimum 15+ students per batch – Call 9619626991 for Corporate Discount