This course will help you to write macros in Excel to generate MIS reports.

Topics Covered

Introduction to Macros - How to create a macro? - How to set the security settings? - using the VBA editor - utilities for efficient running of macros VBA Syntax - Objects - Object Browsers - Boject Hierarchy Immediate Window - Formatting Cells - Variables & Constants - Object Variables - Getting data from users Control Statemnts - IF statment - CASE statement - FOR..NEXT loop - DO..WHILE loop - DO..UNTIL loop Functions - Built-in functions - User defined functions - Pass by value - Pass by reference

Who should attend

This training workshop would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.

Pre-requisites

Good knowledge of Fundamental and advanced formulae and functions in Excel. Knowledge of any structured programming language is a plus but is not necessary. Good Numerical ability and aptitude skills is an advantage.

What you need to bring

You need not bring anything. We will provide you all the required items.

Key Takeaways

Lab code for programming examples and exercises. The entire course content printed out (organized in a ring binder). Facilitator-led classroom sessions for two days with intense interaction and experience sharing. Question-answer sessions for each of the topic and quizzes after covering each of the topic. Excellent food, Tea/Coffee & Biscuits. Course Certificate from WAY TO IT.