UDEMY
UDEMY Logo

VBA Excel - Start Basic Finish Advanced 

  • Offered byUDEMY

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Overview

A practical guide to using VBA with Excel

Duration

3 hours

Total fee

8,640

Mode of learning

Online

Credential

Certificate

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Highlights

  • Earn a Certificate of completion from Udemy
  • 30-Day Money-Back Guarantee
  • Full lifetime access
  • Access on mobile and TV
  • Practical real world application of VBA macro writing
Read more
Details Icon

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Course details

Skills you will learn
Who should do this course?
  • For Students with some knowledge of VBA who want to start writing more professional code
What are the course deliverables?
  • How to write VBA code
  • Build an automated charting tool using VBA forms
  • Programming fundamentals
  • Macro writing
More about this course
  • We cover the basics right through to the more advanced concepts and this is all delivered through the implementation of a real world example

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Curriculum

User Interaction

Creating a Simple userform

Subs and Functions

Kicking off with Subs and Functions

Variables and Data Types

Variables and Data Types Part 1

Variables and Data Types Part 2 (advanced)

Operators, Decision Making and Loops

Arithmetic Operators

Logical Operators

Comparison Operators

Concatenation Operators

Decision Making

Loops

Classes and Objects

Class Properties

Accessing our objects properties

Adding Min and Max Property Access

Custom Logic Within Property Access

Debugging And Testing our code

Calling the Code Under Test

Debugging Continued

Faculty Icon

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Faculty details

Craig Barry
Craig holds a masters degree in automotive engineering with a keen passion for writing and teaching how to write software. He currently works for a small engineering consultancy based in Cambridge England

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
549
4 hours
– / –
599
10 hours
– / –
View Other 2346 CoursesRight Arrow Icon

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 
Students Ratings & Reviews

4/5
Verified Icon1 Rating
J
Jyothi Kotian
VBA Excel - Start Basic Finish Advanced
Offered by UDEMY
4
Other: Udemy is regionable for upgrade out skills
Reviewed on 16 Aug 2021Read More
Thumbs Up IconThumbs Down Icon
View 1 ReviewRight Arrow Icon
qna

VBA Excel - Start Basic Finish Advanced
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...