Microsoft Excel - Beginner to Advanced Online Course

(413) Ratings
(659) Learners

Master Microsoft Excel from Beginner to Advanced level with our self-paced online course designed for learners across India. Build practical skills in data management, formulas, charts, PivotTables, dashboards, and automation through structured, hands-on lessons. Whether youre a student, working professional, or entrepreneur, this course from Tally Institute of Learning helps you use Excel confidently for smarter data handling and better decision-making.

100K+
Trained Students
25+
Years of Excellence
100%
Practical Training
Course Image
👨‍🎓 789 learners already enrolled
Mode of Course

online

Course Duration

8 hrs

Course Fee

₹2400

Offer Price

₹1200

Eligibility

Open to All (Basic Computer Knowledge Preferred)

Chat with us
Microsoft Excel - Beginner to Advanced

Gain deep knowledge of Microsoft Excel from basics to advanced levels, covering everything from data entry, logical functions, and pivot tables, to mastering macros and VBA for automation and custom scripting.

Become proficient in Microsoft Excel at all levels, enhance your data management skills, and boost your career prospects in diverse professional fields.

Benefit from a blended learning format that includes charts, screenshots, step-by-step guides, and online access with expert support, allowing you to learn at your own pace and accommodate your schedule.

SPECIAL FOR YOU
Weekly Live
Doubt-Clearing
Session

Get dedicated support every week with 1 live session of 45 minutes for clearing doubts and resolving queries related to the course content.

