EXCEL VBA TRAINING OUTLINE1. Recorded Macros· Understanding Excel Macros· Setting Macro Security· Saving a Document as Macro Enabled· Recording a Simple Macro· Running a Recorded Macro· Relative Cell References· Running Macro with Relative References· Viewing a Macro· Editing a Macro· Assigning a Macro to the controls· Running a Macro from the controls· Assigning a Keyboard Shortcut to a Macro· Deleting a Macro· Copying a Macro2. Recorder Workshop· Preparing Data for an Application· Recording a Summation Macro· Recording Consolidations· Recording Divisional Macros· Testing Macros· Creating Objects to Run Macros· Assigning a Macro to an Object3. Understanding VBA· Programming in Microsoft Excel· VBA Terminology· Understanding Objects· Viewing the Excel Object Model· Using the Immediate Window· Setting Property Values· Working with Worksheets· The Best VBA Help Available4. The VBA Editor· The VBA Editor Screen· Opening and Closing the Editor· Using the Project Explorer· Working with the Properties Window· Using the Work Area· Viewing Other Panes· Working with Toolbars· Working with a Code Module· Running code from the Editor· Setting Breakpoints in the Editor· Stepping Through Code5. Using Variables· Understanding Variables· Creating and Using Variables· Implicit and Explicit Declarations· The Scope of Variables· Module Level Scoping· Data Types· Declaring Data types6. Functions In VBA· Understanding Functions· Creating VBA Functions· Using a VBA Function in a Worksheet· Setting Function Data Types· Using Multiple Arguments· Modifying a VBA Function· Importing a VBA Module· Using a Function in VBA Code7. Using Excel Objects· The Application Object· The Workbook Objects· Program Testing with The Editor· Using Workbook Objects· The Worksheets Object· Using the Worksheets Object· The Range Object· Using Range Objects8. Programming Techniques· The MsgBox Function· Using MsgBox· InputBox Techniques· Using the InputBox Method· The IF Statement· Using IF for Single Conditions· Using IF for multiple Conditions· The Select Case Statement· Using The Select Case Statement· For Loops· Looping With specified Iterations· The Do...Loop Statement· Looping With Unknown Iterations9. Automatic Startup· Programming Automatic Procedures· Running Automatic Procedures· Automatically Starting a Workbook10. Error Handling· Error types· The On Error statement· Creating a Simple Error Handler· Using the Resume Statement· Using Decision Structures in Error Handlers· Using the Err object11. Get Data From Web· Introduction to HTML· Introduction to Power query get from web· Introduction to web reference library· VBA Get items by (tags, class, name, id)· Get data from souq as an example