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

Administrator Expert

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

20 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

3,999.00
  • Course level: Expert