What you learn
MS Excel Modules 1–5 +
Module 1: Start-Up +
M1.1 How to open MS Excel
M1.2 Start screen – navigating MS Excel
M1.3 User interface – navigating MS Excel
M1.4 Home tab basic editing tools
M1.5 Copy and paste – using multiple tools in MS Excel
Module 2: Basic Tools to Know+
M2.1 Customize ribbon bar – tabs, groups, commands – tools
M2.2 Text to column – multiple methods
M2.3 Speak cells – data reading tool
M2.4 Comments – add, edit, delete and customize
M2.5 Filters in MS Excel
M2.6 Freeze panes and split screen
Module 3: Fill Series and Data, Sheet Controls+
M3.1 Fill series – basics
M3.2 Fill series – advanced
M3.3 Fill series – flash fill
M3.4 Conditional formatting
M3.5 Hyperlinks to sheets, webpages, files
M3.6 Header and footer settings
M3.7 Printing and paper settings
M3.8 Import data from web
M3.9 Import data from text document with auto refresh
M3.10 Import-text word ppt jpeg video- pdf & more objects
Module 4: Working with Sheets+
M4.1 Characteristics of a cell
M4.2 Cell references – relative ref, absolute ref, mixed ref
M4.3 Custom view
M4.4 Sheet protection
M4.5 Cell protection
M4.6 Compare sheets side by side – view sheets side by side
M4.7 Compare sheets from multiple files
M4.8 Working with cells, rows, columns, specific size, auto fit
M4.9 Working with sheets rename, colour, copy, move, grouping
Module 5: Sum-Related Formulas+
M5.1 Things to Remember Before Starting Formulas
M5.2 SUM
M5.3 SUMIF
M5.4 SUMIFS
M5.5 SUBTOTAL
M5.6 AGGREGATE
M5.7 SUMPRODUCT
M5.8 SUMSQ
M5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 – Mathematics and Trigonometry
M5.10 DSUM – Database Sum
M5.11 IMSUM vs IMSUB – Complex Data Calculations
MS Excel Modules 6–10 +
Module 6: Average-Related Formulas+
M6.1 Average
M6.2 AVERAGEA
M6.3 AVERAGEIF vs AVERAGEIFS
M6.4 Weighted average with VBA code
Module 7: Count-Related Formulas+
M7.1 COUNT, COUNTA, COUNTBLANK
M7.2 COUNTIF vs COUNTIFS
Module 8: Logical IF-Related Formulas+
M8.1 Logical test with comparative operators
M8.2 If
M8.3 If and vs if or
M8.4 IFS vs NESTEDIF
M8.5 IFERROR
M8.6 Switch
Module 9: Text Extraction and Manipulation+
M9.1 LEFT, RIGHT, MID, and LEN
M9.2 Find vs search
M9.3 Replace vs substitute
Module 10: Text Formatting and Conversion+
M10.1 CONCAT vs CONCATENATE
M10.2 Text
M10.3 Upper, lower, proper
M10.4 Trim
M10.5 SPELLNUMBER with VBA Code
M10.6 Text-to-number with VBA code
MS Excel Modules 11–15 +
Module 11: Date & Time-Related Formulas+
M11.1 Using TODAY, NOW
M11.2 DATE, DATEVALUE, TIME, TIMEVALUE
M11.3 DATEDIF and Extracting Years, Months, Days, Hours, Minutes, Seconds
M11.4 Calculating Future and Past Dates – EDATE, EOMONTH, WORKDAY, NETWORKDAYS
M11.5 Calculate days using – DAY, DAYS, NETWORKDAYS
M11.6 Calculate hours and hourly charges
Module 12: Finance-Related Formulas+
M12.1 PMT – EMI Calculator
M12.2 PPMT, IPMT – Loan Statement Preparation
M12.3 FV – Investment Calculator
Module 13: Data Search & Lookup-Related Formulas+
M13.1 VLOOKUP – Basics, Rules, Exact Match, Approx. Match
M13.2 HLOOKUP – Basics
M13.3 XLOOKUP Function – With VBA Code
M13.4 MATCH function vs INDEX function
M13.5 VLOOKUP Advanced 1 – Applying across multiple cells at a time
M13.6 VLOOKUP Advanced 2 – Applying across multiple sheets
M13.7 VLOOKUP Advanced 3 – Applying on large data
M13.8 VLOOKUP Advanced 4 – Applying across multiple workbooks
Module 14: Pivot Tables+
M14.1 Pivot table basics
M14.2 Pivot table basics – common mistakes
M14.3 Pivot tables – advanced tips
M14.4 How to combine multiple sheet data into one
M14.5 Pivot table on multiple sheets, workbooks
Module 15: Charts, 2D Maps, and 3D Maps+
M15.1 MS Excel charts – basics – insert, data control, improve chart, change series
M15.2 Pie charts
M15.3 Charts – doughnut charts
M15.4 Bar charts
M15.5 Bubble charts
M15.6 3D containers or cylinders or stacked column
M15.7 2D map charts – basics
M15.8 2D map charts – advanced
M15.9 3D map charts – basics
M15.10 3D map charts – sales with time lapse, scenes creation
M15.11 3D map charts – population with time lapse, scenes creation
MS Excel Modules 16–20 +
Module 16: Macros and VBA+
M16.1 How to enable developer tab
M16.2 Macros and VBA basics
M16.3 Macros example-1
M16.4 Macros example-2
M16.5 VBA example-1
M16.6 VBA example-2
M16.7 1-10 VBA codes
M16.8 11-20 VBA codes with shortcut key explanation
M16.9 21-40 VBA codes
M16.10 VBA case study 1
M16.11 VBA case study 2
M16.12 Common VBA commands
M16.13 Examples of common VBA commands
M16.14 VBA textbook – VBA guide basics to advanced
Module 17: Fire Your Boss+
M17.1 Student Mark Sheet Calculation
M17.2 Sparklines
M17.3 Lines for User Forms
M17.4 Data Re-Arrangement with Text to Columns
M17.5 Insert Checkboxes
M17.6 Insert Data Forms
M17.7 Auto Border
M17.8 Wrap Rows with VBA
M17.9 Compare Data Easily
M17.10 Slicer in Excel
M17.11 Adjust Image in Excel
M17.12 Dynamic Search Bar Creation
M17.13 Barcode Creation in Excel
M17.14 Data Consolidation
M17.15 Copy-Paste Excluding Hidden Data
M17.16 Delete Blank Cells
M17.17 Advanced Selection, MIN, MAX
M17.18 ROUND, ROUNDUP, MROUND
M17.19 Swap Columns Data
M17.20 Sheet Controls
Module 18: ChatGPT – AI Tools – Add-Ins+
M18.1 MS Excel with ChatGPT – manual script
M18.2 MS Excel with ChatGPT – upload image
M18.3 MS Excel with ChatGPT – upload and download with formulas
M18.4 MS Excel with AI tools – AI-aided formula editor
M18.5 MS Excel – add-in – Wikipedia – to collect info
M18.6 MS Excel Add-In – FRED – Economic Data
M18.7 MS Excel - add-in – mini calendar
M18.8 MS Excel - add-in – symbols and characters
M18.9 MS Excel – ChatGPT AI ask
M18.10 MS Excel – ChatGPT AI fill
M18.11 MS Excel – ChatGPT AI translate
M18.12 MS Excel – ChatGPT AI extract
M18.13 MS Excel – ChatGPT AI table
Module 19: Data Validation+
M19.1 Data Validation – Basics
M19.2 Drop-Down List – Dependent Drop-Down List
M19.3 Data Validation – On Student Registration
Module 20: Excel Projects, Dashboards, Infographics, and Data Visualization+
M20.1 Automation – Student Admission Management
M20.2 Complete Billing Automation – Invoice Design, Tax Calculation, Logo, and More
M20.3 Comparison Table: Perpetual Dashboards vs. Interactive-Dynamic Dashboards
M20.4 Perpetual-Static Dashboards (Part 1) – Creating KPI (Key Performance Indicators)
M20.5 Perpetual-Static Dashboards (Part 2) – KPIs to Visualization
M20.6 Interactive-Dynamic Dashboards – Creating Connected KPI-Connect Dashboards
M20.7 Financial Reporting Dashboards – Sales, Profit, Country-Wise, Product-Wise
Course Duration

8 hrs

Course Fees

₹2400

₹1200 (Flexible Payment Options)

Chat with us on WhatsApp
Blended Learning

Combines text materials with interactive video content for comprehensive learning.

Interactive Materials

Explainer videos, quizzes, and infographics for engaging learning.

Verifiable Certificate

Digital certificate verified by Tally upon course completion.

Job Portal Access

Connect with employers and boost career prospects.

Why Train with Us
Experience

25+ years experience in IT Education and making sttudents Job ready.

Quality

We have an excellent team of highly skilled and experienced trainers.

Curriculum

Our course curriculum is in tune with the industry requirements.

Placement

We offer 100% Placement Assistance along with Soft Skills training.

Tally Logo
BAGUIATI CENTRE

Ready to Master Excel?

Join thousands of successful professionals who transformed their careers.

Sign Up for Special Offer on Course Fee

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.