Automate your work with Excel VBA Macro
Training
Get the tedious Excel tasks done in seconds
Empowers you to do what you normally do in Excel, but a thousand times faster. Automate your routine work – Focus on things that really matters.
FLAT 20% ON THE COURSE FREE
It pays to have friends!
45 Hours
Course Duration (Including Advanced Excel)
Intermediate
For
Pros
Course Delivery
Classroom or
Online
What You Will Learn
Basics of VBA
Programming environment and it's relation with the database
Debugging
Debugging errors in the database and code as well as creating forms
Understanding Variables
Learning about variables, statements, looping, forms and much more
Automating Tasks
Learn to automate routine tasks with the help of VBA
Before You Start
Prerequisites
- This course is for Professionals. Requires you to have working knowledge of Excel.
Course Format
- 45 hrs : Course contains assignments on due dates but You can progress through the course at your own speed.
Course Overview
Target Audience – This course is for Professionals. Requires you to have working knowledge of Excel.
Agenda of the Course – Automate your repetitive task, data processing and report generation activities using VBA and Macros
Practical examples along with some case study are shared with the learner, this helps a person to better visualize how thing will really work in their workplace environment.
Topics Covered
1) VBA Basics
- The Programming Environment
- Object Models
- Navigate With Forms StartUp Forms
- VBA Editor Window
- Project Explorer
- Properties Windows
2) Modules Basics
- View Forms Code
- Standard Code Modules
- Naming Conventions
- VBA Subroutines
- Subroutines
- Functions
- Call Procedures
- Pass Parameters
- Return Values
- Scope Procedures
3) Variables
- Variables Explained
- Data Types Explained
4) Making Decisions
- If Statement Explained
- Single-Line If
- Block If
- Multiple Ifs
- If Statements Assignment
- If For Multiple Text Conditions
- Select Case Statement
- Simple Select Case Statement
5) User Interactions
- Input Boxes Explained
- InputBox Function
- InputBox Function Arguments
- Message Boxes Explained
- Simple Message Box
- Message Box Function
- Navigate With DoCmd
- Move Through Records
- Filter Records With DoCmd
- Open/Close Form With DoCmd
- Open Report With DoCmd
- Create Variable Reports
- Loops Explained
- For Loops
- While Loops
- Counters
- Until Loops
- For…Each Loops
- Exiting From Loops
- For…Next Loops
- Creating Loops Assignment
- Debugging Explained
- Set Breakpoints
- Step Through Procedure
- Add to Combo Boxes
- Value Lists
- Single Selection in ComboBox
- Multiple Columns in ComboBox
- Disable/Enable Controls and Menu Options
- FileDialog Object Members
- Create File Dialog
- Select Single File Only
- File Type Filter
- Select Multiple Files
- Files and Folders
- Create/Delete Folders
- Check for Folder Contents
- Consolidate Create/Delete/Review Routines
- Copy/Move Folder
- Next Steps
- Files
- Add Files
- Write To Text File
- Copy/Move/Delete Files
- Capture User Login/Logout Details
- User Login/LogOut Routines
- Log Form/Report Interaction
- VBA Error Handling
- Error Handling Logic
- Standard Error Handling Routine
- Add Detailed Comments
- Create Database Templates
- ADO
- Connection Object
- Command Object
- RecordSet Object
- Remove References to SET Variables
- Create DAO Recordset
- Using DAO Recordsets
- Bound Forms & SubForms
- Forms RecordSet
- Navigation Elements
- Add/Edit New Records
- Delete Records
Know your Trainer
With nearly a decade of experience in this industry and training over 2000+ working professionals and delivering 100+ Corporate training – Ravi Saini is the founder of TechnoExcel. He’s been working on Microsoft Excel since a really long time as a user, a Developer, and a Trainer.
About TechnoExcel – Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential. We offer Corporate/Personal hands-on training on Data Science, Advanced Excel , Power BI, VBA – Macros and MS – Access. Sourcing only the highest rated trainers from UrbanPro (India’s No 1 Education Platform) we make sure to deliver that ROI you expect and create long-term positive change in your professional journey.’
Have a Question?
Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential.
Connect with Us
Contact
TechnoExcel
connect@technoexcel.in
8801912200
Above Allahabad Bank,
Lal Bahadur Colony,
Trimulgherry, Hyderabad