Excel VBA
Excel
Training
Provided by Dunamis Training, LLC
Have you ever wanted to automate repetitive tasks in Excel? Create a user interface for inputs? Turn your spreadsheet into a powerful application? This course teaches Excel users how to do all these things and more Go to dunamistraining.com and click on the course offerings tab for more information
|
|
||||||||||||
Excel VBA
Excel VBA Course Outline
Intro to Macros
Topic A: Recording macros
Topic B: Editing macros
Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser
Programming basics
Topic A: Data
Topic B: Scope of variables
Topic C: Scope of procedures
Control structures
Topic A: Decision structures
Topic B: Loop structures
Custom dialog boxes
Topic A: User forms
Topic B: Events
Debugging and error-handling
Topic A: Errors
Topic B: Debugging
Topic C: Error-handling
Additional Topics (As time permits)
Moving around in Excel
Helpful properties
Helpful methods and functions
Managing files
Launching other applications
Helpful tasks
Intro to Macros
Topic A: Recording macros
Topic B: Editing macros
Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser
Programming basics
Topic A: Data
Topic B: Scope of variables
Topic C: Scope of procedures
Control structures
Topic A: Decision structures
Topic B: Loop structures
Custom dialog boxes
Topic A: User forms
Topic B: Events
Debugging and error-handling
Topic A: Errors
Topic B: Debugging
Topic C: Error-handling
Additional Topics (As time permits)
Moving around in Excel
Helpful properties
Helpful methods and functions
Managing files
Launching other applications
Helpful tasks
About The Training Provider: Dunamis Training, LLC
Dunamis Training, LLC - Dunamis Training, LLC, is a Pittsburgh-based training company, focused on empowering business professionals to become highly efficient and effective in this computer intensive age. Our premier courses are Excel and Access Visual Basic for Applications (VBA). We offer both on-site and off-site training.
Our instructors have decades of combined programming and business experience in...
