VB Excel

Training Provided by Mullan Training This 2 day course is suitable for Advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data. PREREQUISITES A high proficiency of Microsoft Excel is essential, or completion of our 2 day Adavnced MS Excel course. BENEFITS At the end of the course the delegate will have covered the fundamentals of VBA, including: working with procedures and functions understanding objects using expressions, variables and intrinsic functions. mastering how to control program execution working with forms and controls working with the PivotTable object. debugging code & handling errors to ensure minimal downtime while building and effecting the program. COURSE CONTENT Introduction What is a Macro Recording a Macro Running a Macro Relative References Assigning Macros to Buttons and Objects Assigning a Macro to a Button on a Sheet Assigning a Macro to a Drawn Object on a Sheet Assigning a Macro to a Button on a Toolbar Editing Macros The Visual Basic Editor The Project Explorer The Code Window Procedures Inserting Comments Printing a Visual Basic Module The Range Object The Cells Property The Range Property Flexible Ranges Range Contents Workbooks and Sheets Activating a Workbook Activating a Worksheet ThisWorkBook Objects, Properties and Methods Controlling Objects with their Properties Performing Actions with Methods Performing Multiple Actions on an Object Variables and Constants Variables Data Types Constants Control Structures Conditional Control Structures Looping Control Structures Non-Structured Statements Subprocedures Controls, Dialogue Boxes and Forms Built-In Dialogue Boxes Predefined Dialogue Boxes Custom Forms Worksheet Forms User-Defined Forms Adding Form Controls Form Control Properties Control and Dialogue Box Events Displaying and Dismissing a User Form Handling Form Controls Storing Information The Windows Registry Settings Files WritePrivateProfileString Toolbars and Display About Toolbars and Menus Customised Toolbars Display Debugging and Error Trapping Break Mode Instant Watch Stepping Error Handling Error Handling Example Worksheet and Workbook Events Worksheet Object Events Function Procedures User-Defined Functions LOCATIONS Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts). ADDITIONAL INFORMATION If you would like more information please do not hesitate to contact us. For a course outline visit our website www.mullantraining.com or email us at info@mullantraining.com or telephone 0289032 2228

VB Excel --

About The Training Provider: Mullan Training

More Training from Mullan Training

• Advanced Crystal Reports
• Advanced Macromedia Dreamweaver
• Advanced MS Project
• Advanced MS Viso
• Business Objects Universe Designer
• Internet Techniques
• Introduction To Business Objects
• Introduction To Crystal Reports
• Introduction to Macromedia Dreamweaver
• Introduction To Macromedia Fireworks
• Introduction To Macromedia Flash
• Introduction to Microsoft Word
• Introduction To MS Frontpage
• Introduction To MS Viso
• Introduction To Sage Line 50
• Macromedia Dreamweaver - Building Dynamic Sites with SQL
• Sage Instant/ Sage Job Costing
• Sage Payroll
• VB Access