Two Days Workshop On Microsoft Excel Macros  @ Chennai

Two Days Workshop On Microsoft Excel Macros @ Chennai

 

  • Registration

    includes refreshments,Lunch, reference material.

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 317

About The Event

Introduction :

A survey says more than 90% of companies use Microsoft Office Suite. It has been estimated that although Microsoft Office contains more than 10,000 features, the average user is familiar with only about 150 of them.

 
That means that most people have left a whopping 98.5 percent of Office territory unexplored. In practical terms, it also means that most people aren’t taking advantage of the power of the Office suite. It means that most people work inefficiently by trying to make the techniques they know serve a wide range of situations, and it means that most people work ineffectively because they aren’t aware of techniques that could solve their problems. This workshop is designed to learn the some of these features.

 

Objective:

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.

 

Course Contents: 

Above Content may vary depends on participants level, need and expectations

 

Facilitators Profile: Mr. Sathish Kumar. S

 

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 12 year of Corporate Training experience, conducted more than 30 public programme and 400 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.

 

Key Takeaway:

After this workshop the participants are able

  • To work on excel very effectively
  • To make interpretation faster
  • To create Report and Chart and print very quickly
  • 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
  • Validate User interface/forms
  • Work Extensively with Objects
  • Customize VBA Methods
  • Associate Events according to effective execution of every method
  • Apply various design-time and run-time properties for objects

 

METHODOLOGY:

  • LCD presentation of the concepts with examples and lecture
  • Hands on experiences (immediate practice of the exercise & examples)
  • Exercise based notes will be provided.
  • Interaction with some live examples
  • Each participants with the individual computer (with latest configuration and pre-loaded with MS Excel)
  • Immediate practice of MS Excel
  • Live assignment of MS Excel
  • Doubts and queries cleared immediately

 

Participants Level:


All the levels of people who already knows the advanced features in Excel like Logical Function (if, And, Or), Nested Function, Array Function, Lookup and Reference Function and Error Handling are Eligible to attend.

Venue Map