Advanced EXCEL MACRO'S 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
Advance-EXCEL-MACRO'S

Other Courses

A good course for Beginners and students from any background. Teaches you Tally operations & Champ.
The most in demand and popular Tally course for all students and professionals, All the Tally operations & Advance Tally techniques.
Tally Xpert Course – Includes 6 Volumes of Books, 6 online exams, a very advance course for Professionals in Accounting
A fantastic combination of Tally Operations, Advance Excel. A GREAT CAREER BOOST & JOB ORIENTED
Finanacial Functions, Pivot Tables, HLOOKUP, VLOOKUP, Goal Seek, Charts Graphs, Character Funtions..etc.
Features of the database in an office environment with maximum efficiency.
Learn how to use Ms-Office: Ms-Word, Ms-Excel, Ms-Powerpoint for Office Automation with LIVE PROJETS. This Course is a must for ALL !

Join Tally Courses (25 + Live Projects) Tally 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