Microsoft Excel VBA and Macros
This course will cover foundational concepts of Excel programming and the Visual Basic for Applications (VBA) tool designed to enhance productivity and automate manual tasks.
Segment 01: Introduction to the Course & Meet Your Instructor
Segment 02: What is Excel VBA?
Segment 03: Basics of Excel VBA
Segment 04: Recording Macros
Segment 05: Variables and Data Types
Segment 06: Control Flow Statements (If/Else, Loops)
Segment 07: Working with Ranges and Cells
Segment 08: Understanding Data Cleaning and Transformation
Segment 09: Developing VBA Scripts for Data Cleaning
Segment 10: Implementing Automated Data Cleaning Workflows
Segment 11: Congratulatory Statement for Learners