Advanced Excel Course
Advanced Excel Course - 1 month. VLOOKUP, Pivot Tables, Macros, MIS Reports, Dashboards. Best Excel training in India. ₹1249 only.
Course Description
Program Modules
M1: Excel Fundamentals Refresher
Excel Interface, Formatting, Basic Formulas, Cell Referencing, Named Ranges, Data Entry Tips
M2: Advanced Formulas & Functions
VLOOKUP, HLOOKUP, INDEX-MATCH, IF, Nested IF, AND, OR, SUMIF, COUNTIF, AVERAGEIF, Text Functions, Date Functions
M3: Data Tools & Analysis
Pivot Tables, Pivot Charts, Sorting, Filtering, Data Validation, Conditional Formatting, What-If Analysis, Goal Seek
M4: Charts, Dashboards & Final Project
Chart Creation, Chart Types, Dashboard Design, KPI Tracking, Final Practical Project, Viva
Key Features
What You'll Learn
Examination Details
| Exam Name | Full Marks | Pass Marks |
|---|---|---|
| Excel Fundamentals | 100 | 40 |
| Formulas & Functions | 100 | 40 |
| Pivot Tables | 100 | 40 |
| Data Validation & Filtering | 100 | 40 |
| Charts & Dashboards | 100 | 40 |
| Final Project & Viva | 100 | 40 |
Course Information
Prerequisites
- Basic Excel knowledge
- 10+2 or above education
Who Can Enroll ?
- Accountants
- MIS executives
- Data analysts
- Finance professionals
- Job seekers in banking/finance
Certificate Preview
Related Courses
You might also be interested in these
CCC - Course on Computer Concepts
NIELIT CCC Computer Course - 3 months government recogn...
DCA - Diploma in Computer Application
DCA Diploma in Computer Application - 6 months professi...
ADCA - Advanced Diploma in Computer Application
ADCA Advanced Diploma Computer Application - 1 year com...
Our Students Did It!
Real stories, real success. See how NextVision Infotech helped our students build their careers.
Karan Bahadur Thapa
Internship Program
"Best decision I ever made! The teaching quality and practical training helped me land my dream job. Highly recommended! 🌟"
Diptangshu De
Internship Program
"Amazing experience! The mentors are super supportive and the course content is industry-ready. Got my certificate with confidence! 💯"
Ansh Verma
Internship Program
"NVI Gaya changed my career path completely. Practical projects, real-world skills, and expert guidance — everything was perfect! 🚀"
Rishu kumari
Internship Program
"Learned so much in such a short time. The internship gave me real experience and confidence to face interviews. Thank you NVI! 🙏"
Rishabh malviya
Internship Program
"Best decision I ever made! The teaching quality and practical training helped me land my dream job. Highly recommended! 🌟"
Kishan Shukla
Internship Program
"Amazing experience! The mentors are super supportive and the course content is industry-ready. Got my certificate with confidence! 💯"
Saquib kausar
Internship Program
"NVI Gaya changed my career path completely. Practical projects, real-world skills, and expert guidance — everything was perfect! 🚀"
Abhijay Mishra
Internship Program
"Learned so much in such a short time. The internship gave me real experience and confidence to face interviews. Thank you NVI! 🙏"
Ankush Kumar
Course Program
"Best decision I ever made! The teaching quality and practical training helped me land my dream job. Highly recommended! 🌟"
Ravi Raj kumar
Internship Program
"Amazing experience! The mentors are super supportive and the course content is industry-ready. Got my certificate with confidence! 💯"
Our Certificate Samples
Internship Certificate
Tap to view
Joining Letter
Tap to view
Student ID Card
Tap to view
Student Panel
Tap to view
All certificates are issued by NextVision Infotech & are verifiable upon request.
Ready to Start Your Journey?
Join NVI Gaya and take the first step towards a successful IT career
