Advance Excel - VBA Macro writing One day workshop on 25th December at Akurdi (Pune) Timing: 10:00 am to 4:00pm Venue: Will be informed after registration.

Topics Covered

VBA Macro Classes/Advance Excel Vlookup & Hlookup Pivot Introduction to Visual Basic Editor 2010 Understanding Excel Objects Workbook, Worksheet Variables, Variable declaration and data-types in VBA (any version). Properties Methods Events Range Object Range Object Properties Range Object Methods Using conditional statement [IF] to work on Range data Using loops to manipulate data in Range Working with Collections Advantages of using collections Scenarios: To understand the use of collections Sub versus Function Programming Formulas into Worksheet Cells Using Worksheet Functions Handling VBA Error / Debug VBA code

Who should attend

This is for people who works in Excel and want to learn advance excel.

Pre-requisites

Basic working knowledge of Excel is required.

What you need to bring

Fully Charged - Laptop

Key Takeaways

Advance Excel Basic programming Macro Writing