Excel VBA 365 Video Course - Innozant MIS & Data Analytics & Data Science

A
Administrator Expert
  • Home  
  • Excel VBA 365 Video Course

Description

🎯 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.

Topics for this course

32 Lessons

CLASS-1-WHY EXCEL CAREER ROADMAP

WHY EXCEL CAREER ROADMAP00: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

₹3,999.00
  • Course level: Expert