![]()
Syste
m (Hardware/Software)
Requirements
| Operating
Software | Windows XP or
Higher
| | Processor | Minim
um P4 or Higher
| | RAM | 1 GB or
Higher
| | Browser | Any
| | Recommended Internet
Speed | Minimum 1MBPS
| | Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| | Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionWhen we have to make repetitive reports, dashboards or slides, when the work on excel sheet gets complex and repetitive, the most important solution would be to automate the worksheets and save a lot of time. By using Excel VBA, we can automate several areas of data analysis, reporting and modeling work. VBA & Macros Program is important for those who:
Want to apply the VBA Programming language to make their excel spreadsheets more powerful
Looks forward to automate their repetitive excel spreadsheets, reports or dashboard
Want VBA to help them use Excel better
This introduction course to VBA & Macros will provides you a snapshot about Visual Basic for Applications allows you to automate various activities you do in Excel. By using Excel VBA, we can cut down the time we spend repeating these steps and improve our productivity. The main goal of this course is to see how repetitive reports, dashboards or slides can be automated using the powerful tool called VBA & Macros.
In this course you get access to some of our awesome VBA Macros videos which will help you to gain foundation knowledge over this most used spreadsheet software.
Course Curriculum
Section1:Introduction ton VBA Macros
Lecture1:Introduction ton VBA Macros
Section2:My First Macro
Lecture2:My First Macro
Lecture3:My First Macro - part 1
Lecture4:My First Macro - part 2
Section3:VBA Environment
Lecture5:VBA Environment
Lecture6:VBA Environment - Project Explorer
Lecture7:VBA Environment - Properties
Lecture8:VBA Environment - Run Break Reset and Design
Lecture9:VBA Environment - Debug - Toggle
Lecture10:VBA Environment - Debug - Local Window
Lecture11:VBA Environment - Debug - Watch and Immediate Window
Section4:Conclusion
Lecture12:Conclusion
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
