Excel VBA programming by Examples (MS Excel 2016) (Udemy.com)
Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook
Created by: Gopal Prasad Malakar
Produced in 2016
What you will learn
- Learn to automate their time consuming repeatitive tasks for more accuracy and less time consuming
- Understand VBA syntax for Excel
- Understand usage of tools available in VBA environment
- See several worked out examples
- Learn to fetch access data using Excel as a front end
- Learn to develop VBA froms and interact with the same, load charts on forms
- See inventory management workout
- And many other workout which i am adding step by step
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 86 / 100
Course Description
Understand what you are going to achieve through the VBA by seeing demo and then see step by step explanation of VBA code. Learn about Excel VBA syntax, Excel VBA form and control, methods of using forms and controls, several workout examples to see usage of Excel VBA for automation.
In this course, you will learn following stuff in step by step manner
Level 01 start without coding Automate tasks using Excel Macro recording
Demo of an excel macro
What is excel macro
When to use it
How to record a macro/create a shortcut action
How to run a recorded macro
How to create a shortcut for a macro action
How to run a recorded macro on a new dataset (excel workbook)
How to record a relative macro
What is the difference between a relative macro and a general macro.
How to understand what was recorded as macro.
How to delete a macro
Level 02 A Understand Excel VBA integrated development environment
How to reach VBA window
What are different component of the window
What is use of those components
How to use breakpoint, properties window, edit tools etc.
Level 02 B Understand Excel VBA syntax
How to define a variable
Different types of variables
How to write a for loop
How to display output in an interactive way
How to write output in a different worksheet
How to take user input through a prompt
How to use user input
How to use record macro to know VBA syntax
How to use breakpoint
How to run macro through click of a button
When you need to write do while / do until loop
Syntax of do while / until loop
How to take input from excel sheet for program execution
How to ensure variable names are correct before execution of program
If else command, If elseif else command
Using mod function (for remainder)
Showing status bar
Workout Examples 01 Using Forms for user entry, chart display etc.
See a worked out example of a VBA form
Learn about various control, design aspects of Excel VBA form
Learn about why will need form, and such controls
Hide Data sheet and format other sheet to make it look professional
Ensure proper data type
Ensure value selection from combo box only
Learn to define level, text, combobox and button command
Learn to pass dropdown data in combobox
Learn to use form entry into VBA
Learn to write back on Excel form
Learn how to load form while getting excel started
Learn to change properties of control through VBA
Workout Examples 02 fetching data from MS Access using Excel VBA
How to use Excel as front end and fetch data from microsoft Access database
Where to use this Greatly useful when many users have Excel but don't have MS access database in the PC
Where Reference is needed
Watch window - how to use it
How to edit the code for many fields and different databases
Workout Examples 03 One sheet per product or agent
How to use do while loop to let it run for as many records as it has got
How to find block size (starting and ending row for each product)
How to add sheet using VBA and give it a name
How to ensure that the tool remains intact with multiple runs and even a mistake can't cause issue
How to repeat header in each tab or worksheet
Workout Examples 04 Inventory management, coupon assignment and customer communication using Excel VBA
Traverse through various sheets and workbooks using VBA
Formatting date
Writing derived information from one sheet to another
Passing several parameters to VBA for conditional traversal
3 should mean three coupons to get reserved
[Coupon code : Validity] will need comma if there are multiple vouchers
Error handling : alert, if there are no coupons
Protecting Excel tool for further usage
Workout Examples 05 Reading data from a microsoft access database and writing it into a text file
Reading Microsoft Access data using VBAdirectly writing output into a text fileMaking the output comma separated
Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc.
Workout Example 07 - Insert Excel VBA form data in MS Access database
Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling workWorkout Example 09 - Windows based user authentication and Voice notification of execution of VBA
Who this course is for:
Microsoft Excel users who wants to learn automation and VBA programmingSomeone who wants to learn by seeing workout examples
In this course, you will learn following stuff in step by step manner
Level 01 start without coding Automate tasks using Excel Macro recording
Demo of an excel macro
What is excel macro
When to use it
How to record a macro/create a shortcut action
How to run a recorded macro
How to create a shortcut for a macro action
How to run a recorded macro on a new dataset (excel workbook)
How to record a relative macro
What is the difference between a relative macro and a general macro.
How to understand what was recorded as macro.
How to delete a macro
Level 02 A Understand Excel VBA integrated development environment
How to reach VBA window
What are different component of the window
What is use of those components
How to use breakpoint, properties window, edit tools etc.
Level 02 B Understand Excel VBA syntax
How to define a variable
Different types of variables
How to write a for loop
How to display output in an interactive way
How to write output in a different worksheet
How to take user input through a prompt
How to use user input
How to use record macro to know VBA syntax
How to use breakpoint
How to run macro through click of a button
When you need to write do while / do until loop
Syntax of do while / until loop
How to take input from excel sheet for program execution
How to ensure variable names are correct before execution of program
If else command, If elseif else command
Using mod function (for remainder)
Showing status bar
Workout Examples 01 Using Forms for user entry, chart display etc.
See a worked out example of a VBA form
Learn about various control, design aspects of Excel VBA form
Learn about why will need form, and such controls
Hide Data sheet and format other sheet to make it look professional
Ensure proper data type
Ensure value selection from combo box only
Learn to define level, text, combobox and button command
Learn to pass dropdown data in combobox
Learn to use form entry into VBA
Learn to write back on Excel form
Learn how to load form while getting excel started
Learn to change properties of control through VBA
Workout Examples 02 fetching data from MS Access using Excel VBA
How to use Excel as front end and fetch data from microsoft Access database
Where to use this Greatly useful when many users have Excel but don't have MS access database in the PC
Where Reference is needed
Watch window - how to use it
How to edit the code for many fields and different databases
Workout Examples 03 One sheet per product or agent
How to use do while loop to let it run for as many records as it has got
How to find block size (starting and ending row for each product)
How to add sheet using VBA and give it a name
How to ensure that the tool remains intact with multiple runs and even a mistake can't cause issue
How to repeat header in each tab or worksheet
Workout Examples 04 Inventory management, coupon assignment and customer communication using Excel VBA
Traverse through various sheets and workbooks using VBA
Formatting date
Writing derived information from one sheet to another
Passing several parameters to VBA for conditional traversal
3 should mean three coupons to get reserved
[Coupon code : Validity] will need comma if there are multiple vouchers
Error handling : alert, if there are no coupons
Protecting Excel tool for further usage
Workout Examples 05 Reading data from a microsoft access database and writing it into a text file
Reading Microsoft Access data using VBAdirectly writing output into a text fileMaking the output comma separated
Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc.
Workout Example 07 - Insert Excel VBA form data in MS Access database
Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling workWorkout Example 09 - Windows based user authentication and Voice notification of execution of VBA
Who this course is for:
Microsoft Excel users who wants to learn automation and VBA programmingSomeone who wants to learn by seeing workout examples
Instructor Details
- 4.3 Rating
296 Reviews
Gopal Prasad Malakar
I am a seasoned Analytics professional with 18+ years of professional experience. I have industry experience of impactful and actionable analytics, data science, decision strategy and enterprise wise data strategy.
I am a keen trainer, who believes that training is all about making users understand the concepts. If students remain confused after the training, the training is useless. I ensure that after my training, students (or partcipants) are crystal clear on how to use the learning in their business scenarios.
My expertise is in Credit Card Business, Scoring (econometrics based model development), score management, loss forecasting, business intelligence systems like tableau /SAS Visual Analytics, MS access based database application development, Enterprise wide big data framework and streaming analysis.
Please refer to my course for
- SAS / Rprogram details (syntax and options)
- SAS / R output deep dive
- Practical usage in Industrial situation
More courses by Gopal Prasad Malakar
Logistic Regression using SAS - Indepth Predictive Modeling (2019)
4.3 (160 Reviews)
Provider: Udemy
Time: 13.5h
$11.99
Statistics Made Easy by Example for Analytics/ data science (2019)
4.4 (79 Reviews)
- Provider: Udemy
- Time: 10.5h
$11.99
Applied Analytics (business application - non mathematical) (2021)
3.7 (38 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
4h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2016 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
