We provide software development online courses in Java, C#, .NET, VB, Visual Basic, PHP, MySQL, Javascript, PERL, C, C++, Excel VBA, OOAD, object-oriented analysis and design
Registration Benefits:
• 4 videos
• Lecture notes
• Exercises for each unit with solutions
• Email support from the instructor
• Equivalent to UCSC Extension Course 19335
costing over $320
Excel VBA for Beginners
This course will teach fundamentals of programming using Excel VBA programming language. The topics covered include: variables, data types, decision making, loops and interacting with spreadsheets.
This course is aimed at first time programmers and anyone wishing to get a quick introduction to VBA.
Upon completion of this course, you would acquire basic understanding of VBA and will be able to write simple VBA Function and Sub procedures.
Course Outline:
Free Unit
What is Excel VBA and why do I need it?
With registration you get the following units.
Unit 1
Datatypes, Variables, Assignment
• Primitive Datatypes
• Declarations
• Variable Names
• Expressions
• Assignment Operator
• Arithmetic Operators
Unit 2
Making Decisions
• Statements
• Conditional (if) Statements
• Adding an else if
• Conditional (switch) Statements
Unit 3
Loops
• while and do-while Loops
• for Loops
Unit 4
Arrays
• VBA Functions
Pre-requisites: No prior programming experience required.
Duration: Self-paced, most students complete the course in one week.