Master Excel VBA
Learn Macro from Basic to advance level. Learn to Automate Complex Tasks with Real World Projects and Examples
Lectures -62
Resources -6
Duration -5.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
MS Excel is an integral part of the MIS profession and one of the most useful Applications for reporting and analysis. However to be successful in this field only having knowledge of MS Excel is not sufficient, the aspirant has to be well-versed in Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro enables the user to create a function it often requires. While the user records macros Excel does VBA programming for you. You may work on very advanced-level projects if you have got knowledge of VBA. Our course curriculum has been considered one of the most advanced ones. Moreover, it enables the user to do what can we do in Excel but a thousand times faster. Excel is the world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove the redundancy in your workflow and accelerate your productivity drastically!
No programming experience is required - complete beginners are more than welcome! VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment.
No extra software is necessary - VBA is bundled with all modern versions of Excel.
Goals
What will you learn in this course:
- Learn how to automate daily routine tasks within Excel
- Learn best practices when creating macros
- Learn to use the Macro Recorder effectively
- Learn how to write custom VBA Macros to create more robust automation
- Reduce manual routine tasks to the click of a button
- Create simple solutions to complex problems by levering Excel functionality with Macros
- Learn to create interactive Userform
- Learn to make customized functions through VBA
Prerequisites
What are the prerequisites for this course?
- Understanding of MS Excel is required
Curriculum
Check out the detailed breakdown of what’s inside the course
Getting Started with Macro Recording
4 Lectures
- Understanding Macro Recording 15:17 15:17
- Macro Recording - Example 2 05:19 05:19
- Macro Recording - Example 3 03:10 03:10
- Methods to Run Macros 05:59 05:59
Getting start with Excel VBA Programming
3 Lectures
Handling Range/Cell Object
7 Lectures
Handling Object - Sheets and Workbook
7 Lectures
Variables and Data Types
5 Lectures
Logical Method Handling in Excel VBA
7 Lectures
Working with LOOP
13 Lectures
Events Handling in Excel VBA
4 Lectures
Function in Excel VBA
4 Lectures
Control Outlook and Pivot Table with Macro
3 Lectures
Files and Folders Handling with Excel VBA
4 Lectures
Userform in Excel VBA
1 Lectures
Instructor Details
Himanshu Kumar Dhar
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now