MS Excel Level 4 - Enhance your efficiency with Excel Macro
Participants will have a brief idea in the following topics Automate Routine Process with Excel Macro Recorder. Concept of VBA and OOP Excel Collections Objects and it's Hierarchy Application Workbooks Workbook Sheets Worksheet Range Cells Excel VBA Programming Struture Data Type Integer Single and Double String If .... Than ... Else ... statement For Loop VBA Programming Application Searching and Matching Records on a Spreadsheet Simplify Complicated Calculation
Participants will have a brief idea in the following topics Automate Routine Process with Excel Macro Recorder. Concept of VBA and OOP Excel Collections Objects and it's Hierarchy Application Workbooks Workbook Sheets Worksheet Range Cells Excel VBA Programming Struture Data Type Integer Single and Double String If .... Than ... Else ... statement For Loop VBA Programming Application Searching and Matching Records on a Spreadsheet Simplify Complicated Calculation