HALE HUMAN CAPITAL



Presents



Micro Soft Excel Macros (VBA)



Contact No: +91-96770-08266

Date & Time: Saturday,26th April, 2014 from 09.30 a.m. to 5.30 p.m.



Venue:

Hale Human Capital

No: 46/1, Rukmani Street 7th Avenue,

West Mambalam Chennai-600 033.

Mobile : 9677008266



Introduction:



Participants will be able to understand the power of an Excel and the features of Excel in customizing requirements from the clients or day-to-day work. This course is designed for such advanced users of Excel who wish to step ahead of enhancing the built-in features, functions and formulae.Objective:

To impart Awareness of some of the advanced concepts in Microsoft Excel



Course Content:

• Macros

• Recording the Macros, Edit/Modify & Execute Macros

• Macro Security

• Create Shortcuts and associate Macros with Events and Controls

• VBA (Writing your own macro)

• Introduction to VBA Code

• Variables and Data Types , VBA Operators and Operands

• Introduction to Procedures & Objects

• Using the objects in Excel

• Insert the form control (Command, Option, Check , Scroll bar & Etc)

• Linking the object to excel

• Accessing the function using the object

• Understanding the group

• Adding new objects

• Understanding the event based options

• Understand Programming

• Declarations and Definitions

• Assignment Statements

• Understand Conditional Statements

o IF

o Nested IF

• Understand Loops

o For Next

o For Each Next

• Assigning control to macros

• Customizing QAT by macro

• Creating our own TAB in Ribbon

• Creating a user defined functions

• Functions by single and multiple inputs

• Getting the outputs in Excel through UDF

• Accessing the Excel function in VBA

• Working with ADD-Ins (xla files)

• Creating The Add-In File

• Where To Install The Add-In

• Properties Of The Add-In

• Calling Add-In Functions In VBA



Key Takeaway



After this workshop the participants are able

• Work with Macros

• Create Multiple events in macros

• Generate Customized reports

• Work with data across sheets/workbooks

• Extract data and execute macros based on different criteria

• Handle VBA functions

• Customize VBA Methods

• Associate Events according to effective execution of every method

• Apply various design-time and run-time properties for objects



Facilitators Profile



Mr.S. Sathish Kumar, Microsoft Certified Microsoft Office Master. Free-lance Corporate trainer, Post-Graduation in Commerce, Higher Diploma in Software Engineering, Diploma in RDBMS, Diploma in Tally, Diploma in C,C++, Diploma in Hardware, Diploma in Web designing, and Diploma in MS Project (Project Management). Got Trained at Microsoft – New Delhi. Has over 15 year of Corporate Training experience, conducted more than 50 public programme and 600 In house training programme all over India in Companies like Allison Transmission, Amararaja Batteries, Amurtanjan, Anabond, Asian Paints, Asahi Glass, ATOS, Bank of America, Blue Star, Catterpillar, Cavinkare, CRI Pumps, CUMI, CVRD Defence, Cynosure, Daimler, Dalmia Cements, Datafield, DB Schenker India Pvt. Ltd, Delphi TVS, Dietech India, Doosan, EAPL, E I Dupont India PVT LTD , Elgi Equipments, Elsevier, Fenner India, Frost n Sullivan, Gamesa, GKN Driveline, Godrej Saralee, HALE, Han Yang Automotive Pvt Ltd, Hansen Drives, Harita Seating, HCL, Hyundai Glovis, JKM (Dynamatic Technologies), Komatsu India, Lucas TVS, Luk India, Mahindra Research Valley, Mando India, Mate Motherson, Mitsubha, Mitsubishi, Orbis India, Packaging India, Parryware Roca, Pure Chemicals, Pyung HWA India Pvt Ltd, Rane Institute for Employee Development, Rane Madras Limited, Rane TRW, Regen Power Tech, RRB Energy Limited Energy, Saipem Projects (I) Pvt Ltd, Sakthi Office, Same Duetz, Sanmina - SCI, SRF Limited, TAKE Solutions Global LLP, Techmat, Toshiba, TVS & Sons, TVS Sri Chakra, VA Wabag tech, Venus Home Appliances, Verizon, Volex Asia Interconnect, Winergy, Yalamanchili Products & Solutions Pvt Ltd.Also do the training for TechTraining, Future Tech, Aurotech, NIIT and Microsoft. Besides Guest Faculty in leading Institute like CST, SSi, CSC, ASL, Roof Read Educational Academy, Aptech, Insys Info School, eBits, SRM Technologies and etc. Software Consultant for many companies.



TRAINING METHODOLGY



• LCD presentation of the concepts with live exercise and examples

• Hands on experiences (immediate practice of the exercise & examples)

• Doubts and queries cleared immediately

Please bring your laptop for the workshop (mandatory).

Participants Level:

All the persons who knows the advanced features like Logical function (If, And, Nested Ifs, Nested Function & Array Functions), Dynamic List or Table, Usage controls like Combo, List, Option button & etc. and who are all interested in writing coding & automation of excel sheets.

Investment: Rs 4,000/- plus service tax @ 12.36% per participant, which includes refreshments,Lunch, reference material. Cheque should be drawn in favour of “ Hale Human Capital”.



* Avail Early Bird Discount of Rs.500/-per participant along with participation fee for Registration on or before 19th April 2014. .



Group Discount: One complimentary registration is extended for a group of four nomination from the same organization.

Kindly Send nominations along with the cheque and name/contact numbers/ email ids of the participants at



Aparna P

Hale Human Capital

No: 46/1, Rukmani Street

7th Avenue, West Mambalam

Chennai-600 033.

www.halehumancapital.com

Email: aparna@hale-India.com

Contact No: +91-96770-08266