About the Course
Offering training on Excel VBA to automate any excel reporting. Teaching from the scratch of programming to advance techniques to master the concept.
Topics CoveredIntroducing VBA Editor
Code Window (Entering code manually vs Recording)
Options in VBA Environment
Relative or absolute reference recording.
Rewriting code using "With" .
Storing Macros (Same workbook vs personal.xls)
Objects and Collections
Referring an application, workbook, sheets and range.
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.
Example codes Macro to add numbers, find sum of first 100 numbers.....
Interacting with user for input.
Data Types in VBA.
Declaring range as an object.
Scoping a variable (public vs private)
If-else (Multiple If conditions)
Combining For and IF conditions
Who should attendFinancial Analysts, Reporting profiles, Managers...
Pre-requisitesKnowledge of Excel
What you need to bringYour personal laptop.
Key TakeawaysSkill to write excel macros.