Would like to automate your daily tasks in Excel VBA. This is the right place to start.

Topics Covered

This course will cover the below topics: Lesson 1: Introduction Lesson 2: Data Types, Constants and Variables Lesson 3: Operators Lesson 4: Writing the Code Lesson 5: Subroutines and Functions Lesson 6: Mathematical Functions Lesson 7: Formatting Functions Lesson 8: String Manipulating Functions Lesson 9: Arrays Lesson 10: Decision Making 1: I-Then-Else Lesson 11: Decision Making 2: Select Case-End Select Lesson 12: Looping Lesson 13: Do…..Loop Lesson 14: Errors Handling Lesson 15: UserForm Lesson 16: Introduction to Excel VBA Objects Part 1 Lesson 17: Introduction to Excel VBA Objects Part 2 Lesson 18: The Range Object Lesson 19: The Worksheet Object Lesson 20: The Workbook Object Lesson 21: Formatting Fonts and Background Colors Lesson 22: Working with Check Box and Option Button Lesson 23: Working with List Box, Combo Box and Toggle Button Lesson 24: Creating Charts and Graphs

Who should attend

Those who would like to learn Excel VBA.

Pre-requisites

Basic knowledge of Excel

What you need to bring

Personal Laptop

Key Takeaways

At the end of the class one would be able to Excel Program in VBA.