Course Details
Home - Course Details
Best Advanced Excel Course in Mumbai
- 15 Lessons
- 6 Studenst
Description
Upgrade your Excel skills with our Advanced Excel Course in Mumbai! Learn formulas, PivotTables, VLOOKUP, dashboards, and MIS reporting — all with practical training, certification, and job support. Ideal for students, professionals, and business owners.
Join today at MCAT Computer Education, Malad, Mumbai
Course Overview
Introduction to Accounting & Tally
Basics of Accounting & Golden Rules
Tally Fundamentals & Interface
Chart of Accounts
Creation of Accounting Masters (Ledger, Group)
Accounting Vouchers (Payment, Receipt, Contra, Journal)
Sales & Purchase Voucher
Inventory Vouchers and Stock Items
Stock Categories & Units
Order Processing with Tracking Numbers
Receipt & Delivery Notes
Rejection In/Rejection Out
Debit/Credit Notes
Purchase/Sales Invoicing with Batch-wise Details
Manufacturing Journals
Voucher Class & Optional Vouchers
Cost Centres & Categories
Budgeting & Control
Multiple Currencies Handling
Stock Journals & Physical Stock Entry
Interest Calculations
Company Features (F11)
Backup, Restore & Data Security
Export/Import of Data
Introduction to GST & Its Structure
GST Classification & Master Setup
Invoice Creation with GST
GST Return Filing & Reports
TDS (Tax Deducted at Source)
TCS (Tax Collected at Source)
Income Tax Basics
Auto GST Configuration in Tally
E-Way Bill (Overview)
Trial Balance & Stock Summary
Profit & Loss Account
Balance Sheet
Interest Calculation
Bank Reconciliation Statement (BRS)
Inventory Reports & Order Levels
Price List Management
Overdue Tracking / Credit Sales
Tally Vault & Audit Control
Final Company Data Splitting/Consolidation
FAQ
Find answers to common questions about our offline/Online Excel course — including duration, class timings, topics covered, certification, and job support. Everything you need to know before joining!
The course duration is approximately 2 to 2.5 months, depending on the student’s pace and batch timing.
Accounting Vouchers (Sales, Purchase, Receipt, Payment, etc.)
Inventory Management
GST Setup & Invoicing
TDS/TCS/Income Tax
Reports like Trial Balance, Profit & Loss, Balance Sheet
Advanced Tally Features like Cost Centres, Budgets, and more
Yes! The course covers complete GST setup, invoice creation, and return filing using Tally Prime.
Anyone who has completed 10th or 12th standard, and wants to build a career in accounting, business, or finance can join. Ideal for students, freelancers, and small business owners.
Yes! After completing the course, you can apply for jobs like Tally Operator, Accounts Assistant, GST Executive, etc. We also provide career guidance and project-based practice.
