phone +91 62922 47501

email info@shashankskills.academy

Advanced Excel Course in Kolkata

Short-term course · Baguiati, Kolkata

Shashank Skills Academy teaches Advanced Excel at its Baguiati centre in Kolkata, and online. There are two tracks: ₹4,720 for 18 classes if you already know basic Excel, and ₹5,900 for 30 classes if you are starting from scratch. Classes run Monday to Saturday between 9 am and 9 pm, two hours each, three days a week, with weekend batches for working professionals.

It suits college students and working professionals who want to analyse data, build reports and dashboards, and automate repeat work. For where these skills lead, read our Excel career guide, or browse our other short-term computer courses.

  • Baguiati classroom
  • Online option
  • Mon to Sat, 9 am to 9 pm
  • Joint certificate
Advanced Excel classes at Shashank Skills Academy, Baguiati

Fees, duration and batches

Two tracks, one pace. Pick the advanced track if you already know basic Excel, or the A to Z track if you are starting from scratch.

For learners who know basic Excel

Advanced track

₹4,720

for 18 classes

18classes
6weeks
36hours

Best for: people who already handle the Excel screen, formatting, simple formulas, sorting and basic charts.

Enquire about this track
Beginner-friendly

A to Z track

₹5,900

for 30 classes, basic plus advanced

30classes
10weeks
60hours

Best for: beginners. It adds 12 classes to the advanced track: nine basics classes, advanced macros with VBA, practical assignment papers, and a quiz with doubt clearing.

Enquire about this track
Monday to Saturday Batches between 9 am and 9 pm. Weekend batches for working professionals.
3 days a week Each class is 2 hours.
Classroom or online Attend at our Baguiati centre or take the classes online.
Joint certificate Issued by Shashank Skills Academy and Tally Institute of Learning.

Fees and batch details last updated: 28 October 2026

Read the full breakdown: Advanced Excel Course in Baguiati: Fees, Classes and Who Each Track Suits

Your questions answered

Fees, timings, certificate and what to expect, in plain answers.

How much does the Advanced Excel course cost in Kolkata?

At Shashank Skills Academy in Baguiati, the advanced track costs ₹4,720 for 18 classes and is meant for people who already know basic Excel. The A to Z track costs ₹5,900 for 30 classes and is meant for beginners.

How long is the course and how many classes are there?

The advanced track has 18 classes. At three classes a week, two hours each, it takes 6 weeks and 36 hours. The A to Z track has 30 classes, which is 10 weeks and 60 hours at the same pace.

What is the difference between the ₹4,720 and ₹5,900 tracks?

Both include the same 18 advanced classes. The ₹5,900 A to Z track adds 12 more: nine basics classes at the start, advanced macros with VBA, a class of practical assignment papers, and a closing quiz and doubt-clearing session.

Which track should I choose if I am a beginner?

Choose the A to Z track at ₹5,900 if you are new to Excel. The advanced track assumes you are already comfortable with the Excel screen, cell formatting, simple formulas, sorting and basic charts, which are what the nine basics classes in the A to Z track teach. If you already work with those, take the advanced track.

What will I learn?

You learn conditional and lookup functions such as SUMIFS, COUNTIFS, VLOOKUP and INDEX + MATCH, then Goal Seek and Solver, Power Query, PivotTables, dashboards with slicers and timelines, and macros. The last two advanced classes cover the built-in Excel AI tools and writing formulas with ChatGPT. The full class-by-class list is in the course outline.

Can I attend in the classroom or online?

Both options are available. You can attend at our Baguiati centre or take the classes online.

Where is the classroom?

Our centre is at H/H-7, Aswininagar, VIP Road, Baguiati, on 44 Bus Stand, Kolkata 700159.

What are the batch timings?

Classes run from Monday to Saturday, between 9 am and 9 pm. Each class is 2 hours and you attend 3 days a week. Weekend batches are available for working professionals.

Will I get a certificate?

Yes. Shashank Skills Academy and Tally Institute of Learning jointly issue the certificate.

Is placement or job help included?

No. This is a short-term course, so we do not offer or promise placement. The course is built to teach the skills, and you receive the certificate on completion.

How do I enrol or ask about a batch?

Send a message using the enquiry form on this page, call +91 62922 47501, or book a free 1-on-1 counselling session.

What you will learn

Six skill areas, built from the class-by-class outline below.

Formulas and functions

Conditional and lookup formulas such as SUMIFS, COUNTIFS, VLOOKUP and INDEX + MATCH, plus text, numeric, database, date and time, financial and statistical functions.

What-if and data tools

