Lethabo Chauke

Lethabo Chauke

I was able to understand everything taught in this course. I will definitely recommend onedollarcourses.com to all my colleagues.

I was able to understand everything taught in this course. I will definitely recommend onedollarcourses.com to all my colleagues.

Roliswa Mdluli

Roliswa Mdluli

I loved learning about coding. Course well laid out and presented.

I loved learning about coding. Course well laid out and presented.

What are the prerequisites?

What are the prerequisites?

  • Computer/Laptop
  • Microsoft VBA (for practicals)
  • Email for notifications and communications
  • Internet connection
  • PDF viewer (e.g ADOBE Acrobat)
  • A web browser
  • Computer/Laptop
  • Microsoft VBA (for practicals)
  • Email for notifications and communications
  • Internet connection
  • PDF viewer (e.g ADOBE Acrobat)
  • A web browser

What other related courses are offered?

What other related courses are offered?

We provide a variety of courses, from computer studies to leadership and softskills courses.

The following are our most popular courses:

We provide a variety of courses, from computer studies to leadership and softskills courses.

The following are our most popular courses:

This course was not easy but very interesting. I learned so much. Thank you for explaining everything so well.

This course was not easy but very interesting. I learned so much. Thank you for explaining everything so well.

Course Content

Course Content

Job Market Prospects

Microsoft Visual Basics is a huge advantage to have at many companies. 

Job Market Prospects

Microsoft Visual Basics is a huge advantage to have at many companies. 

What other people are saying:

What other people are saying:

How long does it take to complete?

How long does it take to complete?

How much does it cost?

How much does it cost?

Unit 1 - VBA coding- where to start

1.1 Developer toolbar

1.2 Understanding coding for macros

Unit 1 - VBA coding- where to start

1.1 Developer toolbar

1.2 Understanding coding for macros

Unit 2 - Basic Functions

2.1 Referencing to sheets

2.2 Referencing to ranges

2.3 Declaring a variable

Unit 2 - Basic Functions

2.1 Referencing to sheets

2.2 Referencing to ranges

2.3 Declaring a variable

Unit 3 - User Forms

3.1 Inserting a basic user form

3.2 Opening up and closing user forms

3.3 Labels, text boxes and lists

3.4 Checkboxes, option boxes and toggle boxes

Unit 3 - User Forms

3.1 Inserting a basic user form

3.2 Opening up and closing user forms

3.3 Labels, text boxes and lists

3.4 Checkboxes, option boxes and toggle boxes

Unit 5 - Loops

5.1 Loops

5.2 Using different modules for different macros and naming them

5.3 WITH statements

Unit 5 - Loops

5.1 Loops

5.2 Using different modules for different macros and naming them

5.3 WITH statements

Unit 7 - Other codes

7.1 Protecting sheets and unprotecting sheet with coding

7.2 Message boxes

7.3 Hiding and  unhiding sheet, rows and columns with coding

7.4 Inserting, deleting and renaming sheets

7.5 Clean cells

7.6 Running a code when opening a workbook

7.7 Using the personal macro workbook to save different codes and how to add codes to the customised ribbon

Unit 7 - Other codes

7.1 Protecting sheets and unprotecting sheet with coding

7.2 Message boxes

7.3 Hiding and  unhiding sheet, rows and columns with coding

7.4 Inserting, deleting and renaming sheets

7.5 Clean cells

7.6 Running a code when opening a workbook

7.7 Using the personal macro workbook to save different codes and how to add codes to the customised ribbon

Unit 4 - Formulas

4.1 If formulas

4.2 Nested IF formulas

4.3 Other formulas

Unit 4 - Formulas

4.1 If formulas

4.2 Nested IF formulas

4.3 Other formulas

It takes between 4 days and 2 weeks, depending on your speed.

It takes between 4 days and 2 weeks, depending on your speed.

only $1 + 25c

(The 25c is the administration fee)

only $1 + 25c

(The 25c is the administration fee)

Or

Or

Microsoft Excel Basic

Microsoft Excel Basic

Microsoft Excel Intermediate

Microsoft Excel Intermediate

Microsoft Access

Microsoft Access

Microsoft Word Beginner

Microsoft Word Beginner

Microsoft Excel Advanced

Microsoft Excel Advanced

Financial Modeling

Financial Modeling

Daniel Arendse

Daniel Arendse

Unit 6 - Finishing your program

6.1 Testing and debugging

6.2 Protecting your code

Unit 6 - Finishing your program

6.1 Testing and debugging

6.2 Protecting your code

Unit 8 - More complicated programs explained

8.1 Building a navigational sheet with buttons and userforms

8.2 Create a userform which updates a database every time you change the database

Unit 8 - More complicated programs explained

8.1 Building a navigational sheet with buttons and userforms

8.2 Create a userform which updates a database every time you change the database

Unit 9 - Free codes to use

9.1 Opening multiple files and importing data

9.3 Unhiding all sheets in a file

9.4 Listing all the sheet names in a specific file

Unit 9 - Free codes to use

9.1 Opening multiple files and importing data

9.3 Unhiding all sheets in a file

9.4 Listing all the sheet names in a specific file

Microsoft Visual Basic

Microsoft Visual Basic