Excel Macro Online for Novice by Upskill Technologies

We are giving training on Excel Macros.

Macros
Introduction to Programming.
Using macro recorder.
Getting Familiar with VBA Editor.
Creating modules.
Generating code from macro recorder.
Understanding the code.
Writing basic code.
Reference types in recording code.
Object Hierarchy
VBA syntax to refer an object.
Object Properties & Methods.
Collections Analogy
Working with cell/range object
Working with cells, sheets and workbooks
VBA code to copy paste.
Objects and Collections
Conditions and Loops
Using IF condition in VBA.
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
Creating formulas with VBA.
Calling functions and procedures.
Using XL Formulas in VBA code.
Passing arguments to functions.
Workbook events.
Sheet Events
Cell Change Events
Charts, Pivots and Userforms
Creating dynamic charts with Excel.
Code to create and update Charts.
Creating Pivots with VBA.
Creating Userform to gather information.
Design Userform.
Working with Userform controls.
Creating a responsive Userform.
Error Handling Techniques
Code to consolidate all xl files in folder and sub folder.
Code to create dashboard using pivots and dynamic charts.
Code to create invoices from a single source of data.
Code to lookup data in various files and create a dashboard.
Real Time Projects