Goal Seek, Scenario, Solver and Forecast Sheet, plus advanced filtering, custom sorting, data validation and sparklines.

Power Query and PivotTables

Excel Tables, Power Query and the Query Editor, PivotTables and PivotTables built from existing connections.

Charts and dashboards

Charts, slicers, timelines, forecasting, donut and progress charts, and dashboard management.

Macros and automation

Record macros, read the code behind them and add buttons. The A to Z track goes further with advanced macros using VBA.

Excel AI tools

Built-in AI tools, writing formulas with ChatGPT, data summaries and reports with AI, trend analysis, and dashboards with AI help.

Why learn Excel at Shashank Skills Academy

Hands-on classes taught by working trainers.

We provide 100% Practical Training

Students will be presented with interesting real-life scenarios and have to use the Excel tools, functions, and data visualization techniques learned to solve problems, make inferences, and present data in a meaningful and effective manner using Excel. At Shashank Skills Academy, we believe in the power of hands-on learning. We want our learners to be able to "do the thing" instead of just passing an exam.

Expert Trainers

Our team of experienced and qualified trainers have a wide range of specialist industry experience giving our students the added benefit of their knowledge, so you can be confident that your training is providing all the skills needed for success in your chosen career path.

Course Outline

Class-by-class topics for both tracks.

  1. 1Excel features, cell referencing, named ranges, rearranging data, cut, copy, Paste Special, AutoFill, Transpose
  2. 2Subtotals; protection of cell, sheet, workbook and Excel file
  3. 3Compute and analyse data with SUMIF, SUMPRODUCT, COUNTA, COUNTBLANK, COUNT, COUNTIF, IF, AND, OR
  4. 4Information functions: CONCAT, TEXTJOIN, MAXIFS, MINIFS, IFS, COUNTIFS, SUMIFS
  5. 5Numeric functions: CELL, ABS, CODE, MAX, MIN, FIXED, FLOOR, ROUND, MOD, ODD, EVEN, POWER, SIGN, PI
  6. 6String functions (CHAR, UPPER, LOWER, LEFT, LEN, MID, RIGHT) and logical functions (ISBLANK, ISERROR, ISLOGICAL, ISNUMBER, ISTEXT)
  7. 7Database functions: DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DGET
  8. 8LOOKUP, VLOOKUP, HLOOKUP, VLOOKUP and HLOOKUP with SUM, INDEX, MATCH, INDEX + MATCH
  9. 9Date and time functions: DATEVALUE, WEEKDAY, DATEDIF, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, WORKDAY, YEAR
  10. 10Financial functions (PMT, PV, FV, NPER, IPMT, PPMT, RATE, NPV, IRR) and statistical functions (STDEV, MODE)
  11. 11Goal Seek, Scenario, Solver, Forecast Sheet; importing data from Access, text, web and other sources, and existing connections
  12. 12Advanced filtering, sorting and custom sorting, summarising data, grouping, data validation, sparklines
  13. 13Excel Tables, reporting hierarchical data, New Query, Power Query functions, Query Editor, Power Map (now called 3D Maps)
  14. 14PivotTables: creating, editing, advanced PivotTables, summarising, PivotTables from existing connections
  15. 15Charts and graphs, Slicer, Timeline, forecasting, dashboard management, donut chart, progress chart
  16. 16Introduction to macros: recording, reading the code behind a macro, add-ins, macros with buttons
  17. 17Excel built-in AI tools and formula writing with ChatGPT
  18. 18Data summaries and reports with AI, forecasting and trend analysis with AI, building a dashboard with AI help

The A to Z track contains all 18 advanced classes above, plus these 12. The advanced classes run as Classes 10 to 25, 27 and 28.

  1. 1Excel screen components: title bar, ribbon, tabs, Backstage, formula bar
  2. 2Formulas and worksheet management
  3. 3Rows, columns and file management
  4. 4Cell formatting
  5. 5Comments and practice
  6. 6Cell references and sorting
  7. 7Excel functions
  8. 8Charts and graphics
  9. 9Data query and analysis tools
  10. 26Advanced macros using VBA code
  11. 29Solving practical assignment papers
  12. 30Quiz and doubt-clearing session

Send a message

Tell us which track you are considering.

Query on : Advance Excel

Industry-Experienced Instructors

Our instructors undergo regular re-skill and upskill training to remain updated with the latest trends in technologies to deliver updated training to our students.

Industry Oriented Curriculum

We provide Industry-oriented course modules aimed to provide optimal learning experience and produce skilled, industry-ready and employable students.

100% JOB ASSISTANCE

We offer 100% Placement Assistance - so you'll be able to start your career once you complete the course. You'll also access to our lifelong Placement support.