.png?h=78.11&w=78.11&mode=stretch){kind=logo}
SLA Consultants Delhi: Courses & Fees
VBA/Macros or SQL with MS Access: Automation in Excel 1 Month Course Online
Fee Structure
Fee Detail
Details
One-Time Fee
₹8,500
Installment Option
₹10,500 (2 Weekly Installments)
Course Details Table
Particulars
Details
Course Name
VBA/Macros or SQL with MS Access: Automation in Excel
Duration
1 Month
Training Approach
80% Practical, 20% Theoretical
Core Topics Covered
- Data Analysis in Basic & Advanced Excel
- Mathematical Functions (SUM, COUNT, AVERAGE, etc.)
- Date & Time Functions (TODAY, NETWORKDAYS, etc.)
- Text Functions (LEN, CONCATENATE, SUBSTITUTE, etc.)
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, etc.)
- Data Collection & Management
- Filters, Sorting, Conditional Formatting
- Data Validation, Splitting, Grouping
- Pivot Tables and Visualization
- VBA Basics to Advanced: Loops, Arrays, User Forms, Debugging
- Integrations with MS Word, PowerPoint, Outlook, and Access
- SQL Fundamentals: SELECT, INSERT, JOINS, Triggers, Backup Management
- Interactive Dashboards with Form Controls (Combo Box, Radio Button)
Hands-On Experience
25+ Assignments and 2 Live Projects
Certification
Course Completion Certificate
Job Assistance
Not Included
Admission Mode
Direct Through Center
Training Mode
Online
Demo Class
Demo Class Available
Why Join This Course?
| Fee Detail | Details |
|---|---|
| One-Time Fee | ₹8,500 |
| Installment Option | ₹10,500 (2 Weekly Installments) |
| Particulars | Details |
|---|---|
| Course Name | VBA/Macros or SQL with MS Access: Automation in Excel |
| Duration | 1 Month |
| Training Approach | 80% Practical, 20% Theoretical |
| Core Topics Covered | - Data Analysis in Basic & Advanced Excel |
| - Mathematical Functions (SUM, COUNT, AVERAGE, etc.) | |
| - Date & Time Functions (TODAY, NETWORKDAYS, etc.) | |
| - Text Functions (LEN, CONCATENATE, SUBSTITUTE, etc.) | |
| - Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, etc.) | |
| - Data Collection & Management | |
| - Filters, Sorting, Conditional Formatting | |
| - Data Validation, Splitting, Grouping | |
| - Pivot Tables and Visualization | |
| - VBA Basics to Advanced: Loops, Arrays, User Forms, Debugging | |
| - Integrations with MS Word, PowerPoint, Outlook, and Access | |
| - SQL Fundamentals: SELECT, INSERT, JOINS, Triggers, Backup Management | |
| - Interactive Dashboards with Form Controls (Combo Box, Radio Button) | |
| Hands-On Experience | 25+ Assignments and 2 Live Projects |
| Certification | Course Completion Certificate |
| Job Assistance | Not Included |
| Admission Mode | Direct Through Center |
| Training Mode | Online |
| Demo Class | Demo Class Available |
Practical Exposure: Acquire practical working knowledge under the expert guidance of industry professionals. The course would be provided by professionals; it imparts practical insight into even apparently complex issues.
Convenient Sunday lessons: Because the course is directed to working professionals or persons with tight schedules, lessons are held only on Sundays for flexibility and the capability of managing other commitments.
Detailed Course: The course is detailed, starting from basics to advanced. It is specially meant for those who want to enhance their accounting and tax capabilities.
Practical Case Studies: The course includes practical, hands-on case studies that would help bridge the gap between academics and industry applications.
Certification: Industry-recognized certification is waiting, which would hold immense value on your resume, hence making you somewhat different in the job market.
Facilities provided by the study room: The study room provides them a place to practice studies and revision since the library is off.
.
.jfif?h=48&w=48&mode=stretch){kind=logo}
.jfif?h=48&w=48&mode=stretch){kind=logo}
.png?h=48&w=48&mode=stretch){kind=logo}
SUBSCRIBE TO OUR NEWS LETTER
