VBA for Excel Macros

Offering training on Excel VBA to automate any excel reporting. Teaching from the scratch of programming to advance techniques to master the concept.

Topics Covered

Introducing VBA Editor Customizing Toolbars Adding/Removing Module Code Window (Entering code manually vs Recording) Properties Window Immediate Window Options in VBA Environment Macro Recorder Relative or absolute reference recording. Rewriting code using "With" . Storing Macros (Same workbook vs personal.xls) Objects and Collections Object Hierarchy Referring an application, workbook, sheets and range. Object properties Object Methods Collections Analogy exlained. Working with Range/Cell Object: code to select range, rows, columns, block of cells. copy and paste ranges to different sheets /workbooks Determining last cell from bottom/right. Offset Property Example codes Macro to add numbers, find sum of first 100 numbers..... Assignment Statements Interacting with user for input. Data Types in VBA. Declaring range as an object. Scoping a variable (public vs private) Understanding Arrays. With-End Constructs For-Each Constructs Conditional Statements If-Then If-else (Multiple If conditions) Select Case Do-while For-Each Combining For and IF conditions

Who should attend

Financial Analysts, Reporting profiles, Managers...

Pre-requisites

Knowledge of Excel

What you need to bring

Your personal laptop.

Key Takeaways

Skill to write excel macros.