VBA for Excel Macros
Sale Date Ended
This course is for you if you spend a lot of time on excel or if you are interested to move to a MIS position. The course will teach you the basics of programming and you will learn how to automate daily tasks in excel. No programming knowledge required but you should be good with excel.
Packed with practical examples and real time projects you will gain the confidence to write your own code to automate any excel activity. Please visit www.upskilltechnologies.com for more details or give us a call at 9985130004.
Using macro recorder.
Getting Familiar with VBA Editor.
Generating code from macro recorder.
Understanding the code.
Writing basic code.
Reference types in recording code.
Objects and Collections:
VBA syntax to refer an object.
Object Properties & Methods.
Working with cell/range object
Working with cells, sheets and workbooks
VBA code to copy paste
Conditions and Loops
IF-Else and IIF conditions.
Multiple IF vs Select Case
Do While Loop
For-Each & For-Next
Using For Loop with conditions
Using With-End Construct.
Loop between sheets and workbooks.
Functions and Events
Calling functions and procedures.
Using XL Formulas in VBA code.
Passing arguments to functions.
Charts, Pivots and Userforms
Code to create and update Charts.
Creating Pivots with VBA.
Creating Userform to gather information.
Working with Userform controls.
Creating a responsive Userform.