Top Institute for IT Training Courses

Excel VBA 365 Video Course

Administrator Expert

Home
Excel VBA 365 Video Course

About Course

🎯 Course Overview

An Excel VBA 365 video course aims to teach you how to automate Excel tasks and extend spreadsheet capabilities by programming with Visual Basic for Applications (VBA) — the scripting language built into Microsoft Excel.

📚 Course Content / Modules

Advanced Excel
VBA Macro Automation

⏱ Video Format & Delivery

Pre-recorded video lessons ranging from (10–30 min)
You’ll often get practice files to follow along and apply what you learn.

Course Content

CLASS-1-WHY EXCEL CAREER ROADMAP

WHY EXCEL CAREER ROADMAP

00:00

CLASS-2 EXCEL BASICS & PASTE SPECIAL

CLASS-3 FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATING

CLASS-5-LOGICAL FUNCTION

CLASS-6 LOGICAL FUNCTION

CLASS-7 MATH FUNCTION

CLASS-8 TEXT FUNCTION 1

CLASS-9 TEXT FUNCTION 2

CLASS-10 DATE FUNCTION

CLASS-11 STATISTICAL FUNCTION 1

CLASS-12-STATISTICAL FUNCTION PART 2

CLASS-13 DATABASE & INFORMATION FUNCTION

CLASS-14 GOTO SPECIAL

CLASS-15 SORTING

CLASS-16 FILTER & ADVANCED FILTER

CLASS-17 TEXT TO COLUMN

CLASS 18 DATA VALIDATION

CLASS-19 WHAT IF ANALYSIS PART 1

CLASS-20 WHAT IF ANALYSIS PART 2

CLASS-21-VLOOKUP FUNCTION

CLASS-22-HLOOKUP & LOOKUP FUNCTION

CLASS-23-MATCH FUNCTION

CLASS-24-INDEX FUNCTION

CLASS-25-INDEX REFERENCE FORMAT

CLASS-26-CHOOSE & INDIRECT

CLASS-27-OFFSET & VLOOKUP ASSIGNMENT

CLASS-28-PIVOT TABLE PART 1

CLASS-29-PIVOT TABLE PART 2

CLASS-30-PIVOT TABLE PART 3

CLASS-31-PIVOT TABLE PART 4

CLASS-32-CHART & GRAPH

CLASS-33-DASHBOARD

CLASS-34-DASHBOARD

₹3,999.00

Course level: Expert

Get In Touch

C-54 ,Third Floor, Sector-2, Near Sec-15 Metro Station, Noida ,Landmark-Priyagold Building , Uttar Pradesh , 201301

+91-7065069985

query@innozant.com

Excel VBA 365 Video Course

About Course

🎯 Course Overview

📚 Course Content / Modules

⏱ Video Format & Delivery

Course Content

CLASS-1-WHY EXCEL CAREER ROADMAP

WHY EXCEL CAREER ROADMAP

CLASS-2 EXCEL BASICS & PASTE SPECIAL

EXCEL BASICS & PASTE SPECIAL

CLASS-3 FORMULA REFERENCE

FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATING

CONDITIONAL FORMATING

CLASS-5-LOGICAL FUNCTION

LOGICAL FUNCTION

CLASS-6 LOGICAL FUNCTION

LOGICAL FUNCTION

CLASS-7 MATH FUNCTION

MATH FUNCTION

CLASS-8 TEXT FUNCTION 1

TEXT FUNCTION 1

CLASS-9 TEXT FUNCTION 2

TEXT FUNCTION 2

CLASS-10 DATE FUNCTION

DATE FUNCTION

CLASS-11 STATISTICAL FUNCTION 1

STATISTICAL FUNCTION 1

CLASS-12-STATISTICAL FUNCTION PART 2

STATISTICAL FUNCTION PART 2

CLASS-13 DATABASE & INFORMATION FUNCTION

DATABASE & INFORMATION FUNCTION

CLASS-14 GOTO SPECIAL

GOTO SPECIAL

CLASS-15 SORTING

SORTING

CLASS-16 FILTER & ADVANCED FILTER

FILTER & ADVANCED FILTER

CLASS-17 TEXT TO COLUMN

TEXT TO COLUMN

CLASS 18 DATA VALIDATION

DATA VALIDATION

CLASS-19 WHAT IF ANALYSIS PART 1

WHAT IF ANALYSIS PART 1

CLASS-20 WHAT IF ANALYSIS PART 2

WHAT IF ANALYSIS PART 2

CLASS-21-VLOOKUP FUNCTION

VLOOKUP FUNCTION

CLASS-22-HLOOKUP & LOOKUP FUNCTION

HLOOKUP & LOOKUP FUNCTION

CLASS-23-MATCH FUNCTION

MATCH

CLASS-24-INDEX FUNCTION

INDEX ARRAY FORMAT

CLASS-25-INDEX REFERENCE FORMAT

INDEX REFERENCE FORMAT

CLASS-26-CHOOSE & INDIRECT

CHOOSE & INDIRECT

CLASS-27-OFFSET & VLOOKUP ASSIGNMENT

OFFSET & ASSIGNMENT

CLASS-28-PIVOT TABLE PART 1

PIVOT TABLE 1

CLASS-29-PIVOT TABLE PART 2

PIVOT TABLE 2

CLASS-30-PIVOT TABLE PART 3

PIVOT TABLE PART 3

CLASS-31-PIVOT TABLE PART 4

PIVOT TABLE PART 4

CLASS-32-CHART & GRAPH

CHART & GRAPH

CLASS-33-DASHBOARD

DASHBOARD

CLASS-34-DASHBOARD

DASHBOARD

Quick Links

Courses

Get In Touch