Certificate Course in Tally Excel

The Certificate Course in Tally & Excel is a practical, job-oriented accounting course designed for students, accountants, and professionals who want to build strong skills in computerized accounting, GST, and Excel reporting.

This course combines Tally Prime with Advanced Excel, making learners industry-ready for accounting, taxation, and office roles.

 

Career Opportunities

After completing the Certificate Course in Tally & Excel, you can work as:

• Junior Accountant

• Accounts Executive

• Tally Operator

• MIS Executive

• Back-Office Executive

 

Fee :15600/-

Duration :5 Months

Content:

* Accounting Introduction (TH).
* About GST(TH).
* About TDS(TH).
* Creating A Company With GST.
* Company GST Configuration.
* Setting up a New Company.
* Creating Ledgers.
* Sub Ledger/Ceating Groups/Account Heads
* Voucher Entry/Payment/Receipt Voucher.
* Contra Entry/Purchase/Sales Register.
* Funds Flow,Cash Flow.
* Cost Centre,Cost & Ratio Analysis.
* Creating Trial Balance.
* Viewing Statement of Accounts.
* Profit & LossAccount,Balance Sheet.
* Bank Reconciliation,Interest Calculation.
* Printing of Accounts,Bank & Cash Books.
* Display of Accounts,CompanyConfiguration

INVENTORY

* Stock Items,Physical Stock Voucher.
* Creating Units of Measure.
* Rejection In & Out.
* Purchase & Sales Order,Multi Currency.
* Invoicing,Bill/Stock Wise.
* Reversing Journal.
* Debit Note/Credit Notes.

* Multiple Godowns , Tracking Numbers.
* Rejection Notes , Sales/Purchase With GST.
* Stock journal , Sales Order Processing.
* Purchase Order Processing, Physical Stock.
* Inventory Reports, Interest calculation.
* Bill Of Material (BOM)
* Backup,Restore
* Memo Voucher, Post Dated Voucher.
* Physical Stock.
* Installation.
* Stock Journal.
* Job Work.

PAYROLL

* Configuring Payroll.
* Creating payroll masters.
* Employer PF Contributions.
* Employer ESI Contributions.
* Payment Of Professional Tax.
* Payroll Report.
* Pay Slip Creation.
* Attendence Sheet Creation.
* Employer Income Tax File .
* Indivisual PaySlip & Group Payslip Create.
* Create Basic Pay,DA,HRA,TA Etc.

ADVANCE EXCEL

* VLOOKUP , HLOOKUP , INDEX , MATCH .
* PMT , IPMT ,PPMT.XLOOKUP
* Dynamic Excel Formula.
* Attendance Sheet. Salary Sheet.
* Use IF,IFS,IFERROR,SUMIF,COUNTIF.
* logical Fuctions, Search Formula.
* Gol seek, Scenario Manager.
* Link With Macro.
* 3D Formula.
* Link File to File or Sheet to Sheet.
* Pivot Table and Pivot Chart, Slicer,Timeline
* MIS Report.
* 2-Way Lookup in Excel.
* Automative Repetitive tasks in Excel Using Macro.
* 5 Excel Project With Macro ,Without Macro.
* Editing and Formating charts.
* What if analysis.
* Filtering Data , Advance Filter.
* Sorting Data.
* Consolidating Worksheet Charts.
* Tables.Generate Tax invoice in Excel
* Balance Sheet ,P&L A/C in Excel.
* File Link with Google Sheets.