To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.

Course Overview

This course will teach you how to automate repetitive tasks in Excel by recording macros. You will learn how to edit and string macros.

You will then learn how to write a code in the Visual Basic Editor. Controls worksheets, workbooks and create message boxes. You will also learn about creating User Forms, custom functions, conditional statements, events and looping over instructions.

VBA Course Topics

  1. Record A Simple Macro
  2. Record a Macro
  3. Run a Macro
  4. Understand the VB Editor
  5. Use the Menu Bar
  6. Use the Standard Toolbar
  7. Use the Project Explorer
  8. Use the Properties Window
  9. Understand the Code Window
  10. Understand Code Window Options
  11. Edit Code
  12. Get Help
  13. Use .CHM or .HLP Files
  14. Close the Visual Basic Editor
  15. Work with Objects
  16. Understand the Object Browser
  17. Understand Objects
  18. Understand the Objects Hierarchy
  19. Reference Objects
  20. Understand Collections
  21. Use the Editing Features
  22. Use the Immediate Window
  23. Use the Auto List
  24. Use Auto Quick Info
  25. Work with Variables
  26. Understand Variables
  27. Declare Variables
  28. Understand Data Types
  29. Store Values in Variables
  30. Store Objects in Variables
  31. Create Procedures and Functions
  32. Understand Procedures
  33. Use the Macro Recorder to Create Sub Procedures
  34. Call Procedures from Procedures
  35. Use Intrinsic Functions
  36. Use Message Boxes
  37. Use Input Boxes
  38. Create Functions
  39. Pass Arguments to a Function
  40. Work with Conditional Statements
  41. Understand Conditional Statements
  42. Work with Decision Structures
  43. Work with Loop Structures
  44. Work with Forms and Controls
  45. Understand Userform
  46. Use the Toolbox
  47. Work with Userform Properties
  48. Events and Methods
  49. Use the Properties Window
  50. Understand Controls
  51. Work with the Label Control
  52. Work with the Text Box Control
  53. Work with the Command Button Control
  54. Work with the Combo Box Control
  55. Work with the Frame Control
  56. Work with the Option Button Controls
  57. Add Functionality to Forms
  58. Work with Control Appearance
  59. Set the Tab Order
  60. Populate a Control
  61. Add Code to Controls
  62. Launch Forms from Procedures
  63. Use Pivot Tables
  64. Understand PivotTables
  65. Create PivotTables
  66. PivotTable Arguments
  67. Add Fields to PivotTables
  68. Control Forms
  69. Control Pivot Tables from a Form
  70. Control a Form from a Custom Toolbar
  71. Understand Debugging
  72. Understand Errors
  73. Debug Code
  74. Debug Tools
  75. Use the Locals Window
  76. Use the Watch Window
  77. Use Breakpoints
  78. Create Add-in
Share This Post
Have your say!
4 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.