Further Details
What do I get out of it? By the end of this course you will be able to: Maximise existing Excel functionality by learning how to write programmesAutomate repetitive, tedious and complex tasks by using advanced If statements and macrosUpdate VBA programmes by learning how to edit and amend themCourse Overview:Macros: Writing; EditingAssigning Macros to a button in the toolbarUnderstanding The Visual Basic Integrated Development Environment; Its Components: Properties Window, Project Explorer and Code WindowCreating and Editing Modules, Objects and ProceduresAdding Input and Output Message boxes; Procedures and Conditions; Writing Private and Public and Sub-routines; Creating New Functions for use in ExcelDeclaring Constants And VariablesVariable Types: Dim, Static and ConstWriting and Understanding Loops & Arrays; Do while and Do Until loops; Arrays: Static and DynamicUsing Advanced “If”, “Elseif” and the “Case Selection” alternative
Guide price
£495 + VAT |
