Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel VBA Expert Tutorial

Learnit Training via YouTube

Overview

This course teaches users how to automate repetitive processes and build tools in Excel using Visual Basic for Applications (VBA). By the end of the course, learners will be able to create macros using essential VBA concepts such as Loop and If Then. The course includes practical exercises and covers topics like Worksheets Methods, DateSerial, Format, and Custom Functions. The intended audience includes Business Analysts, Data Scientists, and anyone interested in expanding their Excel skills through automation and customization.

Syllabus

Start
Worksheets Methods

DateSerial and Format

Sheet Template Generator

Move

PrintOut and PrintPreview

Practice Part 1

Practice Part 2

Practice Part 3

Practice Part 4

Practice Part 5

Practice Part 6

Custom Functions Part 1

Custom Functions Part 2

Custom Functions Part 3

Wrapping Up

Taught by

Learnit Training

Reviews

Start your review of Excel VBA Expert Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.