Library

Course: Teach yourself Excel VBA Step by Step

Teach yourself Excel VBA Step by Step

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

In this course the author Sam Parulekar, demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including recording a macro in stages, The course wraps up with a macro project brings together each of the elements in a real-world scenario. Exercise files accompany the course.

Topics include:

  • Understanding the VBA environment
  • Recording macros in stages
  • Writing VBA code
  • Using loops
  • Debugging macros
  • Testing
  • Copying Data from one worksheet to another
Basic knowledge
  • The student should have working knowledge of Excel
  • The student should have a computer with Excel installed (any version will do)
What you will learn
  • Enabling the Developer Tab
  • Writing and running your first Macro Program
  • How to edit a recorded Macro
  • How to perform calculations using Macro
  • Looping Data using Do and For Loop
  • Conditional formatting using Macros
  • Using Cell properties
  • Finding next blank row
  • How to Copy data from one worksheet to another
Curriculum
Number of Lectures: 15
Total Duration: 01:44:21
Introduction
  • Introduction to Excel VBA  
  • Enabling the Developer Tab  
Studying Excel VBA
  • Writing and running your first Macro Program  
  • How to Record and Run a Macro  
  • How to edit a recorded Macro  
  • How to perform calculations using Macro  
  • Looping Data using Do while Loop  
  • Looping Data using For Next Loop  
  • Conditional Formatting Using Macros  
  • Nested do while to find duplicates  
  • Using Cell property to Select Excel Worksheet Cell  
  • Navigate in Excel Worksheet with offset property  
  • Find Next Blank Row with VBA  
  • How to Copy Data from one Excel Sheet to another and Print  
Ending the Session
  • Congratulations you finished the course  
Reviews (0)