Instructors
Excel VBA Programming
0 STUDENTS ENROLLED
Visual Basic for Applications. It’s a programming language that enables you to control just about everything in Excel. You’ll learn how to create Macros that can be run from things like a button on a spreadsheet.
Course Curriculum
Session - 1 | |||
Excel navigation through developer tab | 00:00:00 | ||
Record the first macro using manual process | 00:00:00 | ||
Get through excel vba .notation | 00:00:00 | ||
Session - 2 | |||
VBA conditional logic using If then Else if | 00:00:00 | ||
Conditional and logical operators | 00:00:00 | ||
Programming Loops and Arrays | 00:00:00 | ||
String Functions VBA | 00:00:00 | ||
Session - 3 | |||
Subs and Functions | 00:00:00 | ||
VBA code for data importing and connection to db | 00:00:00 | ||
Advanced VBA queries for sheet navigation and filters | 00:00:00 | ||
Session - 4 | |||
Excel VBA user forms | 00:00:00 | ||
Excel VBA Charts, Embedded Charts, Charts and User Forms etc | 00:00:00 |