Training on Excel VBA & Applications

Excel VBA Fundamentals 1
- Lecture1.1
  
  LESSON MATERIALS
Section 1: Introduction 8
- Lecture2.1
  
  Excel VBA Introduction 12 min
- Lecture2.2
  
  Developer Tab 05 min
- Lecture2.3
  
  Saving and Recording a Macro 10 min
- Lecture2.4
  
  Ways to Run Macro 07 min
- Lecture2.5
  
  How to Get VBA Codes 14 min
- Lecture2.6
  
  How to Get VBA Codes 2 09 min
- Lecture2.7
  
  How to Vet a Macro 05 min
- Lecture2.8
  
  Writing a Macro: Cell Referencing 19 min
Section 2. Writing a Macro 12
- Lecture3.1
  
  Excel VBA Copy and Paste 10 min
- Lecture3.2
  
  Excel VBA Font 10 min
- Lecture3.3
  
  Excel VBA Font Color 07 min
- Lecture3.4
  
  Excel VBA Background Color 05 min
- Lecture3.5
  
  Excel VBA Delete Cells 06 min
- Lecture3.6
  
  Excel VBA Insert Row & Column 05 min
- Lecture3.7
  
  Excel VBA Delete Row & Column 04 min
- Lecture3.8
  
  Excel VBA Hide & Unhide Column 03 min
- Lecture3.9
  
  Excel VBA Hide and Unhide Rows 03 min
- Lecture3.10
  
  Excel VBA Merge and Unmerge 05 min
- Lecture3.11
  
  Excel VBA Hide and Unhide Sheet 05 min
- Lecture3.12
  
  Excel VBA Protect and Unprotect Sheet 06 min
Section 3: Building Block 3
- Lecture4.1
  
  Excel VBA Number to Text 07 min
- Lecture4.2
  
  Excel VBA Comments 06 min
- Lecture4.3
  
  Variable 09 min
Section 4: Loops 9
- Lecture5.1
  
  Excel VBA For Loops 01 10 min
- Lecture5.2
  
  Excel VBA Loop 2 10 min
- Lecture5.3
  
  Excel VBA Loop 3 05 min
- Lecture5.4
  
  Excel VBA For Loop 4 03 min
- Lecture5.5
  
  Excel VBA For Loop 5 03 min
- Lecture5.6
  
  Excel VBA For Loop_ Sheet Name 04 min
- Lecture5.7
  
  Excel VBA Foe Each Next Loop 03 min
- Lecture5.8
  
  Excel VBA Do While Loop 07 min
- Lecture5.9
  
  Excel VBA Do Until Loop 08 min
Section 5: Conditional Statement 7
- Lecture6.1
  
  Excel VBA If Statement 05 min
- Lecture6.2
  
  Excel VBA If and Else 03 min
- Lecture6.3
  
  Excel VBA If else If else 10 min
- Lecture6.4
  
  Excel VBA If Else If Else AND 07 min
- Lecture6.5
  
  Excel VBA If Else Using Loop 06 min
- Lecture6.6
  
  EXCEL VBA If else using Loop2 07 min
- Lecture6.7
  
  Excel VBA Case Statement 07 min
Section 6: User Form 10
- Lecture7.1
  
  Excel VBA User Form 08 min
- Lecture7.2
  
  Excel VBA Command Button 09 min
- Lecture7.3
  
  Excel VBA Radio Button 07 min
- Lecture7.4
  
  Excel VBA Check Box 12 min
- Lecture7.5
  
  Excel VBA List Box 06 min
- Lecture7.6
  
  Excel VBA Frames 07 min
- Lecture7.7
  
  Excel VBA Multipage 07 min
- Lecture7.8
  
  Excel VBA Background 06 min
- Lecture7.9
  
  Excel VBA Text Box 12 min
- Lecture7.10
  
  Excel VBA Call and Refer(Link User Forms) 09 min
Section 7: Time Series VBA Applications 5
- Lecture8.1
  
  Excel VBA Timer 12 min
- Lecture8.2
  
  Excel VBA Count Down Timer 13 min
- Lecture8.3
  
  Excel VBA Timer and Countdown Timer 16 min
- Lecture8.4
  
  Excel VBA Digital Clock 12 min
- Lecture8.5
  
  Excel Automated Attendance Register 24 min
Section 8: Forms Applications 4
- Lecture9.1
  
  Excel VBA User Form A 18 min
- Lecture9.2
  
  Excel VBA Customer Call Log Form 28 min
- Lecture9.3
  
  Excel VBA Database1.0 29 min
- Lecture9.4
  
  Data Base Simplified 37 min
Section 9: Files Collator & Result Analysis 6
- Lecture10.1
  
  Excel Fully Automated and Dynamic Collator 12 min
- Lecture10.2
  
  Result Analysis 37 min
- Lecture10.3
  
  Result Template 33 min
- Lecture10.4
  
  Cumulative Result 27 min
- Lecture10.5
  
  Bills Template 17 min
- Lecture10.6
  
  Extra Tips 19 min
Section 10: Built Models 3
- Lecture11.1
  
  Excel VBA Data Base 2.0 08 min
- Lecture11.2
  
  Student’s Registration Page 09 min
- Lecture11.3
  
  Data Base Simplified 37 min

1 Comments

Leave A Reply Cancel reply

1 Comments

Leave A Reply Cancel reply

Excel VBA Fundamentals 1

Section 1: Introduction 8

Section 2. Writing a Macro 12

Section 3: Building Block 3

Section 4: Loops 9

Section 5: Conditional Statement 7

Section 6: User Form 10

Section 7: Time Series VBA Applications 5

Section 8: Forms Applications 4

Section 9: Files Collator & Result Analysis 6

Section 10: Built Models 3