Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Visual Basic for Applications (VBA) extends the functionality of ordinary Excel sheets by automating common tasks, customize the interface to your specific needs, and perform complex calculations which don't exist natively in Microsoft Excel. Using this straightforward programming language, you can quickly sort columns and rows, add user controls such as buttons and forms, create reports that update as data changes, and calculate values across multiple worksheets. This course have been crafted to help you develop skill in Excel, so after completing this course, you will be able to leverage your VBA skills in other Office applications, like MS Access and Word.
Upon completing this course you will be prepared to:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Steps to download Exercise Workbook
Important Tip: Save Macro Workbook As Macro Enabled Workbook(.XLSM)
|Section 2: Recording Macro|
Use of Relative ReferencesPreview
|Section 3: Getting Started with VBA|
Sub - End Sub
Copy Paste in Excel VBA
The Cells Property
|Section 4: Working with Variables|
Last Non blank Cell in a row or column – Range.End() Method
|Section 5: Conditional Statements|
IF Else IF
Conditional and Logical Operators
With - End With Statement
|Section 6: Looping|
For Each Loop
Exercise: For Loop
Combine Multiple Workbook into One
|Section 7: Array|
Multi Dimensional Array
|Section 8: Userforms|
User Defined Function
I am the founder of ExcelCrazy and has worked with prestigious companies like Cisco, Sapient in the past 8 years as Data Consultant. Now working as full time trainer(Excel, VBA, SAS and Tableau) and Data consultant.