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