watching now
1 Students
9 Lessons

What Will You Learn?

  • How to create your own VBA function
  • How to use VBA functions in Excel
  • How to call VBA Excel functions from an Excel sheet
  • How to use Excel VBA function libraries for automation


6h 4m
Section 1: Complete Tutorial - Inbuilt and User Defined (UDF)
Chapter1 - Let us Begin - Inbuilt and UDFs
Chapter 2 - Example 1 on Functions (Arrays Used)
Chapter 3 - Example 2 Functions (Arrays used again)
Chapter 6 - Advance Project Vlookup
Chapter 7 - UDF with Arrays - Very Powerful
Chapter 8 - How to Call Function from Sub-Routine



  • Knowledge on variables
  • Knowledge on loops
  • Knowledge on arrays
  • MS Excel installed

About the Instructor

Reviews 0
Students 3
Courses 8

There are not too many people on this planet that much driven by Excel as Ajay Parmar is! He’s been teaching all-things Excel from the most basic to most advanced level for more than 8 years now. And he still refers to it as his hobby and passion. Ajay appreciates the opportunity he’s created for himself to assist thousands of students in shaping their careers. He’s happy to share his knowledge locally in India and globally, using the BitDegree platform as one of the channels to reach out to an unlimited number of students.

Ajay Parmar holds a Bachelor’s degree in Maths from Punjab University. He’s created tens of different online courses where he reveals the endless possibilities of Excel – the software he’s got excellent skills in. He makes learning advanced VBScript, MS Access, and any topics related to Excel like a breeze.

On BitDegree, you can find a rich collection of Ajay Parmar’s courses where you can master visual basics for applications (VBA). Most of Ajay’s courses are beginner-friendly, so you can basically start from scratch being guided by an experienced tutor.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo