fbpx

ENROLL IN THE FREE EXCEL VBA COURSE BY MVP SUMIT BANSAL OF TRUMPEXCEL

This Excel VBA course that covers all the concepts from scratch and then deep-dives into some advanced concepts. The lessons in this VBA course are short and full of practical examples that will help you apply these in your work from Day 1 itself. The course is packed with short videos (and some longer ones) that will take you from a beginner level and make you an advanced VBA user

36

Lessons

36

Videos

All

Skill Level

9:08h

Duration

English

Language

WHAT WILL I LEARN?

  • Introduction to VBA Language and the VB Editor
  • Recording/Decoding Macros in Excel
  • Running Macros in Excel
  • Writing Your First VBA Code
  • Understanding Errors in VBA
  • Working With Cells and Ranges Using VBA
  • Working With Worksheets/Workbooks Using VBA
  • Using Variables in VBA
  • Using Object Variables in VBA
  • Using Message Boxes in VBA
  • With Statement Loop
  • If-Then Else Loop
  • Select Case Loop
  • Do While/Until Loop
  • For Next Loop
  • For Each Loop
  • Creating Custom Functions in VBA
  • Error Error Everywhere - How To Handle It
  • Using Event Procedures to Run Macros
  • Userform - Basics + Deep Dive
  • Using Array in VBA
  • Working with Charts Using VBA
  • Show and Hide Elements Using VBA
  • Update Charts/ Dashboards with a Single Click
  • Creating Mouse Rollover Effect using VBA
  • Creating Add-ins usinG VBA
  • Creating Chart Animations using VBA
  • Creating an Application using VBA
  • Working with Files and Folders
  • Generating Word Reports using VBA
  • Generating PDF Reports using VBA

GET A PERSONALIZED CERTIFICATE OF COMPLETION FROM SUMIT BANSAL UPON COMPLETION OF THE COURSE