Advanced Excel with AI Course in Kolkata
(418) Ratings
(601) Learners
Now with AI: learn advanced formulas, PivotTables, Power Query, dashboards and macros, plus Excel's AI tools and ChatGPT for formulas, summaries and forecasts. Starts with an Excel recap. Classroom course in Baguiati.
7,500+
Trained Students
25+
Years of Excellence
100%
Practical Training
👨🎓 874 learners already enrolled
Mode of Course
offline
Course Duration
2 months
Eligibility
Open to All (Basic Computer Knowledge Preferred)
Certification
Certificate from Tally Institute of Learning, Baguiati (Shashank Skills Academy)
Advanced Excel Course with AI
The Advanced Excel course at Tally Institute of Learning in Baguiati, Kolkata is a 2-month classroom course that now includes Excel with AI. Across 24 classes you refresh the basics, then master lookup and logical functions, PivotTables, Power Query, dashboards and macros, and learn to use Excel's AI tools and ChatGPT to write formulas, summarise data and forecast trends. It ends with a practical MIS dashboard project.
Advanced Excel Course at a Glance
Duration2 months
Classes24 classes, 2 hours each
Schedule3 days a week
Fee₹4,720
ModeClassroom, Baguiati
NewExcel with AI tools and ChatGPT
EligibilityOpen to All (Basic Computer Knowledge Preferred)
You receiveCertificate from Tally Institute of Learning, Baguiati (Shashank Skills Academy)
After the course100% placement assistance
Fee, duration and syllabus last checked: 30 September 2026
Advanced Excel Course Fees in Kolkata
The fee for the Advanced Excel course at our Baguiati centre is ₹4,720 for the full course: 24 classroom classes over 2 months, including the Excel with AI classes, with flexible payment options. Fees are indicative and offers may be running, so call +91 62922 47501 for the exact fee. You can also compare the fees of all our courses.
Now with AI: What You Will Do
Two dedicated classes on using AI inside your everyday Excel work.
Write formulas with AI
Describe what you need in plain words and let Excel's AI tools or ChatGPT draft the formula, then check it.
Summarise data and reports
Turn large sheets into short summaries and reports with AI help.
Forecast trends
Use AI-assisted forecasting and trend analysis on sales or expense data.
Build dashboards faster
Create MIS dashboards with AI suggestions for layout and charts.
What You Will Be Able to Do
- Use VLOOKUP, HLOOKUP and INDEX + MATCH to pull data across sheets
- Apply SUMIFS, COUNTIFS, IFS and text, date and financial functions to real accounts data
- Clean and combine data with Power Query and analyse it with PivotTables
- Build MIS dashboards with charts, slicers and timelines
- Automate repeated tasks with recorded macros
- Use AI tools and ChatGPT to speed up formulas, summaries and forecasts
Who This Course Is For
Students and job seekers
Advanced Excel is one of the skills employers ask about most in accounts and office interviews.
Accounts and MIS staff
Cut hours of manual reporting with lookups, PivotTables and macros.
Office professionals
Work faster with data using Excel's newest AI features.
Business owners
Track sales, stock and expenses in dashboards you build yourself.
Basic computer knowledge is preferred. The course opens with 4 recap classes, so it is fine if your Excel is rusty. If you have never used a computer, start with our MS Office course.
Full Syllabus: 24 Classes
Tap any part to see every class.
1
Excel Recap 4 classes
A quick refresher on the Excel basics many students forget, so everyone starts the advanced part on the same footing.
See all 4 classes
- Excel screen, workbooks and worksheets; entering data and writing formulas
- Cell formatting, rows and columns, and relative and absolute cell references
- Sorting, filters and basic functions (SUM, AVERAGE, COUNT, MIN, MAX, IF)
- Charts and printing
2
Advanced Excel and MIS Reporting 16 classes
Lookup, logical, text, date, financial and database functions, what-if analysis, Power Query, PivotTables, dashboards and macros.
See all 16 classes
- Excel Features, Cell referencing, Name ranges, Rearranging data, Cut, Copy, Paste Special, AutoFill, Transpose
- Subtotals, Protection of cell, sheet, workbook, Excel file
- Compute and analyze data with: SUMIF, SUMPRODUCT, COUNTA, COUNTBLANK, COUNT, COUNTIF, IF, AND, OR
- Information functions: CONCAT, TEXTJOIN, MAXIFS, MINIFS, IFS, COUNTIFS, SUMIFS
- Numeric functions: CELL, ABS, CODE, MAX, MIN, FIXED, FLOOR, ROUND, MOD, ODD, EVEN, POWER, SIGN, PI
- String functions: CHAR, UPPER, LOWER, LEFT, LEN, MID, RIGHT, Logical functions: ISBLANK, ISERROR, ISLOGICAL, ISNUMBER, ISTEXT
- Database functions: DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DGET
- LOOKUP, VLOOKUP, HLOOKUP, VLOOKUP & HLOOKUP with SUM, INDEX, MATCH, INDEX + MATCH
- DATEVALUE, WEEKDAY, DATEDIF, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, WORKDAY, YEAR
- Financial functions: PMT, PV, FV, NPER, IPMT, PPMT, RATE, NPV, IRR, Statistical: STDEV, MODE
- Goal Seek, Scenario, Solver, Forecast Sheet, Import data from Access, Text, Web, Others, existing connection
- Advanced filtering, Sorting data, Custom sorting, Summarizing data, Grouping. Data validation, Sparklines
- Utility of Excel Table, Reporting hierarchical data, New Query, Power Query function, Query Editor, Power Map
- PivotTable, Editing the PivotTable, Advance PivotTable, Summarizing, PivotTable from existing connections
- Charts and graphs, Slicer, Timeline, Forecasting, Dashboard management, Donut chart, Progress chart
- Introduction to Macro, Recording, understanding code behind, Adding other add-ins, Macro with buttons
3
Excel with AI 2 classes
Use Excel's built-in AI tools and ChatGPT to write formulas, summarise data, forecast trends and build dashboards faster.
See all 2 classes
- Excel AI tools (built-in), Formula writing with ChatGPT
- Data summary & reports with AI, Forecasting & trend analysis with AI, Dashboard creation with AI help
4
Project and Revision 2 classes
Build a practical MIS dashboard, then revise and clear doubts.
See all 2 classes
- Practical MIS dashboard project
- Revision, quiz and doubt clearing
This syllabus is indicative and may be updated to reflect new Excel and AI features and industry practice.
Advanced Excel, Power BI or MS Office
Advanced Excel with AI (this course)
2 months. Functions, PivotTables, Power Query, dashboards, macros and AI tools inside Excel.
Microsoft Power BI
2 months. The next step after Excel: interactive dashboards, data models and DAX.
MS Office
3 months, for complete beginners: Windows, Word, Excel basics, PowerPoint and email.
Why Learn Advanced Excel at Tally Institute of Learning
Since 2001
teaching computer and accounts skills in Baguiati
7,500+
students trained at our Baguiati centre
4.8 on Google
from 87 reviews (September 2026)
16 trainers
including the four below
Aveek Banerjee
Tally Certified Trainer, 15+ years of teaching and industry experience
Sumanta Bhowmick
Tally Certified Trainer, 10+ years of teaching and industry experience
Debojyoti Paul
Tally Certified Trainer, 10+ years of teaching and industry experience
Sourav Basu Mallick
Power BI Trainer, 18 years of teaching and industry experience
Where Advanced Excel Can Take You
Advanced Excel is used every day in roles such as MIS Executive, Accounts Executive, Data Entry and Reporting Executive, and Office Administrator. Our placement cell supports you with 100% placement assistance, resume support and interview preparation, and our students have been placed at companies including TCS, Capgemini, Apollo Hospitals, Kolmak Chemicals and TC Motors (Tata Motors). See the full list on our recently placed students page.
Syllabus and course details reviewed by Sandeep Bajoria, Co-Founder & Academic Director, Shashank Skills Academy (Tally Institute of Learning, Baguiati). Last reviewed: 30 September 2026.
Related Courses
Microsoft Power BI course
MS Office course
TallyEssential course
Diploma (DCFA)
Compare all course fees
Fees shown are indicative. Offers may be running, so call us for the exact fee, batch timings and payment options, or visit our Baguiati centre.
Quality
Curriculum
Placement
The fee is Rs. 4,720 (September 2026) for the full 2-month classroom course of 24 classes, with flexible payment options. Fees are indicative and offers may be running, so call +91 62922 47501 for the exact fee.
Yes. Two classes cover Excel's built-in AI tools and ChatGPT: writing formulas, summarising data and reports, forecasting trends and building dashboards with AI help.
The course runs for 2 months: 24 classes of 2 hours each, 3 days a week, in a classroom at our Baguiati centre in Kolkata.
Yes. The course starts with 4 recap classes on Excel basics, so everyone begins the advanced part on the same footing. Basic computer knowledge is preferred.
VLOOKUP, HLOOKUP and INDEX + MATCH, SUMIFS, COUNTIFS and IFS, text, date, financial and database functions, what-if analysis, Power Query, PivotTables, dashboards, macros and Excel with AI, ending with a practical MIS dashboard project.
You receive a certificate from Tally Institute of Learning, Baguiati (Shashank Skills Academy) when you complete the course.
Learn Advanced Excel first. Power BI builds on Excel skills, and many students take our Power BI course after Advanced Excel.
Advanced Excel is used in roles such as MIS Executive, Accounts Executive, Data Entry and Reporting Executive and Office Administrator. Our placement cell gives 100% placement assistance.
All the advanced excel topics were well explained.
MS
Manish Singh
Advance Excel
I am a student of this centre. it gives one of the best guidance for job guarantee course, accounting job tally prime and also advance excel related jobs. The faculty out here is very friendly, knowledgeable and easy to approach and help in every step throughout the course.
SN
Silpa Naskar
Accounting Job - Tally Prime + Advanced Excel
BAGUIATI CENTRE
Ready to Master Advanced Excel?
7,500+ students have trained at our Baguiati centre. Talk to a counsellor about the next batch and fee options.
Want to get discount for your course from us? Leave your email and sign up for our newsletter to avail special offer on course fees.