Excel VBA Programming Online
Learn all features of VBA Programming in our exclusive 40 hour live webinar online.
Requirements:
- A computer with Excel.
- A second screen or tablet to watch the instructors screen.
- A high speed internet connection.
Schedule:
January 6th, 7th, 8th, 13th, 14th, 15th, 20th, 21st, 22nd, 27th, 28th, 29th, February 3rd, 4th, 5th, 10th 4pm EST
January 6th, 7th, 8th, 13th, 14th, 15th, 20th, 21st, 22nd, 27th, 28th, 29th, February 3rd, 4th, 5th, 10th 10pm EST
Price: $379
Topics |
||
| Record Macros | Find Key Columns | Pass Local Variables |
| Visual Basic Editor | Read and Write to Cells | Call Subroutines |
| Debugging | Use Named Ranges | Array Variables |
| Writing Pseudocode | Use For / Next Loops | Object Variables |
| Declaring Variables | Make Decisions: If / Then / Else | For Each Loops |
| Variable Data Types | Make Code Run Faster | Do While and Do Until Loops |
| Variable Concatenation | Handle Run-Time Errors Level I | While / Wend Loops |
| Navigating Cells and Ranges | Message Box, InputBox, Dialogs | User Forms |
| Navigating Worksheets | Use Excel’s Functions | Charts |
| Add Sheets | Write Your Own Functions | Pivot Tables |
| Name Sheets | Workbook Events | Communicate With Other Programs |
| Count Sheets | Scheudle Program Run Times | Run-Time Errors Level II |
| Hidden Sheets | Select Case | Class Modules |
Contact Us:
Phone: 212-729-7216
Email: