A macro is a programming language that runs in MS excel environment. The tool we used to write macros is VBA editor.
- High Quality Video Tutorials on Learn VBA macros.
- Includes E-books
- Includes links to source file
- VBA programming
VBA Editor: The editor is built in MS excel, all you need to install Ms excel (2010 or later).
- Nothing, as this course is for the beginners. But the knowledge of MS Excel will help you
The following things you will learn through out the course are given below:
- To automate the repetitive task in the spread sheets either from keyboard or mouse
- Instead of manually formatting the excel sheet you can use macro to automate that process
- You can customize and improve the spreadsheets, if you’re willing to code
- You can use VBA to program macros, build user forms for data entry, import and export data, and automatically update frequently changing data