Seize the opportunity to gain new skills and reshape your career!

Choose a free learning path and get valuable insights from first-rate courses
watching now
5 Students
6 Lessons

What Will You Learn?

  • You'll no longer be frustrated with compiling data from hundreds of sheets and workbooks.
  • You'll be confident in doing just any kind of work on multiple sheets or workbooks.


4h 7m
Section 1: Workbook/Sheets handling & Collection Loops
Chapter 1
Chapter 2
Chapter 3
Chapter 5



  • Experience in using VBA Editor
  • Solid understanding of next loop and IF statements

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