Pallavi Sonkamble Completed Advanced Microsoft Excel at ABC Trainings Hadapsar - June 2025 (Updated October 2026)
Pallavi Sonkamble completed the Proficient in Advanced Microsoft Excel course at ABC Trainings, Hadapsar, Pune in June 2025, under the guidance of Mr. Shendge. The 60-hour programme spans 25 sessions — from Excel navigation and basic formulas to Pivot Tables, VLOOKUP, macros, and Solver.
- Pallavi Sonkamble completed the Proficient in Advanced Microsoft Excel course at ABC Trainings, Hadapsar, Pune in June 2025.
- The 60-hour, 25-session programme covers Pivot Tables, VLOOKUP, HLOOKUP, macros, Solver, and a full range of statistical and logical functions.
- Designed for BBA, B.Com, M.Com, and MBA Finance or Banking students. Course fee: ₹8,500.
What the 25-Session Advanced Excel Syllabus Covers
The course spans 25 sessions over 60 hours. Sessions 1–8 build the foundations: screen navigation and spreadsheet concepts, selection techniques, data entry, basic formulas and calculations, customising Excel options, absolute and relative cell referencing, worksheet and workbook protection, and shortcut keys. Sessions 9–11 introduce working with functions and formulas, modifying worksheets with colour, and conditional formatting with IF logic and charts. Session 12 covers Pivot Tables, Sort & Filter, Data Tools, Subtotal, and What-If Analysis together. Sessions 13–14 address formula auditing, named ranges, workbook protection, macro recording, and freeze panes. Sessions 15–17 cover the Text, Statistical, Math & Trig, Date & Time, Logical, and Financial function families. Sessions 18–20 advance Pivot Table work into Pivot Charts and introduce HLOOKUP, VLOOKUP, and IFERROR. Sessions 21–25 cover advanced filters with wildcard characters, advanced macros and page printing, advanced conditional formatting, Paste Special, Solver, advanced subtotals, and the complete Logical and Lookup function library.
Pallavi Sonkamble in Her Own Words
“This course has truly enhanced my Excel skills. I appreciate the way you explain complex functions with real-life examples.”
— Pallavi Sonkamble, Advanced Microsoft Excel, ABC Trainings Hadapsar, June 2025
About the Trainer at ABC Trainings Hadapsar
Mr. Shendge is an IT trainer at ABC Trainings, Hadapsar, Pune. His subject expertise covers C, C++, Core Java, Advanced Java, Python, Full Stack Development, CCNA, Ethical Hacking, Network Security, Data Science using Python, Cloud Computing, Tally ERP 9, and Web Designing.
Learn Advanced Microsoft Excel in Hadapsar, Pune
ABC Trainings Hadapsar offers the Proficient in Advanced Microsoft Excel course in English and Hindi across 60 hours of classroom instruction. The programme is designed for BBA, B.Com, M.Com, and MBA Finance or Banking students. Course fee: ₹8,500. Read more student stories from ABC Trainings.
Get the student-story Brochure + Fees + Batch Dates on WhatsApp
Free 1:1 counselling. Placement track record. CMYKPY/PMKVY eligibility check.
💬 Get Brochure on WhatsApp📞 Call 7039169629About the author: ABC Trainings Faculty.
Visit Our Centers
- Wagholi (Pune): 1st Floor, Laxmi Datta Arcade, Pune-Ahilyanagar Highway. Call 7039169629
- Hadapsar (Pune HQ): 1st Floor, Shree Tower, opp. Vaibhav Theater, Magarpatta. Call 7039169629
- Cidco (Chh. Sambhajinagar): Kalpana Plaza, opp. Eiffel Tower, N-1 Cidco. Call 7039169629
- Osmanpura (Chh. Sambhajinagar): S.S.C Board to Peer Bazar Road, near Jama Masjid. Call 7039169629
- Sangli: Shubham Emphoria, 1st Floor, Above US Polo Assn., Sangli-Miraj Rd, Vishrambag. Weekend batches available. Call 7039169629
FAQs
How long is the Advanced Microsoft Excel course at ABC Trainings Hadapsar?
The course is 60 hours, delivered across 25 sessions. Topics range from Excel basics and formula writing through Pivot Tables, macros, VLOOKUP, Solver, and advanced Logical functions.
Is the course suitable for B.Com and MBA Finance students in Pune?
Yes. The course is designed for BBA, B.Com, M.Com, and MBA Finance or Banking students. It builds the spreadsheet, data analysis, and financial modelling skills that commerce and finance employers expect.
What topics does the Advanced Excel course at ABC Trainings cover?
The 25-session syllabus covers screen navigation, data entry, basic and advanced formulas, absolute and relative cell references, Pivot Tables, Sort & Filter, conditional formatting, HLOOKUP, VLOOKUP, IFERROR, macros, Solver, What-If Analysis, advanced filters, and the full Text, Statistical, Math, Date & Time, Logical, and Financial function libraries.
Where is ABC Trainings Hadapsar located?
ABC Trainings Hadapsar is at 1st Floor, Shree Tower, opp. Vaibhav Theater, Magarpatta, Pune 411028. Call +91 7039169629 or WhatsApp 7774002496 for batch dates and enrolment details.