Course Overview:
Microsoft Excel is the most essential and powerful application of the Microsoft Office package. It is widely used for data recording, summarizing, interactive reporting, various types of critical data analysis, and excel related work automation.
Sometimes you may struggle and kill huge times to do your daily excel works to fulfill your management’s requirements within the timeline. If you are aware of the capability of Excel’s most productive tools, techniques, and features, you can save huge times professionally.
This professional video training on “Microsoft Excel – VBA & Macro” will help you to build the macro-enabled Excel workbook. You will learn how to write MACRO & VBA script/code without having any prior programming knowledge to automate the action that will work for you.
After completing this course, you will be able to record the macro, write VBA script, change script in Visual Basic Editor window and assign the action with button or objects and you can work MACRO and VBA related work independently. Then you will show the magic of Excel automation. You will also learn the techniques to write a VBA script without having any programming knowledge. Your daily excel work will be easier and you will show the magic of Excel in your office.
- Course Duration: 04 Hours
- Total Sections: 13
- Total Lectures: 35
Supported Versions for Practice:
- Excel 2010, 2013, 2016, 2019, office 365 and most will work in 2007
What Next by the Same Trainer?
- Microsoft Excel – Advanced Level (8 Hours)
- Microsoft Excel – Data Analysis and Dashboard Reporting with Project (6 Hours)
- Microsoft Excel – PivotTable in Depth with PowerPivot with Project (6 Hours)
- Most Common Features of Excel for Professionals (7 Hours)
- Microsoft Excel – PowerPivot, Power Query and Power BI with Project (12 Hours)
Training Methodology:
- Professional best quality video tutorial with workings
- Bite-sized project-based business examples
- Student can download the same excel data for practice
- After each session, you can take quiz participation
- Bengali language with clear easy presentation
Requirements:
- You should have basic Microsoft Excel knowledge
- You should have an internet-connected PC, mobile or TV
Who This Course is for:
- Designed for excel users who are brand new to VBA & Macro
- Regular excel users and want to learn VBA & Macro step by step
- Excel users using VBA & Macro and want to gather in-depth knowledge
- Business reporters who want to automate their Excel files
- Excel trainers who want to gather the clear concept of different VBA terms
Course Content:
- Section-1: Introduction
- Section-2: Start Working with VBA and Macros
- Section-3: Visual Basic Editor (VBE) – Change the VBA Script
- Section-4: Various Visual Basic Concepts and Environments
- Section-5: Subroutine and Execution
- Section-6: Event and Execution
- Section-7: MessageBox and InputBox
- Section-8: Using UserForm in Excel
- Section-9: Managing Various Form Controls
- Section-10: Errors, Debugging and Error Handling
- Section-11: Complete Project to Create a Data Entry Form
- Section-12: User Defined Function (UDF)
- Section-13: Creating Add-ins
Notes:
- After completing each lesson, you have to click on the “COMPLETE” button then go to the next lesson.
- Must fill up your first name, last name then display name for your certificate.
- You have to complete all quizzes with a minimum 70% correct answer & within 5 Re-take.
- Complete every lesson of this course serially.
- Don’t click on “FINISH COURSE” button.
- If you click on the “FINISH COURSE” button then the course will be finished, you will unable to complete the next lessons or parts of this course and a Certificate will be generated.
- Download the documents of this course from Lecture 1.3
Course Instructor:
Courses of this Instructor:
- Most Common Features of Excel for Professionals
- Microsoft Excel – VBA & Macro
- Excel VBA & Macro
- Microsoft Excel-Professional Tips & Tricks
- Most Out of Excel
What Next by the Same Trainer?
- Microsoft Excel – Advanced Level (8 Hours)
- Microsoft Excel – Data Analysis and Dashboard Reporting with Project (6 Hours)
- Microsoft Excel – PivotTable in Depth with PowerPivot with Project (6 Hours)
- Microsoft Excel – VBA and Macro for Excel Users with Project (8 Hours)
- Microsoft Excel – PowerPivot, Power Query and Power BI with Project (12 Hours)
Course Features
- Lectures 37
- Quizzes 12
- Duration 4 hours
- Skill level All levels
- Language Bangla
- Students 45
- Certificate Yes
- Assessments Self
-
Introduction
-
Start Working with VBA and Macros
-
Visual Basic Editor (VBE) – Change the VBA Script
-
Various Visual Basic Concepts and Environments
-
Subroutine and Execution
-
Event and Execution
-
MessageBox and InputBox
-
Using UserForm in Excel
-
Managing Various Form Controls
-
Errors, Debugging and Error Handling
-
Complete Project to Create a Data Entry Form
-
User Defined Function (UDF)
-
Creating Add-ins
-
Reaz Chowdhury
need more updated curriculum
this is a very useful topic for any advanced excel learners. need more updated course curriculum which will be helpful -
Md.Jewel
Useful Course topics to develop carrier
I would like to especially thanks to Nazmul Muneer for his touching presentation & make me more curious about excel. -
Nobel Haider
Excellent course topics and Great Presentation
I searched VBA & Macro Course in Bangladesh for a long time but it is very much rare. I personally thank Mr. Nazmul Muneer to offer this kind of prestigious video course in Bangla language in very affordable price. The trainer is very knowledgeable and presented every example very easily and I really enjoyed when I viewed the videos. I really love it. Again, Thank You Mr. Muneer
Leave A Reply
You must be logged in to post a comment.
3 Comments
After successfully completed this course may I able to automate outlook by VBA?
No. We did not described Outlook automation related techniques.
In this course only Excel related automation techniques have been described.
nice presentation. but need to learn more. please let me know if you have any more updated course for this VBA