💻 Computer Course
🔥 Popular
Advanced Excel Course
Advanced Excel Course in Patna Bihar - 1 month. VLOOKUP, Pivot Tables, Macros, MIS Reports. Best Excel training in Bihar. ₹2499. Job ready skills.
Duration: 1 Month
Level: Intermediate
Code: AEXL-101
Course Description
Advanced Excel Course at NextVision Infotech Patna covers VLOOKUP, Macros, Pivot Tables, MIS Reports, and Data Analysis. 1-month intensive course for professionals and students in Bihar. Best Excel training in Patna with hands-on projects and placement support.
Program Modules
1
M1: Excel Formulas
IF, SUMIF, COUNTIF, VLOOKUP, HLOOKUP, INDEX-MATCH
2
M2: Data Management
Sorting, filtering, data validation, conditional formatting
3
M3: Pivot Tables
Creating and analyzing pivot tables, pivot charts
4
M4: Charts & Graphs
Bar, pie, line charts, sparklines, dashboards
5
M5: Macros & VBA
Recording macros, basic VBA coding
6
M6: MIS Reports
Business reports, templates, automation
Key Features
VLOOKUP & HLOOKUP
Pivot Tables & Charts
Excel Macros & VBA Basics
MIS Report Creation
Data Analysis
Dashboard Creation
Interview Preparation
ISO 9001:2015 Certified
What You'll Learn
Create complex Excel formulas
Build MIS dashboards
Automate tasks with macros
Analyze data with pivot tables
Present data visually with charts
Examination Details
| Exam Name | Full Marks | Pass Marks |
|---|---|---|
| Practical Project | 100 | 50 |
Course Information
Duration:
1 Month
Level:
Intermediate
Available Seats:
50
Course Code:
AEXL-101
Prerequisites
- Basic Excel knowledge
- 10+2 or above education
Target Audience
- Accountants
- MIS executives
- Data analysts
- Finance professionals
- Job seekers in banking/finance
Certificate Preview
Related Courses
You might also be interested in these courses
💻 Course
MS Office Course
MS Office Course in Patna Bihar - 1 month. Word, Excel, Powe...
₹1,999
View Details
Ready to Start Your Journey?
Join NVI Gaya and take the first step towards a successful IT career