Diploma in Tally Prime & Advanced Excel Course
⇒ Fees Rs. ?,?00/-
⇒ Duration: 8 Weeks
⇒ Work on Projects & Assignments
⇒ All Inclusive of Books, Certification and GST
⇒ Software Covered : Microsoft Excel
⇒ Fast Track Batch Available
Module 1 : Tally Prime
⇒ Basic Of Accounting
⇒ Basic Of Tally Prime
⇒ Advanced Accounting Voucher
⇒ Advanced Inventory Voucher
⇒Bank Reconcilation
⇒Multi Currency
⇒Cost Center & Cost Category
⇒ Bills Of Materials (BOM)
⇒ Goods & Service Tax (GST)
⇒ Tax Deducted At Source (TDS)
⇒ Payroll System
⇒ MIS Report
⇒ Data Security
⇒ Assignments
Module 1 : Advance Microsoft Excel
⇒ Electronic Spreadsheet basics
⇒ Formatting Fonts, Numbers
⇒ Relative & Absolute Reference
⇒ Date & Currency Formatting
⇒ Formula charts & Graphs
⇒ 2D/3D Graphs, Pie, Line Cone
⇒ Formatting Charts
⇒ Data Values
Module 2 : Advance Microsoft Excel
⇒ Sub Total Reports, ⇒ Auto Filter
⇒ Sorting Data
⇒ Password Protecting Worksheets
⇒ Linking Multiple Sheets
⇒ Sheet Referencing
⇒ Linking Between Word/Excel/Ppt
⇒ COUNTIF, SUMIF.
⇒ What-if-analysis
⇒ Pivot Tables, Pivot Charts
⇒ NESTED IF
⇒ Reporting
⇒ Character Functions
⇒ Scenario Manager
⇒ Date Functions
⇒ Age Calculations
⇒ Consolidation of Data
⇒ Data Validation
⇒ Logical Functions
⇒ MACROS Definition & Concepts
⇒ Record & Run a Macro
⇒ Store a Macro
⇒ Intro to VBA Prog
Best Business Management Software
Foundation Industrial Accountant (FIA)
Learn Tally Prime With GST. Join Skillsthetic’s Foundation Industrial Accountant Tally Prime With GST. Authorized Training Institute In Maharashtra. Enroll now for Tally Prime course and Boost Your Career.
Certified Business Accountant And Taxation (CBAT)
Skillsthetic Was set up with a vision to be a mentor and guide to Accounting professional, Tax Practitioner and Student help them in every possible way. Learn Complete Tally Prime, GST, Income Tax, TDS, Finalization, MIS Report, Labour Law From Basic To Expert Mode
