0

Beginners Excel VBA

Course Details
Trainer Name

Alexandra Kropova

Skill Area

Reviews

4.5 (4 Rating)

Course Requirements

Need a computer

Course Description

Learn how to build your first macros with this beginners VBA course. Learn Excel Visual Basic for Applications to automate your Excel workflow.

Build Projects Including:

Learn how to send messages with MsgBox.

Learn how to automate workbooks with the Workbook object.

Program ranges with the Range object.

Manipulate range properties with VBA macros.

Build hands on projects to automate Excel.

Learn the fundamentals of programming: variables, conditionals, and more with VBA projects.

And much more!

Course Outcomes

1.Knows how to use VBA MsgBox
2.Knows how to use VBA Workbook and sheets
3.Knows how to use VBA Range Object
4. Knows how to use VBA Properties
5.Knows how to use VBA Projects

Course Curriculum

1 How to Save Macros.mp4

2 Course Overview.mp4

1 Topics Overview.mp4

2 Build a Simple Message.mp4

3 Build an Advanced Message.mp4

4 Empty a Sheet with the MsgBox Function.mp4

5 Prompt User for Input.mp4

1 Topics Overview.mp4

2 Object Hierarchy.mp4

3 Change Multiple Worksheets.mp4

4 Add and Count Worksheets.mp4

5 Get Path of a Workbook.mp4

6 Loop through Worksheets and Workbooks.mp4

7 Build a Sales Calculator.mp4

8 Change Charts.mp4

9 Open and Close Workbooks.mp4

1 Topics Overview.mp4

2 Program a Range of a Spreadsheet.mp4

3 Use Cells Instead of a Range.mp4

4 Use a Range Variable.mp4

5 Select a Range.mp4

6 Copy and Paste a Range.mp4

7 Clear a Range.mp4

8 Count a Range.mp4

9 Access a Row.mp4

1 End Property.mp4

2 Topics Overview.mp4

3 Find the Current Region of a Cell.mp4

4 Dynamic Range Program.mp4

5 Resize a Range.mp4

6 Select Entire Rows and Columns.mp4

7 Offset Property.mp4

1 Topics Overview.mp4

2 Union and Intersect of Ranges.mp4

3 Detect Content.mp4

4 Build a Range Program.mp4

5 Change Text Color.mp4

6 Bold a Range.mp4

7 Change Cell Color.mp4

8 Work with Areas.mp4

9 Find Differences in Ranges.mp4

1 Topics Overview.mp4

2 Integer Data Type.mp4

3 String Data Type.mp4

4 Double Data Type.mp4

5 Boolean Data Type.mp4

6 Retain Variable Value.mp4

1 Topics Overview.mp4

2 If Then Statement.mp4

3 Else Statement.mp4

1 Topics Overview.mp4

2 Greeting Program - Logical Operator And.mp4

3 Logical Operator Or.mp4

4 Logical Operator Not.mp4

1 Topics Overview.mp4

2 Select Case.mp4

3 Build a Commission Calculator Project.mp4

4 Find Remainder with Mod.mp4

5 Check Number Program.mp4

6 K Smallest Value Program.mp4

7 Group by Font Style.mp4

8 Remove Empty Cells.mp4

Trainer

Trainer Name

Alexandra Kropova

4.5 Rating
4 Reviews

More Courses by Author

Free

Introduction To Loop Projects
0/5
9 Lessons 40 Enrolment
Free

Understanding How to Build Arrays in Excel
0/5
9 Lessons 62 Enrolment

Learner Feedback

Beginners Excel VBA

0

Course Rating
0.00%
0.00%
0.00%
0.00%
0.00%

No Review found

Log In or Sign Up as learner to post a review

Course you might like

Free

Excel VBA The VBA Beginner's Blueprint to Programming Excel
4/5
106 Lessons 89 Enrolment
Free

Zero Microsoft Excel Complete 2020
5/5
34 Lessons 2465 Enrolment

Free

Enrol Now

This course includes:

  • Duration: 5 Hours 9 Min

  • Skill Level: Beginner

  • Lectures: 62 lessons

  • Enrolled: 136 learners

  • Certificate of Completion

  • Lifetime access

Shopping Cart

Loading...
View cart Checkout