Certificate Course in Tally Excel

Our institution is committed to delivering high-quality education that bridges the gap between academic learning and industry demands. With a focus on practical, hands-on training, we offer a diverse range of courses, including Certification Couse in Excel, Tally Professional Certificate Program, Certificate Course in Taxation, DCA, Tally Prime, Taxation, GST, TDS, INCOME TAX, Microsoft Excel, C, C++, JAVA, and more.

Whether you are a beginner looking to kick start your career or a professional aiming to upskill. Tally Academy provides tailored programs designed to help you achieve your goals. Over the 20 years, we have established ourselves as a trusted name in education, empowering individuals to excel in their chosen fields and become industry-ready professionals.

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.

All rights reserved. ©Copyright of ITCC Tally Academy since 2002.