The Excel VBA Programming Course – Beginner Level

£99.00

Description

Course description

Take “The Excel VBA Programming Course” to learn Excel Visual Basic for Applications (VBA), the Microsoft’s programming language for Excel and all the other Microsoft Office programs:

  • Learn Object Orientated Programming
  •  Record and save Macros
  •  Work with the VBA Editor
  •  Learn Variables and Procedures
  •  Learn Loops and IF Statements
  •  Learn Error Handling
  •  Learn User Defined Functions
  •  Create Forms
  •  Practice with assignments
Who this course is for:
  • Students and Corporate employees wanting to improve their Excel skills
Video Order

  1. Section 1
    1. What is VBA (00:58)
    2. Object Orientated Programming (06:17)
  2. Section 2
    1. Macros Initial Setup (04:48)
    2. Recording a Macro (05:41)
    3. Saving a Macro (04:16)
  3. Section 3
    1. Launching VBA (04:03)
    2. VB Editor (05:10)
    3. Custom Menu (02:50)
    4. Naming Projects (05:18)
    5. Modules (02:42)
    6. Code Window (01:43)
    7. Comments (06:37)
  4. Section 4
    1. Introduction (01:30)
    2. Variables (06:24)
    3. Variable Exercise (05:54)
    4. What are Procedures (05:45)
    5. What are Procedures – Part Two (06:25)
    6. What are Procedures – Part Three (03:00)
    7. Message Boxes (04:58)
    8. Input Box (05:59)
    9. Input Box – Part Two (03:45)
    10. Basic Navigation (11:54)
    11. Sheets (13:06)
    12. Cell Navigation (08:38)
    13. Advanced Sheets (08:45)
    14. Offset (05:25)
  5. Section 5
    1. Introduction (00:39)
    2. Operators (01:56)
    3. Using Variables (12:09)
    4. What is Automation (01:12)
    5. For Loop (06:30)
    6. Do Loops (06:08)
    7. IF Statements (14:21)
    8. IF Statements – Part Two (10:10)
    9. Select Case (12:21)
  6. Section 6
    1. Debugging (02:42)
  7. Section 7
    1. UDF’s (12:36)
      • (Resource – [Beginner Shortcut Keys.pdf])
      • File UDF’s
    2. Section 8
      1. Introduction (00:47)
      2. Exercise 1 – Record a Macro (07:03)
        • (Resource – [Beginner Shortcut Keys.pdf])
        • File Insert Text
      3. Exercise 2 – Duplicating Data (07:45)
        • (Resource – [Beginner Shortcut Keys.pdf])
        • File All Sheets
      4. Exercise 3 – Generate a Report (12:42)
        • (Resource – [Beginner Shortcut Keys.pdf])
        • File Generate Report
      5. Generate a Report – Part Two (07:29)
      6. Exercise 4 – Inner and Outer Loops (09:27)
        • (Resource – [Beginner Shortcut Keys.pdf])
        • File Weekly Stock Report
      7. Inner and Outer Loops – Part Two (11:54)
      8. Inner and Outer Loops – Part Three (08:18)
      9. Inner and Outer Loops – Part Four (09:45)
      10. Inner and Outer Loops – Part Five (12:45)
    3. Section 9
      1. Form Controls (04:01)
      2. Building the Form (15:17)
      3. Initialize the Form (07:12)
      4. Command Buttons (18:36)
      5. Command Buttons – Part Two (07:00)
Yvar is a registrated trade name of Ster Shop BV

Eindhovenseweg 116 5582HW Waalre
The Netherlands.

T: +3140844000
E: info@yvar.com
KVK: 17110779
BTWnr: NL8110.24.106.B01
IBAN: NL10ABNA0533372631

FAQ | Contact | Terms and Conditions |