9007116752

c3creativedomain@gmail.com

C-Cube

Centre of Computer Education

Accounts Training Institute

1) Get hands-on Tally skills and accelerate your career
in Financial Accounting.
2) The course content teaches students in detail how to
manage and maintain accounts, inventory and payroll.
3) The course is designed for both beginners as well as
professionals to work independently in the field of accounts.
4) This course will enable you to take all business decisions of your own.
Training Partners

Tally Prime with GST Training For Beginners

  • Module 1

    Basic Accounting Principles , Tally Introduction , Tally Shortcuts Keys, Company Creation

  • Module 2

    Ledger Creation , Cost Center , Voucher Creation , Stock Creation , Reports Checking

  • Module 3

    GST (Goods & Service Tax) Implementation , Import and Export Tally to Excel , TDS , BRS (Bank Reconciliation Statement), Payroll , Backup and Restore,

Quick Contact Form


    Minimum Eligibility         10 + 2 Pass
    Course Duration               3 Months
    Mode of Training             Online & Offline

    Diploma in Financial Accounting Course

    Tally Prime with GST Training

    • Module 1

      Company Info Menu - Select Company • Shut company • Create company • Alter company • Security control • Change tally vault • Split company data • Backup • Restore • Tally audit feature

    • Module 2

      Accounting Information -Accounting Configuration & Features • Group Creation • Multiple Group Creation • Ledger Creation • Multiple Ledger Creation • New Voucher Creation • Advance Ledger Creation

    • Module 3

      Inventory Information • Inventory configuration & features • Inventory info. Menu • Stock groups • Stock categories • Stock item • Unit of measurement • Bills of materials • Locations / Godowns • Batches & Expiry • Inventory voucher types

    • Module 4

      Voucher Entry • Accounting voucher • Inventory voucher • optional & non-accounting voucher • Advanced voucher entry • Cost category & cost centres • Budgets • Interest calculations • Cheque printing

    • Module 5

      Display financial statements (Display balance – sheet, configuring the balance sheet, Integrate accounts with inventory, setting closing stock manually in the balance sheet with different stock valuation methods) • Display profit & loss A/c(configuring profit & loss A/c , income/expense statement instead of P&L) • Display trial balance (configuring in trial balance) • Display registers & ledgers (display sales register , purchase register, cash book , bank book, journal register, day book, statement of account

    • Module 6

      Start Using Tally. Prime For GST Compliance • Activating GST For Your Company • Setting Up GST Rates • Updating Stock Items and Stock Groups for GST Compliance • Updating a Service Ledger for GST Compliance • Updating Sales and Purchase Ledgers for GST Compliance • Updating Party GSTIN • Creating GST Ledgers • Creating Income and Expense Ledgers • Recording Sales and Printing Invoices • Recording Purchases • Recording a Tax Payment • Recording Sales Returns • Recording Purchase Returns GSTR-1 • Returns Summary • Particulars (Computation Details) • Summary of Exceptions • Table-wise GSTR-1 • Status Reconciliation • Exporting GSTR-1

    Complete MS-Excel Training (Basic & Advance Level included )

    • Module 1- Basic Excel

      Excel Introduction , An overview of the screen, navigation and basic spreadsheet concepts Various selection techniques , Shortcut Keys

    • Module 2

      Using Basic Functions Using Functions – Sum , Average , Max ,Min , Count , Counta Absolute, Mixed and Relative Referencing

    • Module 3

      Formatting and Proofing- Formatting Cells with Number formats, Font formats, Alignment, Borders, Basic conditional formatting

    • Module 4

      Mathematical Functions - SumIf , SumIfs , CountIf , CountIfs , AverageIf , AverageIfs , Text Functions - Upper, Lower, Proper Left, Mid, Right Trim, Len, Exact , Concatenate Find, Substitute

    • Module 5

      DATE AND TIME FUNCTIONS - Today, Now Day, Month, Year Date, Date if, DateAdd EOMonth, Weekday , ADVANCED PASTE SPECIAL TECHNIQUES - Paste Formulas, Paste Formats Paste Validations Transpose Tables

    • Module 6

      Sorting and Filtering - Filtering on Text, Numbers & Colors Sorting Options , Advanced Filters on 5-10 different criteria(s)

    • Module 7- Advanced Excel

      WHAT IF ANALYSIS - Goal Seek , Scenario Analysis , Data Tables (PMT Function) , LOGICAL FUNCTIONS - If Function , How to Fix Errors – iferror , Nested If , Complex if and or functions

    • Module 8

      WHAT IF ANALYSIS - Goal Seek , Scenario Analysis , Data Tables (PMT Function) , LOGICAL FUNCTIONS - If Function , How to Fix Errors – iferror , Nested If , Complex if and or functions

    • Module 9

      LOOKUP FUNCTIONS Vlookup / HLookup , Index and Match , Creating Smooth User Interface Using Lookup , Nested VLookup , Reverse Lookup using Choose Function , Worksheet linking using Indirect , Vlookup with Helper Column

    • Module 10

      PIVOT TABLES Creating Simple Pivot Tables, Basic and Advanced Value Field Setting , Classic Pivot table , Grouping based on numbers and Dates , Calculated Field & Calculated Items , CHARTS and slicers Various Charts i.e. Bar Charts / Pie Charts / Line Charts Using SLICERS, Filter data with Slicers Manage Primary and Secondary Axis

    Minimum Eligibility         10 + 2 Pass
    Course Duration               6 Months
    Mode of Training             Online & Offline

    Open chat
    1
    Powered by Joinchat
    Hello , How can I help you ?