.png?h=78.11&w=78.11&mode=stretch){kind=logo}
SLA Consultants Delhi: Courses & Fees
Basic & Advanced Excel: Reporting & Dashboard 1 Month Course Online
Fee Structure
Fee Detail
Details
One-Time Fee
₹6,500 + GST
Installment Option
₹7,500 + GST (2 weekly installments)
Course Details Table
Particulars
Details
Course Name
Basic & Advanced Excel: Reporting & Dashboard
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
- Pivot Table, Graphs & Charts, Data Export
- What-If Analysis (Goal Seek, Data Tables)
- Advanced Excel Dashboards
- Dashboard Design Principles
- Interactive Charts with Form Controls (Combo Box, Radio Button)
- Google Sheets
- Collaborative Tools and Data Quality Management
Hands-On Experience
25+ Assignments and 2 Live Projects
Certification
Course Completion Certificate
Job Assistance
Not Included
Admission Mode
Direct Through Center
Demo Class
Demo Class Available
Why Join This Course?
| Fee Detail | Details |
|---|---|
| One-Time Fee | ₹6,500 + GST |
| Installment Option | ₹7,500 + GST (2 weekly installments) |
| Particulars | Details |
|---|---|
| Course Name | Basic & Advanced Excel: Reporting & Dashboard |
| 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 | |
| - Pivot Table, Graphs & Charts, Data Export | |
| - What-If Analysis (Goal Seek, Data Tables) | |
| - Advanced Excel Dashboards | |
| - Dashboard Design Principles | |
| - Interactive Charts with Form Controls (Combo Box, Radio Button) | |
| - Google Sheets | |
| - Collaborative Tools and Data Quality Management | |
| Hands-On Experience | 25+ Assignments and 2 Live Projects |
| Certification | Course Completion Certificate |
| Job Assistance | Not Included |
| Admission Mode | Direct Through Center |
| 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
