The offer price is Rs. 2,950 (September 2026), down from the course fee of Rs. 5,900. It is a one-time payment that covers 1-year portal access, 8 live one-to-one sessions with our trainer and the Tally Education certificate.
Microsoft Excel - Beginner to Advanced Online Course
(413) Ratings
(659) Learners
Learn Microsoft Excel online at your own pace, from the basics to lookups, PivotTables, dashboards, macros, VBA and Excel with ChatGPT. Includes 1-year access, 8 live one-to-one sessions with our trainer and a certificate from Tally Education.
7,500+
Trained Students
25+
Years of Excellence
100%
Practical Training
👨🎓 789 learners already enrolled
Mode of Course
online
Course Duration
8 hrs
Course Fee
₹5900
Offer Price
₹2950
Eligibility
Open to All (Basic Computer Knowledge Preferred)
Microsoft Excel Online Course: Beginner to Advanced
Learn Microsoft Excel online, at your own pace, from your first spreadsheet to formulas, lookups, PivotTables, charts, macros and VBA, dashboards and Excel with ChatGPT and AI tools. This is Tally Education's online Excel course with 1-year portal access. On top of it, you get 8 live one-to-one sessions with our trainer, and you finish with a certificate from Tally Education.
₹5,900 ₹2,950
Offer price
- Tally Education's online Microsoft Excel course: 20 modules, beginner to advanced
- Video lessons, practice files and step-by-step guides
- 1-year access to the learning portal
- 8 live one-to-one sessions with our trainer
- Certificate from Tally Education when you complete the course, with no exam
Fee and inclusions last checked: 30 September 2026
Microsoft Excel Online at a Glance
Study time8 hrs
Access1 year
Live support8 one-to-one sessions, 45 min, weekly
ModeOnline, self-paced
Syllabus20 modules
Fee₹2,950
EligibilityOpen to All (Basic Computer Knowledge Preferred)
You receiveCertificate from Tally Education on completion (no exam)
Your 8 Live One-to-One Sessions
- One 45-minute session a week for 8 weeks, just you and the trainer
- Each session follows the modules you are studying, so you can clear doubts as you go
- A missed session can be rescheduled
How It Works
Your learning journey
-
1
Enroll online
Click Buy Now and pay securely online through Razorpay.
-
2
Complete your registration
Fill in the short student details form that opens right after payment.
-
3
Get your LMS login
Our team sets up your account on the learning portal and shares your login details with you.
-
4
Learn at your own pace
Study Microsoft Excel - Beginner to Advanced through video lessons, practice files and quizzes, and join live doubt-clearing sessions when you get stuck.
-
5
Take the final assessment
Sit the online assessment at the end of the course.
-
6
Get certified
Receive your Tally Education certificate, which employers can verify online.
What You Will Learn: 20 Modules
Tap a module to see its topics.
1
Start-Up
5 topics
- How to open MS Excel
- Start screen – navigating MS Excel
- User interface – navigating MS Excel
- Home tab basic editing tools
- Copy and paste – using multiple tools in MS Excel
2
Basic Tools to Know
6 topics
- Customize ribbon bar – tabs, groups, commands – tools
- Text to column – multiple methods
- Speak cells – data reading tool
- Comments – add, edit, delete and customize
- Filters in MS Excel
- Freeze panes and split screen
3
Fill Series and Data, Sheet Controls
10 topics
- Fill series – basics
- Fill series – advanced
- Fill series – flash fill
- Conditional formatting
- Hyperlinks to sheets, webpages, files
- Header and footer settings
- Printing and paper settings
- Import data from web
- Import data from text document with auto refresh
- Import-text word ppt jpeg video- pdf & more objects
4
Working with Sheets
9 topics
- Characteristics of a cell
- Cell references – relative ref, absolute ref, mixed ref
- Custom view
- Sheet protection
- Cell protection
- Compare sheets side by side – view sheets side by side
- Compare sheets from multiple files
- Working with cells, rows, columns, specific size, auto fit
- Working with sheets rename, colour, copy, move, grouping
5
Sum-Related Formulas
11 topics
- Things to Remember Before Starting Formulas
- SUM
- SUMIF
- SUMIFS
- SUBTOTAL
- AGGREGATE
- SUMPRODUCT
- SUMSQ
- SUMX2MY2, SUMX2PY2, SUMXMY2 – Mathematics and Trigonometry
- DSUM – Database Sum
- IMSUM vs IMSUB – Complex Data Calculations
6
Average-Related Formulas
4 topics
- Average
- AVERAGEA
- AVERAGEIF vs AVERAGEIFS
- Weighted average with VBA code
7
Count-Related Formulas
2 topics
- COUNT, COUNTA, COUNTBLANK
- COUNTIF vs COUNTIFS
8
Logical IF-Related Formulas
6 topics
- Logical test with comparative operators
- If
- If and vs if or
- IFS vs NESTEDIF
- IFERROR
- Switch
9
Text Extraction and Manipulation
3 topics
- LEFT, RIGHT, MID, and LEN
- Find vs search
- Replace vs substitute
10
Text Formatting and Conversion
6 topics
- CONCAT vs CONCATENATE
- Text
- Upper, lower, proper
- Trim
- SPELLNUMBER with VBA Code
- Text-to-number with VBA code
11
Date & Time-Related Formulas
6 topics
- Using TODAY, NOW
- DATE, DATEVALUE, TIME, TIMEVALUE
- DATEDIF and Extracting Years, Months, Days, Hours, Minutes, Seconds
- Calculating Future and Past Dates – EDATE, EOMONTH, WORKDAY, NETWORKDAYS
- Calculate days using – DAY, DAYS, NETWORKDAYS
- Calculate hours and hourly charges
12
Finance-Related Formulas
3 topics
- PMT – EMI Calculator
- PPMT, IPMT – Loan Statement Preparation
- FV – Investment Calculator
13
Data Search & Lookup-Related Formulas
8 topics
- VLOOKUP – Basics, Rules, Exact Match, Approx. Match
- HLOOKUP – Basics
- XLOOKUP Function – With VBA Code
- MATCH function vs INDEX function
- VLOOKUP Advanced 1 – Applying across multiple cells at a time
- VLOOKUP Advanced 2 – Applying across multiple sheets
- VLOOKUP Advanced 3 – Applying on large data
- VLOOKUP Advanced 4 – Applying across multiple workbooks
14
Pivot Tables
5 topics
- Pivot table basics
- Pivot table basics – common mistakes
- Pivot tables – advanced tips
- How to combine multiple sheet data into one
- Pivot table on multiple sheets, workbooks
15
Charts, 2D Maps, and 3D Maps
11 topics
- MS Excel charts – basics – insert, data control, improve chart, change series
- Pie charts
- Charts – doughnut charts
- Bar charts
- Bubble charts
- 3D containers or cylinders or stacked column
- 2D map charts – basics
- 2D map charts – advanced
- 3D map charts – basics
- 3D map charts – sales with time lapse, scenes creation
- 3D map charts – population with time lapse, scenes creation
16
Macros and VBA
14 topics
- How to enable developer tab
- Macros and VBA basics
- Macros example-1
- Macros example-2
- VBA example-1
- VBA example-2
- 1-10 VBA codes
- 11-20 VBA codes with shortcut key explanation
- 21-40 VBA codes
- VBA case study 1
- VBA case study 2
- Common VBA commands
- Examples of common VBA commands
- VBA textbook – VBA guide basics to advanced
17
Fire Your Boss
20 topics
- Student Mark Sheet Calculation
- Sparklines
- Lines for User Forms
- Data Re-Arrangement with Text to Columns
- Insert Checkboxes
- Insert Data Forms
- Auto Border
- Wrap Rows with VBA
- Compare Data Easily
- Slicer in Excel
- Adjust Image in Excel
- Dynamic Search Bar Creation
- Barcode Creation in Excel
- Data Consolidation
- Copy-Paste Excluding Hidden Data
- Delete Blank Cells
- Advanced Selection, MIN, MAX
- ROUND, ROUNDUP, MROUND
- Swap Columns Data
- Sheet Controls
18
ChatGPT – AI Tools – Add-Ins
13 topics
- MS Excel with ChatGPT – manual script
- MS Excel with ChatGPT – upload image
- MS Excel with ChatGPT – upload and download with formulas
- MS Excel with AI tools – AI-aided formula editor
- MS Excel – add-in – Wikipedia – to collect info
- MS Excel Add-In – FRED – Economic Data
- MS Excel - add-in – mini calendar
- MS Excel - add-in – symbols and characters
- MS Excel – ChatGPT AI ask
- MS Excel – ChatGPT AI fill
- MS Excel – ChatGPT AI translate
- MS Excel – ChatGPT AI extract
- MS Excel – ChatGPT AI table
19
Data Validation
3 topics
- Data Validation – Basics
- Drop-Down List – Dependent Drop-Down List
- Data Validation – On Student Registration
20
Excel Projects, Dashboards, Infographics, and Data Visualization
7 topics
- Automation – Student Admission Management
- Complete Billing Automation – Invoice Design, Tax Calculation, Logo, and More
- Comparison Table: Perpetual Dashboards vs. Interactive-Dynamic Dashboards
- Perpetual-Static Dashboards (Part 1) – Creating KPI (Key Performance Indicators)
- Perpetual-Static Dashboards (Part 2) – KPIs to Visualization
- Interactive-Dynamic Dashboards – Creating Connected KPI-Connect Dashboards
- Financial Reporting Dashboards – Sales, Profit, Country-Wise, Product-Wise
This syllabus is indicative and may be updated to reflect new Microsoft Office releases and updates to Tally Education's curriculum.
What You Will Be Able to Do
- Build and format clean worksheets, and print them properly
- Use SUMIFS, COUNTIFS, IF, IFS, text and date formulas with confidence
- Find data with VLOOKUP, XLOOKUP and INDEX + MATCH
- Summarise large data with PivotTables and charts, including map charts
- Automate repeated work with macros and simple VBA
- Build dashboards and billing sheets, and use ChatGPT and AI tools inside Excel
Who This Course Is For
Complete beginners
It starts from opening Excel and the basic tools, so no prior knowledge is needed.
Students
Build a skill that almost every office job asks for, from anywhere in India.
Working people
Study around your job, with a weekly session for your doubts.
Accounts and MIS staff
Go further with lookups, PivotTables, dashboards and automation.
Your Certificate from Tally Education
There is no exam. When you complete the course on the portal, Tally Education issues your certificate.
Online or Classroom: Which Excel Course Fits You
Microsoft Excel online (this course)
Self-paced, 20 modules, 1-year access, 8 live one-to-one sessions. Certificate from Tally Education.
Advanced Excel with AI, classroom in Baguiati
2 months in class with a trainer, including Excel with AI. Certificate from Tally Institute of Learning.
Why Learn with Tally Institute of Learning
Tally Education
Authorised Training and Assessment Partner, and the only one in Baguiati
7,500+
students trained at our Baguiati centre
4.8 on Google
from 87 reviews (September 2026)
Since 2001
teaching computer and accounting courses
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
Advanced Excel with AI (classroom)
Power BI (classroom)
Computer Basics with MS Office (online)
Compare all course fees
Ready to start? Enrol online now and get your portal login, or ask us anything first. You can read our refund and cancellation policy before you pay.
₹2,950Offer price
The offer price is Rs. 2,950 (September 2026), down from the course fee of Rs. 5,900. It is a one-time payment that covers 1-year portal access, 8 live one-to-one sessions with our trainer and the Tally Education certificate.
You study at your own pace through video lessons, practice files and step-by-step guides on the Tally Education portal. On top of that, you get 8 live one-to-one sessions with our trainer, one 45-minute session a week.
You study at your own pace through video lessons, practice files and step-by-step guides on the Tally Education portal. On top of that, you get 8 live one-to-one sessions with our trainer, one 45-minute session a week.
No. When you complete the course on the portal, Tally Education issues your certificate. There is no test.
No. When you complete the course on the portal, Tally Education issues your certificate. There is no test.
Yes. The course starts from opening Excel and the basic tools, and goes step by step to advanced formulas, PivotTables, macros, VBA and dashboards.
Yes. The course starts from opening Excel and the basic tools, and goes step by step to advanced formulas, PivotTables, macros, VBA and dashboards.
Yes. One module covers using ChatGPT and AI tools with Excel, including AI-aided formulas and add-ins.
Yes. One module covers using ChatGPT and AI tools with Excel, including AI-aided formulas and add-ins.
You get 1 year of access to the course on the Tally Education learning portal.
You get 1 year of access to the course on the Tally Education learning portal.
A missed session can be rescheduled with our team, so you still get all 8 sessions.
A missed session can be rescheduled with our team, so you still get all 8 sessions.
Yes. Our Advanced Excel with AI course runs in class at our Baguiati centre in Kolkata for 2 months and ends with a certificate from Tally Institute of Learning.
Yes. Our Advanced Excel with AI course runs in class at our Baguiati centre in Kolkata for 2 months and ends with a certificate from Tally Institute of Learning.
BAGUIATI CENTRE
Ready to Master Excel?
Enroll online and start learning from home.
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.