Posted on by

 

images

 

Microsoft Excel Advance with Macros

Most managers often use Excel more as a calculator than a computing aid.

This one day workshop seeks to improve the appreciation of various facilities & options available in Excel.

At the end of this workshop, the participants would definitely be able to use Excel better and improve their on the job efficiency.

The workshop will be conducted in an open interactive style covering the basics as well as advanced topics. Prior understanding of computing is not a pre-requiste.

The course coverage of the 1 day workshop is :

Introduction to Macros –

  • Recording Macros
  • Adding Macros To The Quick Access Toolbar
  • Editing A Macro
  • Start The VBA Editor
  • Macro Storage Locations
  1. Understanding Objects, Methods, Properties and Variables
  2. What is an Object?
  3. The Object Hierarchy
  4. Properties
  5. Methods / Events
  6. Interactivity
  7. Using Message Boxes
  8. Using Input Boxes
  9. Programming Constructs
  10. Decision Making – IF…Else…End if
  11. Looping Structures – For / Next
  12. Programming Concepts
  13. Variables And Data Types
  14. Variables And Scope
  15. Manipulating Data
  16. User Defined Procedures & Functions
  17. Creating a Procedure
  18. Creating A User Defined Function
  19. Calling One Procedure From Another
  20. Passing Multiple Arguments
  21. Error Handling
  22. On Error Statements
  23. Resume Statements
  24. User Forms
  25. Building Custom User Forms
  26. Using Text Boxes And Labels
  27. Using Command Buttons

Faculty : Ms. Urmi Patel

  1. Diploma In Electronics from SNDT University
  2. Post Graduate in Software Applications from NIIT
  3. Programming / Consulting Experience
  4. Worked as Head – IT applications for a Multinational wealth management company.
  5. She has worked as IT Professional, Designed, Developed and managed customized programs with Access, SQL and Oracle as Back end. Visual Basic has been the preferred Front end and Excel as the reporting destination using VBA.
  6. Over 15 years of IT experience
  7. Developed packages for Mutual Fund and Equity Market.
  8. Developed packages for Debt Market Segment
  9. Developed packages on CRM for Apparel Company
  10. Developed Order Management Program for Indenting Agents
  11. Developed Call Management Modules for Back office of TV Channel

Training Experience

  1. Some of the long term assignments with leading corporate include
Tata Infotech Ltd. Unix, C, Oracle 8.0, Visual Basic
Tata Electric Ltd Oracle 8.0 DBA
Finolex Industries Ltd Oracle 8i, Developer 2000
Tata Teleservices Ltd. MS-Access, MS-Excel
  1. + VE Commercial + Aricent Technologies + Heinz
  2. She has been regularly conducting training programs for various institutes and corporate since the beginning of her career.
  4. Timings: 9:30 am – 5:30 pm , Registration begins at 9:15 am

 

How to Register:

  1. Fees: Rs. 7,900/- +12.36 % service tax per person
  2. Please write to- register@princetonacademy.co.in / Call -022 66976892/ 66976874
  3. Mention the name of participant, company, contact details .
  4. Fees includes lunch, tea, course material etc.