Would you like to see more Microsoft Excel courses?

Further Details

Excel Object Model Workbook and worksheet object Workbooks and worksheets collections Range object's properties and methods Current Region object Chart object Statusbar Timer List object Events Events with application object Arrays Dynamic arrays Arrays optimization Multidimensional arrays Arrays and objects Object Oriented Programming (OOP) Classes and objects Set and Let statements Creating new objects Creating new classes Destroying objects Methods and properties Default property and method Classes and error handling Collection Creating and using collections Adding and remove elements Using index and key Typed collection* Procedures, parameters, variables Passing parameters by reference and by value (ByRef i byVal) Optional and default parameters Passing an array of arguments to a procedure Using enumerations User-defined Type Differences and use cases of Null, Nothing, empty string "", Empty, 0 Implicit and explicit conversions Dealing with files Reading text files Using CSV files Writing cross-application code Using Excel Object Model in other applications Add-ins Creating simple add-in Creating menu and toolbar in add-in Deployment and securing add-ins Using external libraries Using external data sources (Access, Oracle, etc.) Using ADO Data providers Configuring ODBC sources

Guide price

1200