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
3 Students
10 Lessons
Beginner

What Will You Learn?

  • You will understand the meaning of Excel VBA to do the full automation in Excel tasks
  • You will get to know VBA automation scope and advantage of learning it
  • You'll learn basic syntaxes plus recording of macros
  • You'll work a lot on the use of Variables and their data types
  • We'll cover the questions you may expect in your job interview

Curriculum

6h 3m
Section 1: Macro Editors recording and basic VBA Commands
6:03:50
Basics - Macro Editor and Range Commands
1:11:52
Assignments - Understand VBA - How it works
46:45
How to Compile Data - Project
47:52
What is a Personal Macroworkbook
17:17
Introduction to Variables Data Types
56:10
Option Explicit & Variant DataType
35:47
Scope of a Variable & Call keyword
30:31

Description

Requirements

  • You should be well versed with Excel Front end
  • MS Excel installed on your machine (2007 or later)

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