In this course, you will acquire the skills to automate routine tasks and develop custom functionalities to enhance performance and efficiency in your Excel work.
Overview
#EPH4V
Programming
Construction
An implementation idea, a laptop
Basic Excel skills
Windows
Visual Basic Editor
Online (Skype)
10 participants
Vietnamese
What you'll learn?
Price
75 USD
No
Section
Closed
Course Content
Lesson 1
Introducing macro recording, the Visual Basic editor, and managing macros.
Document
Exercise
Lesson 2
Variables, data types, operators, conditional statements, and loop statements in VBA.
Document
Exercise
Lesson 3
Basic objects in Excel.
Document
Exercise
Lesson 4
Custom procedures and functions in VBA.
Document
Exercise
Lesson 5
Creating events, working with files, and handling errors.
